Today, I tested the possiblity to use the embedded Firebird database in my movie application.
The negatives I've found this far:
1) Firebird has no autoincrement fields. Just like oracle, you need to create a sequence/generator.
2) There are a lot of reserved words in Firebird, like "Character". To delimit the keywords, use double quotes. The columns can be best in uppercase, because then you can also access the columns without quotes.
3) "drop table if exists.." does not work.
4) DML and DDL cannot be used together. This complicates the creation of sql scripts.
5) Many DLL's are needed to run the embedded database. 7 MB at minimum. This is much more than Sqlite.
update 3-10-2012: Firebird is much slower than Sqlite. It was nice to test with Firebird, but as an embedded database, it is too slow. And it misses a lot of handy's because it is too old...
Geen opmerkingen:
Een reactie posten