MySQL vs. Postgresql

[Inhanse]

Hmmm.... This article is rather interesting, but not so far I found rather interestng articled about MySQL here too: http://phpforms.net/tutorial/tutorial.html

[MattR]

Sybase ASE documentation is here:
http://manuals.sybase.com/onlinebook...ew;pt=asg1200e

[fastforward]

The documentation for Oracle can be viewed on-line at http://technet.oracle.com . You have to register, but it's free. You can also access their trial download area with the same login.

I'm starting to get problems with mysql on my boards now. It crashes once a month. The worst part is the length of time it takes to repair the tables. I'm guessing it will only get worse as the tables get bigger. I'd go to innodb, but I need to buy a bigger hard drive first. I couldn't believe how much extra space innodb needs .

[Wayne Luke]

Hmmm. The complete documentation for Oracle comes on several CD's... 10 if I recall correctly.

However you can get the gist of it from their reference CD which is only 492 megabytes. Don't think you can download it though.

Anyway, I have personal experience with Oracle, Sybase and Ms-SQL Server.

The query syntax for Sybase and MS-SQL Server are pretty much the same. However Oracle's is completely different.

[chrispadfield]

www.dbforums.com is the place to start your search.

[Woody]

I don't know of a site that does off hand. You could go to the home page for each database and scan the docs.

[Billy]

Is there any site that shows the differences in query syntax between the major RDBMS's(pgSQL,msSQL,mySQL,oracle,sybase).

[Chris Schreiber]

Originally posted by Sinecure
I have been doing a lot of comparing and contrasting for which one is better.

Same here.... technically speaking, I am convinced PostgreSQL is better... however there have been some severe limitations and speed issues in the past, but with each new release they seem to be getting much better. For most sites with less traffic, MySQL seems to be a better choice most of the time.

[Sinecure]

Well I am hoping that perhaps there will be versions in the future for postgreSQL. I have been doing a lot of comparing and contrasting for which one is better.
vB guys always do whats right

[etones]

newer versions of postgre wipe the floor with the ailing MySQL... its a fact

[JamesUS]

I'm good at MS SQL (and have a license as well ). I'm not a developer though.

[Kaizen]

[Chris Schreiber]

Originally posted by Kaizen
Is there anyone on vbulletin (developers) that knows how to use these alternative databases ?

There sure are

[Kaizen]

Is there anyone on vbulletin (developers) that knows how to use these alternative databases ?

[George L]

Originally posted by Lynn
But look at another article written a little more recently by the same author:

http://www.phpbuilder.com/columns/tim20001112.php3

I see the tide turning toward PostGreSQL every where I look/read, and therefore I think it should be a high priority for vBulletin developer's to make vBulletin support PostGreSQL.

wow bringing back a thread that's over 1 yrs old