Firebird News

Monday, January 12, 2009

creating an db with isql-fb in firebird classic

If you try to create an db from isql-fb utility and you use firebird classic
then you might need to add the host in the connection string

$ isql-fb -user SYSDBA -password masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database "/var/lib/firebird/2.1/data/fooozz.fdb"
CON> ;
Statement failed, SQLCODE = -902
cannot attach to password database
SQL>

Here is the correct way to create the database with classic
$ isql-fb -user SYSDBA -password masterkey
SQL> create database "localhost:/var/lib/firebird/2.1/data/fooozz.fdb"
CON> ;


.:():..:():..:():.

Even Postgresql developers prefer Firebird over Mysql

Read an interesting interview where one developer when asked

If you should decide between Firebird and MySQL, though it would not be available to PostgreSQL, what with you in a generally won? And why?

I have three years of application development platform for Interbase / Firebird. So it is clear what I have preferences. Firebird is a very nice small compact database that I like and fandím it.



.:():..:():..:():.