FirebirdSQL
Jump to navigation
Jump to search
Firebird is an open source RDBMS server that uses SQL for inserting, selecting and updating data. It's very fast, capable, flexible, and runs on UNIX, Linux, Mac and Windows platforms.
Quick Start
Install firebird from your distribution.
- Start firebird on your local computer with
/etc/init.d/firebird2.0-super start
(actual command may vary depend on the flavor and version installed)
- Build up a connection to firebird:
isql-fb (or /opt/firebird/bin/isql) sql> connect /home/user/mydatabase.fdb user sysdba password masterkey; sql> show tables; sql> select 'enter a valid sql command here!' from rdb$database;
- Change the password of sysdba
gsec -user sysdba -password masterkey gsec>modify sysdba -pw newpassword gsec>quit
- Create a new database user
gsec -user sysdba -password masterkey gsec>add newuser -pw newpassword gsec>quit
GUI's include
- FlameRobin
Install on debian
It seems to official packages in debian are broken (as for version 1.5 and 2.0). You can find a script to install firebird in debian (site is in Spanish)
See also
External links
- Firebird SQL Project Homepage (www.firebirdsql.org)