MySQL vs. Postgresql

[John]

An interesting article:

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

John

[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.

[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

[Kaizen]

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

[Chris Schreiber]

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

There sure are

[Kaizen]

[JamesUS]

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

[etones]

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

[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

[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.

[Billy]

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

[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.

[chrispadfield]

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

[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.

[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 .