[GENERAL] PostgreSQL the right choice?
Vincent Stoessel
> "Richard Chrenko" <ric...@solarenergy.ch> wrote in message news:3C8EF7D7...@solarenergy.ch...
>
>>MySQL looks like it's free until you want to bundle it with a commercial
>>application, at which time license fees are required. What is the
>>situation with PostgreSQL?
>
>
> That's not why you want to avoid MySQL. You want to avoid MySQL
> because it's underpowered. No transactions, no foreign keys, no subselects,
> etc. etc.
>
Why is there so much mysql bashing?
I like postgresql too but I don't have to put down mysql
to justify using it.
Mysql is a simple, fast database that is quite solid from my experience.
It is usually my first choice as a web backend for php/jsp based websites.
I usually use postgresql on system based projects (usually in perl )
where I really need to use foreign keys and tranactions and the
loss of data would be a very expensive thing.
The current version of mysql does have foreign keys and transactions
available via the new innodb table type. I have not used it production
yet, but I am testing them.
--
Vincent Stoessel vin...@xaymaca.com
Linux and Java Application Developer
(301) 362-1750
AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
Jean-Michel POURE
> because it's underpowered. No transactions, no foreign keys, no subselects,
> etc. etc.
No Unicode, no large nested queries, no views, no triggers, no server-side
language : no PLpgSQL, no PLperl, etc... Poor ODBC support...
If your database is involved in a business, you need to migrate to
PostgreSQL. One day or another, MySQL limited features will hinder you.
/Jean-Michel
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majo...@postgresql.org so that your
message can get through to the mailing list cleanly
Jean-Michel POURE
> MySQL looks like it's free until you want to bundle it with a commercial
> application, at which time license fees are required. What is the
> situation with PostgreSQL?
PostgreSQL is completely free for commercial and non-commercial use. pgAdmin2
(http://pgadmin.postgresql.org), PostgreSQL Windows administration interface
is completely free.
> Given that we have a Java application and don't have the manpower to
> port a DBMS, what are the platforms on which PostgreSQL is currently
> stable?
PostgreSQL is the most stable Open-source database available.
> Is it possible to deploy PostgreSQL via an installer program, then
> automatically run a script to generate the tables and populate them with
> data from flat files?
Linux : PostgreSQL 7.2can be deployed via RPM (see PostgreSQL FTP in
/binaries).
Windows : PostgreSQL 7.2 is included in Cygwin installer
(http://www.cygwin.com).
An interactive doc is available from http://www.postgresql.org/idocs/.
Cheers,
Jean-Michel POURE
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majo...@postgresql.org)
David Siebert
you would need a database server with a simulation? I have heard of a
tinySQL server that is written all in java and might do what you need
without having to install and setup a database server just to run a
simulation. How big is the data set you are using? couldn't you use a flat
file for this?
-----Original Message-----
From: pgsql-gen...@postgresql.org
[mailto:pgsql-gen...@postgresql.org]On Behalf Of Richard Chrenko
Sent: Wednesday, March 13, 2002 1:55 AM
To: pgsql-...@postgresql.org
Subject: [GENERAL] PostgreSQL the right choice?
I have been looking for a RDBMS to deploy with our solar energy
simulation.
MySQL looks like it's free until you want to bundle it with a commercial
application, at which time license fees are required. What is the
situation with PostgreSQL?
Given that we have a Java application and don't have the manpower to
port a DBMS, what are the platforms on which PostgreSQL is currently
stable?
Is it possible to deploy PostgreSQL via an installer program, then
automatically run a script to generate the tables and populate them with
data from flat files?
Thanks for any comments.
--
Richard Chrenko, Informatik
Institut für Solartechnik SPF
Hochschule für Technik Rapperswil, Oberseestr.10, CH-8640 Rapperswil
Tel +41 55 222 48 33, Fax +41 55 222 48 44, http://www.solarenergy.ch
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster