 | | From: | Francois Suter | | Subject: | Comparisons | | Date: | Mon, 10 Jan 2005 11:02:58 +0100 |
|
|
 | Hi again,
I forgot something in my previous post. At the end of the article, the journalist mentions two comparisons:
http://support.summersault.com/why_postgresql.html http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
Are they any good?
Cheers.
--------------- Francois
Home page: http://www.monpetitcoin.com/
"If it's not from me, it's from Confucius" - Lao Tse
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
|
|
 | | From: | Mitch Pirtle | | Subject: | Re: Comparisons | | Date: | Mon, 10 Jan 2005 09:39:42 -0500 |
|
|
 | On Mon, 10 Jan 2005 11:02:58 +0100, Francois Suter wrote: > Hi again, > > I forgot something in my previous post. At the end of the article, the > journalist mentions two comparisons: > > http://support.summersault.com/why_postgresql.html > http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html > > Are they any good?
The first one is a nice document from a PR and advocacy perspective (but could use some updating); and the second is a year out-of-date and (to me at least) appears biased - not good at all.
-- Mitch
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
|
|
 | | From: | José_de_Paula | | Subject: | Re: Comparisons | | Date: | Thu, 20 Jan 2005 10:22:18 -0200 |
|
|
 | Mitch Pirtle wrote: > On Mon, 10 Jan 2005 11:02:58 +0100, Francois Suter wrote: > >>Hi again, >> >>I forgot something in my previous post. At the end of the article, the >>journalist mentions two comparisons: >> >>http://support.summersault.com/why_postgresql.html >>http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html >> >>Are they any good? > > > The first one is a nice document from a PR and advocacy perspective > (but could use some updating); and the second is a year out-of-date > and (to me at least) appears biased - not good at all. > > -- Mitch > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend >
I liked the table at summersault wrt features of the several databases; does anyone know about a similar chart comparign PostgreSQL's and Oracle's SQL language syntax? I'm thinking about migrating a system from Oracle to PostgreSQL, and I would like to know how painless this could be done.
|
|
 | | From: | Josh Berkus | | Subject: | Re: Comparisons | | Date: | Thu, 20 Jan 2005 12:37:59 -0800 |
|
|
 | Jose,
> I liked the table at summersault wrt features of the several databases; > does anyone know about a similar chart comparign PostgreSQL's and > Oracle's SQL language syntax? I'm thinking about migrating a system from > Oracle to PostgreSQL, and I would like to know how painless this could > be done.
Check out O'Reilly's book "SQL In A Nutshell". It does command-by-command comparisons of SQL syntax with PG, Oracle, MSSQL and MySQL.
--Josh
-- --Josh
Josh Berkus Aglio Database Solutions San Francisco
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
|
|
 | | From: | José_de_Paula | | Subject: | Re: Comparisons | | Date: | Fri, 21 Jan 2005 13:28:32 -0200 |
|
|
 | Josh Berkus wrote: > Jose, > > >>I liked the table at summersault wrt features of the several databases; >>does anyone know about a similar chart comparign PostgreSQL's and >>Oracle's SQL language syntax? I'm thinking about migrating a system from >>Oracle to PostgreSQL, and I would like to know how painless this could >>be done. > > > Check out O'Reilly's book "SQL In A Nutshell". It does command-by-command > comparisons of SQL syntax with PG, Oracle, MSSQL and MySQL. > > --Josh >
Thanks, I'll look for it.
|
|
 | | From: | Chris Travers | | Subject: | Re: Comparisons | | Date: | Thu, 20 Jan 2005 23:24:05 -0800 |
|
|
 | BTW, does anyone know why the first of the articles lists MS SQL Server as not being ACID compliant? It might be good to know.
Best Wishes, Chris Travers Metatron Technology Consulting
José de Paula wrote:
> Mitch Pirtle wrote: > >> On Mon, 10 Jan 2005 11:02:58 +0100, Francois Suter >> wrote: >> >>> Hi again, >>> >>> I forgot something in my previous post. At the end of the article, the >>> journalist mentions two comparisons: >>> >>> http://support.summersault.com/why_postgresql.html >>> http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html >>> >>> Are they any good? >> >> >> >> The first one is a nice document from a PR and advocacy perspective >> (but could use some updating); and the second is a year out-of-date >> and (to me at least) appears biased - not good at all. >> >> -- Mitch >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 8: explain analyze is your friend >> > > I liked the table at summersault wrt features of the several > databases; does anyone know about a similar chart comparign > PostgreSQL's and Oracle's SQL language syntax? I'm thinking about > migrating a system from Oracle to PostgreSQL, and I would like to know > how painless this could be done. > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > >
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
|
|