PostgreSQL or MySQL ?

#1

Hiya,

I'm planning to build an enterprise-level php web app which will be
used to manage a large amount of users and which will get a lot of
hits.

so, which database setup should i use?

got 2 choices,

PostgreSQL or MySQL

have used MySQL before but heard good stuff about PostgreSQL.

Really interested in your views,

Sincerely,

John.

#2

On Apr 27, 12:16 pm, jag <indieh... (AT) gmail (DOT) com> wrote:

Quote:

Hiya,

I'm planning to build an enterprise-level php web app which will be
used to manage a large amount of users and which will get a lot of
hits.

so, which database setup should i use?

got 2 choices,

PostgreSQL or MySQL

have used MySQL before but heard good stuff about PostgreSQL.

Really interested in your views,

Sincerely,

John.

Lots if users
heavy hit rate
use:
ORACLE

(well you did ask for opinions)
ed

#3

On 27 Apr 2007 10:51:25 -0700, Ed Prochak <edprochak (AT) gmail (DOT) com> wrote:

Quote:

On Apr 27, 12:16 pm, jag <indieh... (AT) gmail (DOT) com> wrote:
Hiya,

I'm planning to build an enterprise-level php web app which will be
used to manage a large amount of users and which will get a lot of
hits.

so, which database setup should i use?

got 2 choices,

PostgreSQL or MySQL

have used MySQL before but heard good stuff about PostgreSQL.

Really interested in your views,

Sincerely,

John.

Lots if users
heavy hit rate
use:
ORACLE

(well you did ask for opinions)

Yeah, but he didn't want *sensible* opinions. He just wanted people
to say "MySQL" so he could show it to his boss.

Lemming
--
Curiosity *may* have killed Schrodinger's cat.

#4

jag wrote:

Quote:

Hiya,

I'm planning to build an enterprise-level php web app which will be
used to manage a large amount of users and which will get a lot of
hits.

so, which database setup should i use?

got 2 choices,

PostgreSQL or MySQL

have used MySQL before but heard good stuff about PostgreSQL.

I'm under the impression that MySQL have been improved in v5 (not sure
though). Earlier version was a nightmare, no views, no subselects, no
referential integrity, operators with a completely different meaning
than in other dbms, ...

PostgreSQL was (is ?) much more standard compliant. If you ever decide
to change dbms, it will be easier with postgres (still a lot of work though)

Here are two references:

http://sql-info.de/postgresql/postgres-gotchas.html
http://sql-info.de/mysql/gotchas.html

Finally, the major players in the field (DB2, Oracle, MsSQL) all have
free to use versions (under som restrictions) these days. I'm only
familiar with DB2:

http://www-306.ibm.com/software/data/db2/express/

Eventhough you clearly stated mysql/postgres as your alternatives, it
might be worthwhile to have at look at these 3

/Lennart

#5

On Apr 28, 8:08 am, Lennart <erik.lennart.jons... (AT) gmail (DOT) com> wrote:

Quote:

jag wrote:
Hiya,

I'm planning to build an enterprise-level php web app which will be
used to manage a large amount of users and which will get a lot of
hits.

so, which database setup should i use?

got 2 choices,

PostgreSQL or MySQL

have used MySQL before but heard good stuff about PostgreSQL.

I'm under the impression that MySQL have been improved in v5 (not sure
though). Earlier version was a nightmare, no views, no subselects, no
referential integrity, operators with a completely different meaning
than in other dbms, ...

PostgreSQL was (is ?) much more standard compliant. If you ever decide
to change dbms, it will be easier with postgres (still a lot of work though)

Here are two references:

http://sql-info.de/postgresql/postgr...l/gotchas.html

Finally, the major players in the field (DB2, Oracle, MsSQL) all have
free to use versions (under som restrictions) these days. I'm only
familiar with DB2:

http://www-306.ibm.com/software/data/db2/express/

Eventhough you clearly stated mysql/postgres as your alternatives, it
might be worthwhile to have at look at these 3

/Lennart

thanks, i'm pretty familiar with MSSql and Oracle, it's just that for
this project the inital budget for buying software is $0, once i've
got a workable solution i can start getting money to move hardware.

it's just these two are free to start with on apache, and i'm
wondering which one to build from.

...although i'm biased for mysql

#6

jag <indiehead (AT) gmail (DOT) com> wrote:

Quote:

thanks, i'm pretty familiar with MSSql and Oracle, it's just that for
this project the inital budget for buying software is $0, once i've
got a workable solution i can start getting money to move hardware.

it's just these two are free to start with on apache, and i'm
wondering which one to build from.
Almost all the heavy duty databases including those from PostgreSQL

Oracle, IBM and even Microsoft are "free to start with". Most of them
will remain free for a medium sized business. I have what I believe to
be a complete list at <http://database.profectus.com.au>.

Quote:

..although i'm biased for mysql
This is the only one that may not be "free to start with". MySQL AB

state that their free (open source) version may be used only with open
source software. They justify this by claiming that any application
the _uses_ their database is a "derived work" and hence must also be
GPL licensed. This is roughly equivalent to claiming that any
application that runs on Linux is a "derived work". No other open
source RDBMS attempts any similar restrictions and, if you are
developing a commercial application, I suggest you avoid MySQL and
stick to a genuine open source product or a commercial product that
has a clear license for their free version.

#7

