4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 PostgreSQL
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
Gandalf
WebHelper
WebHelper


Joined: 08 Jan 2002
Posts: 52
Location: Israel

PostPosted: Sat Jan 12, 2002 11:12 pm (15 years, 9 months ago) Reply with QuoteBack to Top

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.
OfflineView User's ProfileFind all posts by GandalfSend Personal MessageICQ Number
Garth Farley
WebHelper
WebHelper


Joined: 08 Jan 2002
Posts: 69
Location: Ireland

PostPosted: Mon Jan 14, 2002 3:37 pm (15 years, 9 months ago) Reply with QuoteBack to Top

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
OfflineView User's ProfileFind all posts by Garth FarleySend Personal Message
Gandalf
WebHelper
WebHelper


Joined: 08 Jan 2002
Posts: 52
Location: Israel

PostPosted: Thu Jan 24, 2002 11:36 am (15 years, 9 months ago) Reply with QuoteBack to Top

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.
OfflineView User's ProfileFind all posts by GandalfSend Personal MessageICQ Number
Garth Farley
WebHelper
WebHelper


Joined: 08 Jan 2002
Posts: 69
Location: Ireland

PostPosted: Thu Jan 24, 2002 11:57 am (15 years, 9 months ago) Reply with QuoteBack to Top

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
OfflineView User's ProfileFind all posts by Garth FarleySend Personal Message
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Thu Jan 24, 2002 2:34 pm (15 years, 9 months ago) Reply with QuoteBack to Top

Except that there is a MUCH bigger difference between Windows & Linux than there is between mySQL and postgreSQL!

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
Garth Farley
WebHelper
WebHelper


Joined: 08 Jan 2002
Posts: 69
Location: Ireland

PostPosted: Fri Jan 25, 2002 12:42 pm (15 years, 9 months ago) Reply with QuoteBack to Top

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
OfflineView User's ProfileFind all posts by Garth FarleySend Personal Message
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




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.059353 seconds :: 18 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme