|
Author |
Message |
Gandalf
WebHelper
Joined: 08 Jan 2002
Posts: 52
Location: Israel
|
Posted:
Sat Jan 12, 2002 11:12 pm (22 years, 3 months ago) |
|
Is PostgreSQL worth the effort of learning it? I'm already familiar with MySQL, and was wondering whether PostgreSQL is everything it's cracked up to be. Does it offer any major advantages over MySQL? Any general opinions? Any good (and cheap) hosts (like Cyberwings) that run that database server? |
________________________________ Everything should be made as simple as possible, but no simpler. |
|
|
|
Garth Farley
WebHelper
Joined: 08 Jan 2002
Posts: 69
Location: Ireland
|
Posted:
Mon Jan 14, 2002 3:37 pm (22 years, 3 months ago) |
|
PostgreSql was OpenSource far earlier than MySql, so at first it was more popular with the Linux groups.
It is a more reliable database under load, giving fewer "Too Many Connections" errors than MySql. It also supports transactions (which I think MySql now has). But it is a bit slower than MySql.
Somewhere I heard that PostgreSql is the real webmasters database, but I think that title is diminishing. MySql is by far the more popular these days.
It does support the regular SQL commands with a few unusual exceptions, so there is not much to learn. It might be handy to have in your toolbox!
Garth Farley |
|
|
|
|
Gandalf
WebHelper
Joined: 08 Jan 2002
Posts: 52
Location: Israel
|
Posted:
Thu Jan 24, 2002 11:36 am (22 years, 3 months ago) |
|
If anybody's interested, http://www.phpbuilder.com/columns/tim20000705.php3 has a comparison. Since I've already registered with CyberWings.com, it makes no real difference because MySQL is the only option I have. |
________________________________ Everything should be made as simple as possible, but no simpler. |
|
|
|
Garth Farley
WebHelper
Joined: 08 Jan 2002
Posts: 69
Location: Ireland
|
Posted:
Thu Jan 24, 2002 11:57 am (22 years, 3 months ago) |
|
It's kinda like comparing Linux to Windows, they both do pretty much the same thing, but they do it in different ways.
Really down to personal preference.
Garth Farley |
|
|
|
|
Daniel
Team Member
Joined: 06 Jan 2002
Posts: 2564
|
Posted:
Thu Jan 24, 2002 2:34 pm (22 years, 3 months ago) |
|
Except that there is a MUCH bigger difference between Windows & Linux than there is between mySQL and postgreSQL! |
________________________________
|
|
|
|
Garth Farley
WebHelper
Joined: 08 Jan 2002
Posts: 69
Location: Ireland
|
Posted:
Fri Jan 25, 2002 12:42 pm (22 years, 2 months ago) |
|
Well there is a bit of a difference between the two (Windows & Linux), but fundamentally they both are operating systems, offer GUIs and both have their pros and cons.
Definately their code-bases are very different, like any database system, but yet they both try to satisfy the same demand & offer the same functionality
Garth Farley |
|
|
|
|
|
|
You cannot post new topics in this forum. You cannot reply to topics in this forum. You cannot edit your posts in this forum. You cannot delete your posts in this forum. You cannot vote in polls in this forum.
|
Page generation time: 0.11921 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0
© 2001, 2002 phpBB Group :: Based on an FI Theme
| |