On Apr 30, 1:31 pm, jag <indieh... (AT) gmail (DOT) com> wrote:

Quote:

On Apr 28, 8:08 am, Lennart <erik.lennart.jons... (AT) gmail (DOT) com> wrote:

jag wrote:
Hiya,

I'm planning to build an enterprise-level php web app which will be
used to manage a large amount of users and which will get a lot of
hits.

so, which database setup should i use?

got 2 choices,

PostgreSQL or MySQL

have used MySQL before but heard good stuff about PostgreSQL.

I'm under the impression that MySQL have been improved in v5 (not sure
though). Earlier version was a nightmare, no views, no subselects, no
referential integrity, operators with a completely different meaning
than in other dbms, ...

PostgreSQL was (is ?) much more standard compliant. If you ever decide
to change dbms, it will be easier with postgres (still a lot of work though)

Here are two references:

http://sql-info.de/postgresql/postgr...://sql-info.de...

Finally, the major players in the field (DB2, Oracle, MsSQL) all have
free to use versions (under som restrictions) these days. I'm only
familiar with DB2:

http://www-306.ibm.com/software/data/db2/express/

Eventhough you clearly stated mysql/postgres as your alternatives, it
might be worthwhile to have at look at these 3

/Lennart

thanks, i'm pretty familiar with MSSql and Oracle, it's just that for
this project the inital budget for buying software is $0, once i've
got a workable solution i can start getting money to move hardware.

it's just these two are free to start with on apache, and i'm
wondering which one to build from.

..although i'm biased for mysql

well, it's good enough for Google...

#8

On Apr 30, 8:31 am, jag <indieh... (AT) gmail (DOT) com> wrote:

Quote:

On Apr 28, 8:08 am, Lennart <erik.lennart.jons... (AT) gmail (DOT) com> wrote:

jag wrote:
Hiya,

I'm planning to build an enterprise-level php web app which will be
used to manage a large amount of users and which will get a lot of
hits.

so, which database setup should i use?

got 2 choices,

PostgreSQL or MySQL

have used MySQL before but heard good stuff about PostgreSQL.

I'm under the impression that MySQL have been improved in v5 (not sure
though). Earlier version was a nightmare, no views, no subselects, no
referential integrity, operators with a completely different meaning
than in other dbms, ...

PostgreSQL was (is ?) much more standard compliant. If you ever decide
to change dbms, it will be easier with postgres (still a lot of work though)

Here are two references:

http://sql-info.de/postgresql/postgr...://sql-info.de...

Finally, the major players in the field (DB2, Oracle, MsSQL) all have
free to use versions (under som restrictions) these days. I'm only
familiar with DB2:

http://www-306.ibm.com/software/data/db2/express/

Eventhough you clearly stated mysql/postgres as your alternatives, it
might be worthwhile to have at look at these 3

/Lennart

thanks, i'm pretty familiar with MSSql and Oracle, it's just that for
this project the inital budget for buying software is $0, once i've
got a workable solution i can start getting money to move hardware.

it's just these two are free to start with on apache, and i'm
wondering which one to build from.

..although i'm biased for mysql

for development/test purposes, you can get ORACLE for free. Here's
part of the license agreement.
<quote>
Any use of the Oracle Database Express Edition is subject to the
following limitations;
1. Express Edition is limited to a single instance on any server;
2. Express Edition may be installed on a multiple CPU server, but may
only be executed on one processor in any server;
3. Express Edition may only be used to support up to 4GB of user data
(not including Express Edition system data);
4. Express Edition may use up to 1 GB RAM of available memory.
</quote>

I'm am not trying to sell you on Oracle, only trying to point out that
you may need to do more research. At least visit the ORACLE home page.
You might find Oracle does not cost as much as you think. Then you can
rationally decide if the difference in features and support over mysql
are worth the additional cost

ed

#9

Ed Prochak <edprochak (AT) gmail (DOT) com> wrote:

Quote:

for development/test purposes, you can get ORACLE for free. Here's
part of the license agreement.
quote
Any use of the Oracle Database Express Edition is subject to the
following limitations;
1. Express Edition is limited to a single instance on any server;
2. Express Edition may be installed on a multiple CPU server, but may
only be executed on one processor in any server;
3. Express Edition may only be used to support up to 4GB of user data
(not including Express Edition system data);
4. Express Edition may use up to 1 GB RAM of available memory.
/quote
The license agreement you have quoted above is for the free, freely

deployable, no charge ever, give it to all your friends and customers
and make huge profits for yourself, version of Oracle. For development
and test purposes you can download the full Enterprise version of
Oracle
<http://www.oracle.com/technology/software/products/database/oracle10g/index.html>.
They will even send you a CD and I received an unsolicited phone call
from tech support asking if I needed any help. I don't use an Oracle
database but I find my free membership of OTN
<http://www.oracle.com/technology/index.html> valuable because of the
wealth of technical information they provide.

#10

On 30 Apr, 16:58, strawberry <zac.ca... (AT) gmail (DOT) com> wrote:
[...]

Quote:

well, it's good enough for Google...- Dölj citerad text -

I cant argue whether that is true or not. Neither am I sure which of
my points you disagree with:

- Referential integrity
You are suggesting that the quality of data provided by google is good
enough for any system?

- Lack of view's and subselects
You are suggesting that in any system there is no need for queries
more complicated than the ones google uses to retrive data?

/Lennart