SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Zealot
    Join Date
    May 2003
    Location
    somewhere on the Earth
    Posts
    113
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Firebird v.s PostGreSQL ???

    i'm now building a database. triggers and stored proceedures are involved. what're the pros and cons between the two in this aspect? BTW, it's running on a Xp machine and i consider the one which is easier to develop would be better. the app using the db will be written in PHP.

  2. #2
    SitePoint Zealot
    Join Date
    May 2003
    Location
    somewhere on the Earth
    Posts
    113
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    doesn't anyone know anything about this matter?

  3. #3
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    A bit late, but better than never

    On Windows, Firebird may be better as you can get a native binary and some nice admin tools.

    On the whole, Postgres is probably better, simply because it's more widely known/used.
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  4. #4
    SitePoint Zealot
    Join Date
    May 2003
    Location
    somewhere on the Earth
    Posts
    113
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I heard that postgresql will have a native windows version soon. If so, considering the learning curve, which is easier to learn? I'm new to both and learning firebird currently. I feel it a bit hard, since there's no more tutorial-like article , just a single phoneix doc, which is a little bit difficult for beginners. maybe postgresql is easier?

  5. #5
    Non-Member
    Join Date
    Nov 2002
    Location
    Earth
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Check out this comparison chart - it's pretty up-to-date:

    mysql vs. postgresql vs. maxdb vs. firebird
    http://www.geocities.com/mailsoftware42/db/

  6. #6
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by zjcboy
    I heard that postgresql will have a native windows version soon. If so, considering the learning curve, which is easier to learn? I'm new to both and learning firebird currently. I feel it a bit hard, since there's no more tutorial-like article , just a single phoneix doc, which is a little bit difficult for beginners. maybe postgresql is easier?
    There's almost certainly more info out there for Postgres. Firebird 1.5 is not really well documented. However there is a very good set of free PDF documentation for Interbase 6.0/Firebird 1.0 which you can download from the Firebird website. Worth a look.

    I personally found Firebird relatively easy, although I didn't look at it in depth. I may go back and look at it as an alternative to SQL Server/MSDE for ASP.NET applications (they now have a .NET data provider). I don't know what client tools Postgres has, but for Firebird you can get IBExpress Personal Edition which makes poking round in the database much easier.

    One other thing you may want to consider - Firebird's footprint on your system is very small. I'm not sure about Postgres, but I notice fairly big slowdowns running MSDE on older Windows systems.
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •