Re: Linux Database - which to use.

[Aaron Turner <aturner linuxkb org>]

My .02 for what it's worth:

MySQL doesn't do transactions.  For medical info this should in your mind
take it out of the running.  PosgresSQL is probably the slowest of the
bunch, but has a good feature set and is very popular in the Linux
community.  For that few records, it should do quite well though.

Oracle, is well Oracle.  Kickass database able to do terabytes of data.
Informix and Sybase are much closer to Oracle than Posgres.

So, if you're looking for something powerful, cheap, and well supported in
the community, I'd go PosgresSQL.  If you're looking for something super
powerful and commercial you might as well go all the way with Oracle.

On Thu, 27 Jan 2000, Bob Hartung wrote:

> Hello,
>   I need to begin picking a database fora project.  The
> number of choices is now staggering.  Generally, I will have
> about 15,000-20,000 patients and about 35,000 procedures
> entered per year. I need to be able to run this over an
> internet between three institutions [not necessarily
> friendly to one another but my group provides services at
> all three] and I am confused where to go on the Linux side. 
> My background in is FoxPro then FP for Windows and then
> Visual FoxPro. 
>   My choices are:
> 	Oracle 8i with WebDB  	Probably overkill
> 	Informix
> 	Sybase
> 	MySQL
> 	PostGreSQL
> 
> I prefer a RDBMS with referential integrity, persistent
> relationships etc.  Suggestions on the best place to start
> reading/experimenting appreciated.  If there is a better
> site to post this please let me know.  I don't want to bog
> this list down unnecessarily.
> 
> TIA
> 
> Bob Hartung
> 
> 
> -- 
> To unsubscribe: mail redhat-list-request redhat com with "unsubscribe"
> as the Subject.
> 

--
Aaron Turner, Core Developer       http://vodka.linuxkb.org/~aturner/
Linux Knowledge Base Organization  http://www.linuxkb.org/
Because world domination requires quality open documentation.
aka: aturner vicinity com, aturner pobox com, ion_beam_head ashtech net
The difference between `Unstable' and `Usable' is only two characters: NT