knowledge-database (beta)

Current group: pgsql.advocacy

Comparisons

Comparisons  
Francois Suter
 Re: Comparisons  
Mitch Pirtle
 Re: Comparisons  
José_de_Paula
 Re: Comparisons  
Josh Berkus
 Re: Comparisons  
José_de_Paula
 Re: Comparisons  
Chris Travers
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
   

Copyright © 2006 knowledge-database   -   All rights reserved