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

Wed, 13 Mar 2002 07:55:19 +0100
Richard Chrenko <richard@solarenergy.ch>
PostgreSQL the right choice?
"Richard Chrenko" <richard@solarenergy.ch> wrote in message news:3C8EF7D7.1003ECC3@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.


> 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?

I think the short answer is "all of them." It runs great on Windows (under cygwin)
and many unix and linux.

Try it out.


Marshall




Tue, 12 Mar 2002 23:50:17 -0800
"Marshall Spight" <marshall@meetstheeye.com>
Re: PostgreSQL the right choice?
Marshall Spight wrote:
> "Richard Chrenko" <richard@solarenergy.ch> wrote in message news:3C8EF7D7.1003ECC3@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 vincent@xaymaca.com
Linux and Java Application Developer
(301) 362-1750
AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica


Wed, 13 Mar 2002 22:38:13 -0500
Vincent Stoessel <vincent@xaymaca.com>
Re: PostgreSQL the right choice?
> 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.

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

Thu, 14 Mar 2002 09:18:57 +0100
Jean-Michel POURE <jm.poure@freesurf.fr>
Re: PostgreSQL the right choice?
Le Mercredi 13 Mars 2002 07:55, Richard Chrenko a écrit :
> 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

Thu, 14 Mar 2002 09:25:33 +0100
Jean-Michel POURE <jm.poure@freesurf.fr>
Re: PostgreSQL the right choice?
Do you really need an SQL Database for this? I am trying to figure out why
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-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Richard Chrenko
Sent: Wednesday, March 13, 2002 1:55 AM
To: pgsql-general@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


Thu, 14 Mar 2002 14:42:36 -0500
"David Siebert" <david@eclipsecat.com>
Re: PostgreSQL the right choice?
Checkout Firebird as well - which appears to be the other alternative.

	http://firebird.sourceforge.net/index.php

q: How does open source affect the costs for companies which use
Interbase or Firebird as an embedded server?

a: Firebird server and client are free of all licensing fees,
regardless of whether you download a binary or build it yourself from
the source code.


I agree that mySQL is too limited for serious use.

On Tue, 12 Mar 2002 23:50:17 -0800, "Marshall Spight"
<marshall@meetstheeye.com> wrote:

> "Richard Chrenko" <richard@solarenergy.ch> wrote in message news:3C8EF7D7.1003ECC3@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.
> 
> 
> > 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?
> 
> I think the short answer is "all of them." It runs great on Windows (under cygwin)
> and many unix and linux.
> 
> Try it out.
> 
> 
> Marshall
> 
> 


Fri, 15 Mar 2002 12:43:24 +0000
Jasbir D <jasbird@hushmail.com>
Re: PostgreSQL the right choice?
Jasbir D wrote:
> Checkout Firebird as well - which appears to be the other alternative.
> 
> 	http://firebird.sourceforge.net/index.php
> 
> q: How does open source affect the costs for companies which use
> Interbase or Firebird as an embedded server?
> 
> a: Firebird server and client are free of all licensing fees,
> regardless of whether you download a binary or build it yourself from
> the source code.

I found it interesting that Firebird is moving to C++ for their base
code in 2.0.  They have already started porting since releasing 1.0
recently:
	
	What Happens after Firebird 1.0?
	
	Well, work certainly won't stop. At the moment we have a Firebird 2.0
	tree within CVS. These tree has ported the original code to C++ and
	added much improved exception handling and memory management.

There are clearly some C++ constructs that would be nice to use in the
backend code, but the extra baggage and inability to limit people to
just a subset of the C++ features make such a move very questionable.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 20 Mar 2002 14:35:43 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Firebird 2.0 moving to C++