20.1 Firebird
20220607
The firebird database originated from Borland’s release of the InterBase source code. On Ubuntu it can be installed as:
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:
Connect to the database:
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
