[CLUG] Postgresql

[Donncha O Caoimh]

When you say database suite, and from the mail below I presume you mean
a nice GUI app builder. Corel have Paradox in their office suite which
is a steal at less than 200 quid. (I think)
MySQL and PostgreSQL are database servers along the lines of Oracle,
DB2, Informix etc. (Just don't get sticky and say MySQL isn't an RDBMS
because it lacks X feature.. ;) but you can get quite a few tools to
manipulate them from a GUI.
kmysql has a form builder but I couldn't get it to actually save the
forms (had drag and drop stuff though :)
PostgreSQL has some kind of database design tool which looks nice.
phpmyadmin is a VERY nice web based admin tool for MySQL.

MySQL is blazingly fast. I haven't benchmarked it myself against other
DBs, but we've been using it for almost 2 years in Tradesignals.com and
the latest release supports transactions and replication (though
transactions are still not absolutely ready for production use, you can
define some tables as transaction-aware tables, and others as "normal"
tables.. you only sacrifice speed in the tables that need atomic
operations! )

Don't get me started on MS Access ;)

Donncha.


michael dempsey wrote:
> 
> Paul,
> I knew u would answer postgres.
> Here, the reason I asked that silly question was from the commercial point
> of view of linux and databases. Th big gun's are still developing for linux
> while ms (bibs and dippers for ms users) has access.
> I was telling Donnacha last Saturday that my dcom4 project involved
> pointing my project at any odbc-jdbc database and it automaytically
> generates the gui's. Postgres as u know is to low level or high level for a
> business executive i.e. command line ( doesn't have a pretty face) or does
> it ?
> 
> Anybody know while I was at emc, my then bos removed redhat and installed
> windows NT on it I lost some pretty good stuff ;-(
> I was too lazy to use a symmetrix ;-)