Thread: Postgres Compare
Hello, anybody have any url or document comparing PostgreSQL Vs. MS-SqlSever ?
Thanks
Pedro
Rosario-Argentina
Here compares PostgreSQL MySQL and Oracle,,, I was looking for something like this and the only thing I found was it:
yours
Cris..
----- Original Message -----From: Pedro C. AriasSent: Tuesday, April 15, 2003 2:15 PMSubject: [GENERAL] Postgres CompareHello, anybody have any url or document comparing PostgreSQL Vs. MS-SqlSever ?ThanksPedroRosario-Argentina
http://www.mysql.com/information/crash-me.php?ms_sql=on&postgres=on Due to the source of the data, take it with a grain of salt, but it will give you a good basic comparison of postgresql vs. m$ sql server. Please note the comparison is against postgresql 7.2.2; we've added a significant number of features since then. Also don't forget this comparison leaves out important features like postgresql's ability to support 7 different procedural languages. Robert Treat On Tue, 2003-04-15 at 15:01, Cristina Surroca wrote: > Here compares PostgreSQL MySQL and Oracle,,, I was looking for something > like this and the only thing I found was it: > > http://det-dbalice.if.pw.edu.pl/det-dbalice/documents/all/html/db_compar > e/db_compar_chp06.html > <http://det-dbalice.if.pw.edu.pl/det-dbalice/documents/all/html/db_compa > re/db_compar_chp06.html> > yours > > Cris.. > > ----- Original Message ----- > From: Pedro C. Arias <mailto:parias@unr.edu.ar> > To: PostgreSQL-GENERAL <mailto:pgsql-general@postgresql.org> > Sent: Tuesday, April 15, 2003 2:15 PM > Subject: [GENERAL] Postgres Compare > > Hello, anybody have any url or document comparing PostgreSQL Vs. > MS-SqlSever ? > > Thanks > > Pedro > Rosario-Argentina >
Well the article seems to be comparing a pre 7.1 postgresql with others. the planner has undergone many imporvements since then. regds mallah. > Here compares PostgreSQL MySQL and Oracle,,, I was looking for something like this and the only > thing I found was it: > > http://det-dbalice.if.pw.edu.pl/det-dbalice/documents/all/html/db_compare/db_compar_chp06.html > yours > > Cris.. > ----- Original Message ----- > From: Pedro C. Arias > To: PostgreSQL-GENERAL > Sent: Tuesday, April 15, 2003 2:15 PM > Subject: [GENERAL] Postgres Compare > > > Hello, anybody have any url or document comparing PostgreSQL Vs. MS-SqlSever ? > > Thanks > > Pedro > Rosario-Argentina ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/
> -----Original Message----- > From: Robert Treat [mailto:xzilla@users.sourceforge.net] > Sent: Tuesday, April 15, 2003 12:46 PM > To: Cristina Surroca > Cc: Pedro C. Arias; PostgreSQL-GENERAL > Subject: Re: [GENERAL] Postgres Compare > > > http://www.mysql.com/information/crash-me.php?ms_sql=on&postgres=on > > Due to the source of the data, take it with a grain of salt, > but it will give you a good basic comparison of postgresql > vs. m$ sql server. Please note the comparison is against > postgresql 7.2.2; we've added a significant number of > features since then. Also don't forget this comparison leaves > out important features like postgresql's ability to support 7 > different procedural languages. For the ODBC functions, our (CONNX) PostgreSQL driver supports all of the functions listed and many others as well. Here is the manual: http://www.connx.com/products/connx/Connx%208.8%20UserGuide/connxcdd32.h tm If you click on the ODBC SQL Grammar book, there are lots of details underneath of all the operations supported. For instance, with our ODBC driver for PostgreSQL, you could query for skew of the sample or the name of the month, etc. So, with PostgreSQL, you can get that sort of additional functionality if it is wanted. Also, for a PostgreSQL success story, we are currently using our own native Win32 port of PostgreSQL to empower our data synchronization engine.
I also think if everyone helps out with the documentation, that could go a long way.... So enhancing PG can have two tracks, the designer track and tech-writer track... While enhacing a rich software system is more time consuming, we can nail the documentatiion in little time....and from the new adopters point of view, the ease of orientation and usage can win their hart easily... Robert Treat wrote: >http://www.mysql.com/information/crash-me.php?ms_sql=on&postgres=on > >Due to the source of the data, take it with a grain of salt, but it will >give you a good basic comparison of postgresql vs. m$ sql server. Please >note the comparison is against postgresql 7.2.2; we've added a >significant number of features since then. Also don't forget this >comparison leaves out important features like postgresql's ability to >support 7 different procedural languages. > >Robert Treat > >On Tue, 2003-04-15 at 15:01, Cristina Surroca wrote: > > >>Here compares PostgreSQL MySQL and Oracle,,, I was looking for something >>like this and the only thing I found was it: >> >>http://det-dbalice.if.pw.edu.pl/det-dbalice/documents/all/html/db_compar >>e/db_compar_chp06.html >><http://det-dbalice.if.pw.edu.pl/det-dbalice/documents/all/html/db_compa >>re/db_compar_chp06.html> >>yours >> >>Cris.. >> >>----- Original Message ----- >>From: Pedro C. Arias <mailto:parias@unr.edu.ar> >>To: PostgreSQL-GENERAL <mailto:pgsql-general@postgresql.org> >>Sent: Tuesday, April 15, 2003 2:15 PM >>Subject: [GENERAL] Postgres Compare >> >>Hello, anybody have any url or document comparing PostgreSQL Vs. >>MS-SqlSever ? >> >>Thanks >> >>Pedro >>Rosario-Argentina >> >> >> > > >---------------------------(end of broadcast)--------------------------- >TIP 6: Have you searched our list archives? > >http://archives.postgresql.org > >
What kind of tools are needed to help with the documentation? Medi Montaseri wrote: > I also think if everyone helps out with the documentation, that could go > a long way.... > So enhancing PG can have two tracks, the designer track and tech-writer > track... > While enhacing a rich software system is more time consuming, we can > nail the documentatiion > in little time....and from the new adopters point of view, the ease of > orientation and usage > can win their hart easily... > > > Robert Treat wrote: > >> http://www.mysql.com/information/crash-me.php?ms_sql=on&postgres=on >> >> Due to the source of the data, take it with a grain of salt, but it will >> give you a good basic comparison of postgresql vs. m$ sql server. Please >> note the comparison is against postgresql 7.2.2; we've added a >> significant number of features since then. Also don't forget this >> comparison leaves out important features like postgresql's ability to >> support 7 different procedural languages. >> Robert Treat >> >> On Tue, 2003-04-15 at 15:01, Cristina Surroca wrote: >> >> >>> Here compares PostgreSQL MySQL and Oracle,,, I was looking for something >>> like this and the only thing I found was it: >>> >>> http://det-dbalice.if.pw.edu.pl/det-dbalice/documents/all/html/db_compar >>> e/db_compar_chp06.html >>> <http://det-dbalice.if.pw.edu.pl/det-dbalice/documents/all/html/db_compa >>> re/db_compar_chp06.html> yours >>> >>> Cris.. >>> >>> ----- Original Message ----- From: Pedro C. Arias >>> <mailto:parias@unr.edu.ar> To: PostgreSQL-GENERAL >>> <mailto:pgsql-general@postgresql.org> Sent: Tuesday, April 15, 2003 >>> 2:15 PM >>> Subject: [GENERAL] Postgres Compare >>> >>> Hello, anybody have any url or document comparing PostgreSQL Vs. >>> MS-SqlSever ? >>> >>> Thanks >>> >>> Pedro >>> Rosario-Argentina >>> >>> >> >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 6: Have you searched our list archives? >> >> http://archives.postgresql.org >> >> > > > ---------------------------(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 >
Hopefully just vi(1)....or an HTML editor.... But qualified staff can comment....I'm not sure if there is any automations behind the scenes.. Dennis Gearon wrote: > What kind of tools are needed to help with the documentation? > > Medi Montaseri wrote: > >> I also think if everyone helps out with the documentation, that could >> go a long way.... >> So enhancing PG can have two tracks, the designer track and >> tech-writer track... >> While enhacing a rich software system is more time consuming, we can >> nail the documentatiion >> in little time....and from the new adopters point of view, the ease >> of orientation and usage >> can win their hart easily... >> >> >> Robert Treat wrote: >> >>> http://www.mysql.com/information/crash-me.php?ms_sql=on&postgres=on >>> >>> Due to the source of the data, take it with a grain of salt, but it >>> will >>> give you a good basic comparison of postgresql vs. m$ sql server. >>> Please >>> note the comparison is against postgresql 7.2.2; we've added a >>> significant number of features since then. Also don't forget this >>> comparison leaves out important features like postgresql's ability to >>> support 7 different procedural languages. >>> Robert Treat >>> >>> On Tue, 2003-04-15 at 15:01, Cristina Surroca wrote: >>> >>> >>>> Here compares PostgreSQL MySQL and Oracle,,, I was looking for >>>> something >>>> like this and the only thing I found was it: >>>> >>>> http://det-dbalice.if.pw.edu.pl/det-dbalice/documents/all/html/db_compar >>>> >>>> e/db_compar_chp06.html >>>> <http://det-dbalice.if.pw.edu.pl/det-dbalice/documents/all/html/db_compa >>>> >>>> re/db_compar_chp06.html> yours >>>> >>>> Cris.. >>>> >>>> ----- Original Message ----- From: Pedro C. Arias >>>> <mailto:parias@unr.edu.ar> To: PostgreSQL-GENERAL >>>> <mailto:pgsql-general@postgresql.org> Sent: Tuesday, April 15, >>>> 2003 2:15 PM >>>> Subject: [GENERAL] Postgres Compare >>>> >>>> Hello, anybody have any url or document comparing PostgreSQL Vs. >>>> MS-SqlSever ? >>>> >>>> Thanks >>>> >>>> Pedro >>>> Rosario-Argentina >>>> >>>> >>> >>> >>> >>> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 6: Have you searched our list archives? >>> >>> http://archives.postgresql.org >>> >>> >> >> >> ---------------------------(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 >> >
On Tue, 2003-04-15 at 18:38, Dennis Gearon wrote: > What kind of tools are needed to help with the documentation? You'll need the DocBook SGML toolset; there's information here on what you'll need to install: http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=docguide.html The SGML is stored in the CVS tree along with the main PostgreSQL source code (it's in doc/src/sgml); be sure to use the latest CVS HEAD code, as there have been significant changes to the documentation since the 7.3 release. If you'd like to contribute improvements to the documentation (which would be great), but don't feel like learning SGML right now, you can also just send in plaintext "diffs" or corrections to pgsql-docs, and someone can convert them to SGML for you (I'm happy to do it, as it only takes 30 seconds). Cheers, Neil
On Tuesday 15 April 2003 11:24 pm, Neil Conway wrote: > On Tue, 2003-04-15 at 18:38, Dennis Gearon wrote: > > What kind of tools are needed to help with the documentation? > > You'll need the DocBook SGML toolset; there's information here on what > you'll need to install: > > http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=docguide.ht >ml > > The SGML is stored in the CVS tree along with the main PostgreSQL source > code (it's in doc/src/sgml); be sure to use the latest CVS HEAD code, as > there have been significant changes to the documentation since the 7.3 > release. > > If you'd like to contribute improvements to the documentation (which > would be great), but don't feel like learning SGML right now, you can > also just send in plaintext "diffs" or corrections to pgsql-docs, and > someone can convert them to SGML for you (I'm happy to do it, as it only > takes 30 seconds). > And don't forget the idocs :-) Robert Treat
Is there any list of "things-to-doc" to both attend to the most immediate needs and avoid duplicate work... Neil Conway wrote: >On Tue, 2003-04-15 at 18:38, Dennis Gearon wrote: > > >>What kind of tools are needed to help with the documentation? >> >> > >You'll need the DocBook SGML toolset; there's information here on what >you'll need to install: > >http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=docguide.html > >The SGML is stored in the CVS tree along with the main PostgreSQL source >code (it's in doc/src/sgml); be sure to use the latest CVS HEAD code, as >there have been significant changes to the documentation since the 7.3 >release. > >If you'd like to contribute improvements to the documentation (which >would be great), but don't feel like learning SGML right now, you can >also just send in plaintext "diffs" or corrections to pgsql-docs, and >someone can convert them to SGML for you (I'm happy to do it, as it only >takes 30 seconds). > >Cheers, > >Neil > > >
The link for the information on the DocBook SGML toolset below is bad/empty return. Medi Montaseri wrote: > Is there any list of "things-to-doc" to both attend to the most > immediate needs and avoid > duplicate work... > > Neil Conway wrote: > >> On Tue, 2003-04-15 at 18:38, Dennis Gearon wrote: >> >> >>> What kind of tools are needed to help with the documentation? >>> >> >> >> You'll need the DocBook SGML toolset; there's information here on what >> you'll need to install: >> >> http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=docguide.html >> >> >> The SGML is stored in the CVS tree along with the main PostgreSQL source >> code (it's in doc/src/sgml); be sure to use the latest CVS HEAD code, as >> there have been significant changes to the documentation since the 7.3 >> release. >> >> If you'd like to contribute improvements to the documentation (which >> would be great), but don't feel like learning SGML right now, you can >> also just send in plaintext "diffs" or corrections to pgsql-docs, and >> someone can convert them to SGML for you (I'm happy to do it, as it only >> takes 30 seconds). >> >> Cheers, >> >> Neil >> >> >> > > > >
Also,
The code for parsing browser languages is still wrong. I checked my browser preferences, I have English FIRST, and
RussianSECOND, but I get a RUSSIAN page when I go to:
http://www.postgresql.org/.
Medi Montaseri wrote:
> Is there any list of "things-to-doc" to both attend to the most
> immediate needs and avoid
> duplicate work...
>
> Neil Conway wrote:
>
>> On Tue, 2003-04-15 at 18:38, Dennis Gearon wrote:
>>
>>
>>> What kind of tools are needed to help with the documentation?
>>>
>>
>>
>> You'll need the DocBook SGML toolset; there's information here on what
>> you'll need to install:
>>
>> http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=docguide.html
>>
>>
>> The SGML is stored in the CVS tree along with the main PostgreSQL source
>> code (it's in doc/src/sgml); be sure to use the latest CVS HEAD code, as
>> there have been significant changes to the documentation since the 7.3
>> release.
>>
>> If you'd like to contribute improvements to the documentation (which
>> would be great), but don't feel like learning SGML right now, you can
>> also just send in plaintext "diffs" or corrections to pgsql-docs, and
>> someone can convert them to SGML for you (I'm happy to do it, as it only
>> takes 30 seconds).
>>
>> Cheers,
>>
>> Neil
>>
>>
>>
>
>
>
>
Well,
Now the link is working also. After looking at the page, I can't work on this in it's final format because I do not
havea working linux setup. I might in the near future though.
What about just generating content, and having someone else pasting it into the tools?
Medi Montaseri wrote:
> Is there any list of "things-to-doc" to both attend to the most
> immediate needs and avoid
> duplicate work...
>
> Neil Conway wrote:
>
>> On Tue, 2003-04-15 at 18:38, Dennis Gearon wrote:
>>
>>
>>> What kind of tools are needed to help with the documentation?
>>>
>>
>>
>> You'll need the DocBook SGML toolset; there's information here on what
>> you'll need to install:
>>
>> http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=docguide.html
>>
>>
>> The SGML is stored in the CVS tree along with the main PostgreSQL source
>> code (it's in doc/src/sgml); be sure to use the latest CVS HEAD code, as
>> there have been significant changes to the documentation since the 7.3
>> release.
>>
>> If you'd like to contribute improvements to the documentation (which
>> would be great), but don't feel like learning SGML right now, you can
>> also just send in plaintext "diffs" or corrections to pgsql-docs, and
>> someone can convert them to SGML for you (I'm happy to do it, as it only
>> takes 30 seconds).
>>
>> Cheers,
>>
>> Neil
>>
>>
>>
>
>
>
>
As Neil mentioned below, sending plain text diffs to the -docs list will probably suffice, though I'm sure those guys would much rather see sgml based patches. After a few minutes of googleing I came up with the following: http://regina.sourceforge.net/docbook.html (Windows DocBook Support) I'm sure there are more out there. Please also remember that any plain text editor will be able to edit the files, they just might be a bit hard to work with with all of the tags in the document. (think editing html docs in notepad) Robert Treat On Wed, 2003-04-16 at 13:24, Dennis Gearon wrote: > Well, > Now the link is working also. After looking at the page, I can't work on this in it's final format because I do nothave a working linux setup. I might in the near future though. > What about just generating content, and having someone else pasting it into the tools? > > Medi Montaseri wrote: > > Is there any list of "things-to-doc" to both attend to the most > > immediate needs and avoid > > duplicate work... > > > > Neil Conway wrote: > > > >> On Tue, 2003-04-15 at 18:38, Dennis Gearon wrote: > >> > >> > >>> What kind of tools are needed to help with the documentation? > >>> > >> > >> > >> You'll need the DocBook SGML toolset; there's information here on what > >> you'll need to install: > >> > >> http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=docguide.html > >> > >> > >> The SGML is stored in the CVS tree along with the main PostgreSQL source > >> code (it's in doc/src/sgml); be sure to use the latest CVS HEAD code, as > >> there have been significant changes to the documentation since the 7.3 > >> release. > >> > >> If you'd like to contribute improvements to the documentation (which > >> would be great), but don't feel like learning SGML right now, you can > >> also just send in plaintext "diffs" or corrections to pgsql-docs, and > >> someone can convert them to SGML for you (I'm happy to do it, as it only > >> takes 30 seconds). > >> > >> Cheers, > >> > >> Neil
I searched that link, Regina does not work on Windows with the current version. But I will look around. Also, I might get more enthused about fixing my interrupts on my win95 machine and then reinstalling Suse or something onmy linux partition. Robert Treat wrote: > As Neil mentioned below, sending plain text diffs to the -docs list will > probably suffice, though I'm sure those guys would much rather see sgml > based patches. > > After a few minutes of googleing I came up with the following: > http://regina.sourceforge.net/docbook.html (Windows DocBook Support) > I'm sure there are more out there. > > Please also remember that any plain text editor will be able to edit the > files, they just might be a bit hard to work with with all of the tags > in the document. (think editing html docs in notepad) > > Robert Treat > > On Wed, 2003-04-16 at 13:24, Dennis Gearon wrote: > >>Well, >> Now the link is working also. After looking at the page, I can't work on this in it's final format because I do nothave a working linux setup. I might in the near future though. >> What about just generating content, and having someone else pasting it into the tools? >> >>Medi Montaseri wrote: >> >>>Is there any list of "things-to-doc" to both attend to the most >>>immediate needs and avoid >>>duplicate work... >>> >>>Neil Conway wrote: >>> >>> >>>>On Tue, 2003-04-15 at 18:38, Dennis Gearon wrote: >>>> >>>> >>>> >>>>>What kind of tools are needed to help with the documentation? >>>>> >>>> >>>> >>>>You'll need the DocBook SGML toolset; there's information here on what >>>>you'll need to install: >>>> >>>>http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=docguide.html >>>> >>>> >>>>The SGML is stored in the CVS tree along with the main PostgreSQL source >>>>code (it's in doc/src/sgml); be sure to use the latest CVS HEAD code, as >>>>there have been significant changes to the documentation since the 7.3 >>>>release. >>>> >>>>If you'd like to contribute improvements to the documentation (which >>>>would be great), but don't feel like learning SGML right now, you can >>>>also just send in plaintext "diffs" or corrections to pgsql-docs, and >>>>someone can convert them to SGML for you (I'm happy to do it, as it only >>>>takes 30 seconds). >>>> >>>>Cheers, >>>> >>>>Neil > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >