Lightning Admin Community Forums
May 27, 2011, 07:53:40 PM
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Version 1.3.4 Build 20 released on January 16th, 2007
   Home   Help Login Register  
Pages: [1]
  Reply  |  Print  
Author Topic: I am a Firebird user why should I switch?  (Read 1586 times)
Support Administrator
PGLA Level3

Posts: 214

« on: August 17, 2007, 11:37:45 PM »

Well there are many reasons.
  • Far superior documentation.
  • PostgreSQL has full support for temp tables.
  • PostgreSQL has MANY built in functions, while Firebird only has a few.
  • Ability to use several stored procedure languages.  PLPGSQL, PLPerl, PLPHP,PLJava to name a few.
  • No weird dialects.  PostgreSQL's syntax is amazingly clean even when going back many versions.
  • Has a real Text Field type, no weird blob syntax.
  • Uses write ahead logs, so Point in time recovery is possible and supported.
  • Scales extremely well on big iron servers with many CPUs.
  • Has a built in auto vacuum feature, you DO NOT have to do a backup and restore to compact your databases.
  • Your data is stored in a cluster and database info such as names etc are stored in the system tables.
  • Has more authentication systems then Firebird (such as ident,LDAP etc).
  • Stable release cycle. The PostgreSQL project releases new version about once per year. since 2005 we have seen the release of 8.0,8.1 and 8.2 and 8.3 is due for late 2007

Plus many more.

Firebird and PostgreSQL also share many features such as MVCC, 2 phased commit and a native win32 version.

We believe that PostgreSQL is much better suited for heavy duty Enterprise class work than Firebird.  This does not mean Firebird is not a capable database.

If you are using Firebird for it's embedded DLL mode, then PostgreSQL would not be a option for you because the embedded space is not something the PostgreSQL project ever wishes to do.

We simply recommend that you try it out and see for yourself how great it really is.
« Last Edit: August 21, 2007, 08:33:36 AM by Support Administrator » Logged

« Reply #1 on: May 21, 2011, 02:20:33 AM »

Home run! Great sluggnig with that answer!

« Reply #2 on: May 21, 2011, 02:28:43 PM »

Touchdown! That's a raelly cool way of putting it!
Pages: [1]
  Reply  |  Print  
Jump to:  

Powered by SMF 1.1.4 | SMF © 2006-2007, Simple Machines LLC