Re: [Plug] Choosing an SQL server for Linux

[Hugh Brock <hbrock@ibm.net>]

Michael Leone wrote:
> 
> Got asked this question by a friend, but unfortunately I don't really use SQL.
> 
> I know that MS Access can be used as a front end to SQL Server (and - I
> presume - other SQL products from other vendors). Apparently, some of their
> databases are getting up there in size and/or need to start becoming
> multi-user. Anybody know of a free (or inexpensive) Linux SQL server that
> could be used as a back-end to Access (95/97)?

The word on the street is that PostgreSQL (open source Linux SQL DBMS)
is maturing into a decent product. It is still not fully relational,
meaning that you have to implement relationships in your front end
rather than on the database side, but the relational features are
expected in the next release due this fall.

The above notwithstanding, if I wanted to run a serious database app on
Linux I'd cough up the dough for a 5-user Oracle license. It's only
~$1300, and it's beyond proven. Makes SQL Server look like a big pile of
junk.

Theoretically both of the above should be usable with Access via ODBC,
although I'm not precisely sure of the mechanics, seeing as how my
Microsoft training only refers to Microsoft products... sigh...

Good luck,
--Hugh

_______________________________________________
Plug maillist  -  Plug@lists.nothinbut.net
http://lists.nothinbut.net/mail/listinfo/plug