Ah, finally someone who have worked with Firebird!
Can you please elaborate on the Firebird vs. Postgresql front a little?
Meir Kriheli wrote:
What languages does firebird support?3. Multi languages for business logic:
PostgreSQL (PL/pgsql, PL/python, PL/perl etc..)
It's own internal language. Compared to PostgreSQL's is very limited (PGSQL is quite impressive). You'll probably have to extend it.
Firebird's extensions can be written in plain C and compiled to a libray (called UDF). There are several available (for *nix and windows, some including source), Like FreeUDF. For more UDFs see:
http://ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_udf_libs
5. Quality of tools for db management (FOSS/proprietary):
Firebird, MySQL
Can you please elaborate? I take it that you are either unaware of pgAccess and pgAdmin, or find them severely lacking compared to their other DB counterparts. If the later, can you please say what you are missing there?
I know them and several others (e.g: phpPgAdmin, Tora). Thanks to the Interbase heritage and great Delphi integration, there are many tools, some are quite impressive (many are non FOSS). For example:
http://www.ibexpert.com/ http://gmarathon.sourceforge.net/ (OSS - MPL)
or schema comparers like (we use it for distributing changes in business logic during development):
http://clevercomponents.com/downloads/index.asp
You can gather some tools for PostgreSQL for some of the functionality, but from what I saw, can't match the above (specialy IBExpert, makes developing businesss logic a breeze).
For more tools: http://ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_admin_tools
Also, is there any fundemental feature currently missing from either, and distinctly available in the other? For example, I'm missing updateable cursors in Postgresql. Does firebird have them?
We're moving a complex project right now from FB to PGSQL (and changing backend to J2EE). The thing we miss the most in FB is multiple schema support.
We also had problems with gbak when exporting BLOBs (in 1.0.x at least, not verified in 1.5.0).
Otherwise FB is a great DB (I was the Gentoo maintainer of it's ebuild, retired a couple of weeks ago, lack of time):
- Small footprint
- flexible in layout (you can place db files anywhere you wish for example).
- Can be embedded in your application if needed
- Easy admin/maint
As for updateble cursors , sorry, no info.
Cheers -- Meir Kriheli http://mksoft.co.il
================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
