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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
The difference between `Unstable' and `Usable' is only two characters: NT
--
To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe"
as the Subject.
