Difference MySQL And PostGRE-SQL

[vladimir1405241474 0]

Can somebody explain me the differences between mysql databases and postsql databases. I have no idea what they make different.One thing I heard is that postsql should be better than mysql databases...but I have no What would you recommend me to use for a forum or so?

[coder2000 0]

There are major differences between the two. One: MySQL is geared towards commercial applications whilst PostgreSQL isn't. Two: MySQL isn't 100% SQL compliant as of 4.1 while PostgreSQL is. Three: I personally think MySQL is faster and easier to use.

[cryptwizard 0]

Actually, I've never heard of PostSQL, unless you mean PostgreSQL.I don't know much about PostgreSQL, but I'm fine with mySQL.mySQL has 2 kinds of storage engines: MyISAM, which is geared towards speed and InnoDB, which is transaction based, and hence, geared towards reliability.

[vladimir1405241474 0]

im sorry, yeah I meant PostgreSQL. I dont know much about them either.But I just learned some stuff about MySQL. I also prefer them for my forums.Most scripts requires a mysql so I guess PostgreSQL is not that popular...

[heimcomputer 0]

... MySQL is geared towards commercial applications whilst PostgreSQL isn't...

<{POST_SNAPBACK}>

What do you mean by this

 

The MySQL database server is available under the MySQL AB "dual licensing" model. Under this model, users may choose to use MySQL products under the free software/open source GNU General Public License (commonly known as the "GPL") or under a commercial license.

http://www.mysql.com/products/

 

 

What is the copyright on PostgreSQL?

PostgreSQL is subject to the following COPYRIGHT:

PostgreSQL Data Base Management System

Portions Copyright © 1996-2005, PostgreSQL Global Development Group Portions Copyright © 1994-6 Regents of the University of California

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.....the above is the BSD license, the classic open-source license. It has no restrictions on how the source code may be used. We like it and have no intention of changing it.

http://forums.xisto.com/no_longer_exists/

 

I have known about postgreSQL for a long time

but i have never gotten around to use it.

I know of huge organizations who use postgreSQL as their database platform

for web and more

so there must be something about it (dont you think )

i remember something about image functions

im not shure what it is

but that the capabilities is better with postgreSQL when i t comes to images???

or am I totaly wrong

[BAJIEPA 0]

Mysql and postgres are two different tools. You're comparing apples and oranges. You have to determine your projects needs, and then decide which to use.If all you are doing is searching/displaying then use mysql. If you need stored procedures, and other more advanced features then you need postgres or oracle.

[harriko 0]

i only heard of mysql but postsql i never heard of this until this post came up. i only find mysql on databases, forums, search websites.

[thedevil 0]

I use MySql to power my websites... but still i dont know much about PostGre... I have not used it... but soon test ride it...But if you want to compare about MS-Sql and MySql i can say a little... MySql is faster on web than MS-Sql but the underlying security of MS-Sql... i feel is better than that of MySql...

[miCRoSCoPiC^eaRthLinG 0]

Not anymore thedevil.. If you take at the more recent versions of MySQL (4.1.8 onwards) -they've improved dramatically in every aspect... Security wise, features wise .. every way.. THey even support a big factor that was missing earlier on - Transaction Capabilities. That's in action with full force now and so is Stored Procedures (even though it's still in somewhat experimental stage but will be finalized by version 5)... Also the speed of MySQL on Linux (on Web OR over Private LAN) can be matched only if you set up a cluster of MS-SQL Servers... MySQL will butcher MS-SQL on one-to-one comparision .

[dragon52225 0]

basically, mysql is more user friendlyand postgresql is more technical

[knowlet 0]

Is this thread 2 years dead? I would like to know what happened in the meantime.Is mySQL now similarly "technical" as postgresql?It would be important to decide where to start.MySQL is spread over the internet also for free, postgresql is hard to find (which has also advantages).What do you suggest?LP