Slashdot Mirror

← Back to Stories (view on slashdot.org)

PostgreSQL vs. SAP?

Posted by Cliff on from the RDBMS-battle-of-the-heavyweights dept.

Johann asks: "As my friend and I embark on building a large web site using open source development tools, I planned on using PostgreSQL. I was reminded that another 'enterprize' database is now released under the GPL - SAP DB. Since there have been countless Pg vs. MySQL comparisons on Slashdot, I wanted to ask: how does SAP DB compare technically to Pg?"

3 of 97 comments (clear)

  1. One thing to consider... by zulux · · Score: 3, Interesting

    I love PostgeSQL - it's worked wonderfully for us, but....

    In all seriousness, if you use SAP DB, you could probably raise your rates just due to the SAP name alone. The name 'SAP' is also good for covering your ass when things get difficult.

    SAP and Oracle have expensive reputations and you can charge accordingly. We do it all the time, for some of our nastier customers, when anything with the word 'Cisco' on it need care.

    It depends on the relationship you have with your custome, wether you go that route, but it's worth considering.

    --

    Moneyed corporations, non-working 'poor' and criminal prisoners are turning productive citizens into tax-slaves.

  2. The Slashdot Example by fm6 · · Score: 5, Interesting
    And Slashdot uses MySQL. Could you even ask for a more shining recommendation?
    In point of fact, Slashdot has some nasty workarounds for basic limitations of MySQL. The most heavily-retrieved queries are provided by static pages to avoid overtaxing the MySQL server.

    Also Slashdot now numbers each and every post uniquely. Contrary to popular myth, this was not done to reduce FPs. When they needed two fields (the story number and the post-within-story number) for their primary key, they took a nasty performance hit.

    So if we use Slashdot as an example (and I have to admit it's the only big MySQL application I know much about), then we have to conclude that MySQL's much-touted performance lead goes away if your database has more than the most trivial structure, or if your database gets very large.

  3. anyone else notice the history of SAP by bjpirt · · Score: 3, Interesting

    something strange going on here ;-)

    http://www.sapdb.org/history.htm