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> ;

.:(firebird):..:(databases):..:(sql):.

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.

.:(firebird):..:(databases):..:(sql):.