I'm surprised nobody mentioned Firebird. I started using it since 1.0 and I cannot complain.
And yes, this is reason not to use PostgreSQL. Friend of mine has been now forced to use postgres, complaining every day (he is ending up dropping whole database schema nearly each day because of altering some view/SP and postgres not controlling dependencies, about syntax and usability where firebird use for select into var suspend etc. etc.).
Most importantly, Firebird have a decent learning curve. Syntax is very comfortable for users, kinterbasdb is functioning nicely (even PHP has now documented connection set)...
Functions in postgres are acting like functions (suprise!), which is what I do not want, I want SP using from my apps. When functions, then UDF.
No, really. Any reason to switch to postgres from firebird?
Slashdot Mirror
Strange. We've got experience with ~50G FB without any issues... Also true that this was webapp, not Delphi app, so another type of use.
I'm surprised nobody mentioned Firebird. I started using it since 1.0 and I cannot complain. And yes, this is reason not to use PostgreSQL. Friend of mine has been now forced to use postgres, complaining every day (he is ending up dropping whole database schema nearly each day because of altering some view/SP and postgres not controlling dependencies, about syntax and usability where firebird use for select into var suspend etc. etc.). Most importantly, Firebird have a decent learning curve. Syntax is very comfortable for users, kinterbasdb is functioning nicely (even PHP has now documented connection set)... Functions in postgres are acting like functions (suprise!), which is what I do not want, I want SP using from my apps. When functions, then UDF. No, really. Any reason to switch to postgres from firebird?