What do you think of Postgres and Firebird Databas

Question

I am trying to choose between postgre and firebird databasses. The database will be installed on a windows 2003 server with asp.net 3.5. i don't want to use sql server because of price issues and I don't want MySQL I had a bad experience with it and the .net connector and the membership provider.

Answer 1

Firebird + FreeadhocUDFs + IBExpert, and just programming.

we have 2 systems in production for 6 years (20 domains, 200 tables, 50 views, 370 stored procedures, 600 triggers, 205 generators, 11, roles, etc, etc) and have been tested to migrate to PostgreSQL (only test, we love Firebird).

In tables with traditional data types (integer, varchar, date, numeric, etc, etc.) differences could be for one or the other, as appropriate, but in stored procedures, Firebird is much more powerful than Postgresql, much more simple and elegant.

Two or three years, any Linux distribution, not including Firebird, only Mysql and Postgresl. Not for nothing today, but tradicionesles distributions (ubunutu / opensuse / fedora / centos, etc, etc) and Firebird include in their repositories.

Postgresql do not say that is worse than Firebird, Firebird is not that much better than Postgresql. But without hesitation I say that Firebird has nothing to envy to Postgresql, and in many ways is more powerful.

(sorry for my bad english)

Answer 2

Why don't you try SQL Express a scaled down version of SQL from Microsoft which is free to use.

Answer 3

Most of the features are the same on both however I recommend Firebird 1. FB - supports multiple collation within a table 2. FB - more choices on mature drivers to work with 3. FB - connection managed by either Thread or Process depend on your use/setup 4. FB - embedded support

Not recommend Stay away MS SQLExpress

A little Draw back 1. FB - blob handling is not so great if condition below are true but if you move blob column(s) into separated table, then no issue with blob a. massive data mining/manipulating b. blob column(s) is/are defined with other data columns

Answer 4

They are both cool. However, one BIG advantage for Firebird is it's .net data provider. Good mature solution, vs buggy npgsql (or some paid Postgres drivers). So it it mostly to chose what db you are more familiar with or what are your developement team skills.

Both Postgres and Firebird are excellent databases.

Answer 5

I always worked with Firebird since 2005 writing application in Delphi, C# and ASP.NET. I never had a corrupt database in my projects. I never needed to work with another database. Why Firebird instead of PostgreSQL? Because Firebird is:

• Easy to Install and Configure;
• Very stable;
• Lightweight (Firebird 2.5 Download: 6,4MB / Postgresql 9.0 Download: 47MB);
• OpenSource;
• Easy deployment (PSQL);
• Crossplatform (Win32 / Win64 / Linux x86 / Linux AMD64 / MacOS X / Solaris / HP-UNIX);
• No need for DBAs;
• Embedded engine;

Well. If you are using Firebird you dont need another Database. :)

Answer 6

I've always been impressed with Postgres; it's traditionally had a more complete feature set (in terms of ACID compliance, support for advanced queries, etc.) than MySQL, it has solid Windows ODBC drivers, and its documentation scrupulously points out any areas in which it deviates from the SQL standard. (All databases, it seems, deviate in one respect or another, but Postgres is the only one I've seen that makes sure you know when you're doing so.) I haven't tried the usage scenario you describe, but I've had no problems running it on Linux and accessing it from both Windows ODBC and Linux clients.

I don't have any experience with Firebird; sorry.