20.1 Firebird

20220607

The firebird database originated from Borland’s release of the InterBase source code. On Ubuntu it can be installed as:

wajig install firebird3.0-server

Basic operation:

$ sudo isql-fb
SQL> CONNECT 'clinc.fdb' USER 'kayon' PASSWORD 'mysecret';

TODO Why does this need top be run as sudo?

Setup a sample database:

zcat /usr/share/doc/firebird3.0-examples/examples/employee.sql.gz | sudo isql-fb -b -user sysdba -q

Connect to the database:

sudo isql-fb -user sysdba employee.fdb
Database: employee.fdb, User: SYSDBA
SQL>

Select the data from the table:

SQL> select * from employee;

 EMP_NO FIRST_NAME      LAST_NAME            PHONE_EXT ...
======= =============== ==================== ========= ...
      2 Robert          Nelson               250       ...
      4 Bruce           Young                233       ...
      5 Kim             Lambert              22        ...
      8 Leslie          Johnson              410       ...
      9 Phil            Forest               229       ...
     11 K. J.           Weston               34        ...
     12 Terri           Lee                  256       ...
     14 Stewart         Hall                 227       ...
     15 Katherine       Young                231       ...
     20 Chris           Papadopoulos         887       ...
...


Your donation will support ongoing availability and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2022 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0