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:
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
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
Show quoted text
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>
yoursCris..
----- 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 CompareHello, 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
yoursCris..
----- Original Message -----
From: Pedro C. Arias
To: PostgreSQL-GENERAL
Sent: Tuesday, April 15, 2003 2:15 PM
Subject: [GENERAL] Postgres CompareHello, 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 Comparehttp://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.
Import Notes
Resolved by subject fallback
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:
Show quoted text
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>
yoursCris..
----- 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 CompareHello, 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?
What kind of tools are needed to help with the documentation?
Medi Montaseri wrote:
Show quoted text
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 TreatOn 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> yoursCris..
----- 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 CompareHello, 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?---------------------------(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:
Show quoted text
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 TreatOn 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_compare/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 CompareHello, 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?---------------------------(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
mlThe 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:
Show quoted text
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:
Show quoted text
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 Russian SECOND, but I get a RUSSIAN page when I go to:
http://www.postgresql.org/.
Medi Montaseri wrote:
Show quoted text
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 have 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:
Show quoted text
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
Show quoted text
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 not have 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 on my linux partition.
Robert Treat wrote:
Show quoted text
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 not have 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)