| Author |
 Topic  |
|
|
sr_erick
Senior Member
USA
1318 Posts |
 Posted - 14 November 2003 : 15:17:34
|
| Hello all, not sure where to post this. How hard would it be to convert my forum to postgresql? Easy, hard? I heard it supports a lot of the queries MS SQL does. |
Erick
Snowmobile Fanatics
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 14 November 2003 : 15:44:13
|
I took a shot at a conversion once, but hit a large stumbling block with postgresql's case-sensitivity. When I tried (a year or so ago) the ODBC driver converted all the table names & column names to lowercase in the db and all the code puked with upper-case table names & column names. I checked some postgresql newsgroups & the designers indicated they were not interested in altering this behaviour, and I gave up.
postgresql is a good dbms otherwise, stable, fast, more full-featured as compared to MySQL.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 November 2003 : 16:33:26
|
| I also think postgresql is a better choice as a dbms when compared to MySQL. Obviously Doug has a valuable experience trying to use it with Snitz... and it seems it may mean a lot of code changes to have Snitz working with it. Of course, if you were not talking about Snitz support, I think postgresql would be a better choice than MySQL, IMO. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 14 November 2003 : 17:39:11
|
Currently postgresql is a bit ahead of MySQL, but I have set up a beta of MySQL 5, which seems to fill a lot of the missing features from MySQL 3.5x. The biggest advantage of MySQL is the widespread use it has in open source software, and the ease of setup of most MySQL based software. Postgres is not as widely implemented, and sometimes you need to do additional steps to install a postgresql backend vs. a MySQL backend.
I haven't stressed either, and both dbms's have performed well for me for my local apps.
I would like to find a good, free OLEDB driver for either or both db's.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 14 November 2003 : 17:41:53
|
| Is the version 5 of MySQL pretty stable? I might be forced to move to some other DB platform other than MS SQL. I think MySQL, 5, would be my first choice as it supports those things that were missing before. |
Erick
Snowmobile Fanatics
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 14 November 2003 : 21:05:57
|
quote:
Originally posted by sr_erick
Is the version 5 of MySQL pretty stable? I might be forced to move to some other DB platform other than MS SQL. I think MySQL, 5, would be my first choice as it supports those things that were missing before.
I have only set it up, connected with MySQLFront and did some basic tests, also playing with php5 beta at the same time. I tried installing one php portal against this MySQL and PHP version but it puked.
One thing you'll notice is a change in password encryption in MySQL5, which will make any databases you create with v5 inaccessible using most pre-v5 MySQL tools. I didn't see a v5 updated MySQL control center.
I'm not sure if IN is supported in v4, which is my big headache with MySQL v3. If it is, I'd just wait for v5 to stabilize. There is information on www.mysql.com describing the differences between versions.
I don't think INFORMATION_SCHEMA is in v5 beta.
I'm more interested in PHP5! Classes in pre-PHP5 are retarded :)
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 15 November 2003 : 14:55:45
|
| Yeah I am looking for the best option. I know either way it will probably be quite a bit of work for all my stuff to work. No chance in hell I am going to go back to access after seeing the great speed increases I am getting with MS SQL. |
Erick
Snowmobile Fanatics
|
|
|
| |
Topic |
|
Topic Locked
