mORMot Open Source

AOG

Member

Registered: 2014-02-24

Posts: 490

Firebird embedded as SQLite3 replacement

Hello Ab,

Could you give me your opinion about using Firebird embedded as the embedded database instead of SQLite3 for mORMot ?
It could add some more configuration posibilities and extra features.

Greetings and thanks.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,231

Website

Re: Firebird embedded as SQLite3 replacement

The main feature of Sqlite3 used in mORMot is virtual tables.
AFAIK this feature is not available in Firebird.

Another issue with Firebird embedded is that it is (much) slower than SQlite3, and files are (much) bigger.

If you need Firebird, you could use it as external DB (preferred via SynDBZeos.pas).
But IMHO it is not a good replacement for the mORMot core.

AOG

Member

Registered: 2014-02-24

Posts: 490

Re: Firebird embedded as SQLite3 replacement

Thanks. That's (missing virtual tables) indeed a no-go !