[plug] SQL Servers

[Garth Atkinson]

Hi Paul

Go with Postgres. It has commit and rollback, which MySQL doesnt have.
MySQL might be faster than Postgres but who cares! BTW MySQL is verrryy
fast at simple queries, but its SQL is pretty restricted and the
developers have 'cut a lot of corners' to boost performance. Also
Postgres is GPL I think and MySQL is not (?).

FWIW There is a lot of energy behind Postgres, maybe more so than with
MySQL.

Garth

Paul Baumgarten wrote:
> 
> I'm looking for SQL database servers that run under Linux.  I know that
> there is always freebie options like PostgreSQL and MySQL however from what
> I have heard these packages won't cope with running a medium sized
> organisation such as a school.  At the same time we can't afford the $20K
> plus for something like Oracle.  Something for up to a few thousand is OK
> though.  What ever solution we get needs to be pretty much fully compatiable
> with the SQL standard.
> 
> Since I _really_ don't want to build an NT box with MS SQL Server to run the
> database we are looking at purchasing I would appreciate hearing of what
> Linux options are floating around.
> 
> Paul Baumgarten (email: paul at kcc.wa.edu.au)
> Information Systems Manager
> Kingsway Christian College
> 157 Kingsway, Landsdale, WA, 6065
> Ph: +61 8 9409 7078
> Fx: +61 8 9409 6179