<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/1.0.1">
</HEAD>
<BODY>
PosgreSQL is also the 'standard' DB for distros like RedHat. Although MySQL can be found, PostgreSQL is making better inroads...
<BR>
<BR>
However, I use MySQL. I've found it to be faster than PostgreSQL on the databases I run. (Typically simple and not large data sets - sub 100,000 records.)
<BR>
<BR>
Many of the 'missing' functions Jason mentions are present in the new MySQL 4.0 which should be out of testing soon. I do sorely miss sub-selects in the current 3.x.x versions.
<BR>
<BR>
I don't know how PosgreSQL handles replication, but the master-slave binlog relationship in MySQL works well for this and has become more 'automagical' in the 4.0 series.
<BR>
<BR>
I expect to hear Grant weighing in soon and reminding me that 'real men use PostgreSQL'. ;-)
<BR>
<BR>
-Dave
<BR>
<BR>
<BR>
On Fri, 2002-02-01 at 19:32, jason@matchingmoms.com wrote:
<BLOCKQUOTE>
<PRE><FONT COLOR="#737373"><FONT SIZE="3"><I>My preference is Postgresql. It has important features that MySQL lacks,</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>such as transactions, sub-selects, constraints, and triggers. MySQL claims</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>to be faster, and that may be true, but going faster on the high wire</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>without a net (transactions) is useful only for specialized applications.</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>And the lack of sub-selects will make MySQL considerably slower where logic</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>can be imbedded in a select as opposed to program code.</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>----- Original Message -----</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>From: "Richard Knechtel" <rknech@pcisys.net></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>To: <clue-tech@clue.denver.co.us></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>Sent: Saturday, February 02, 2002 1:40 AM</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>Subject: [CLUE-Tech] Clue: Database</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> I am working on a Kylix application and am wondering what would be the</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>best</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> general databse to use for the application. I have used Oracle and DB2 at</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> work mainly. But normal Linux users don't have these installed. Which is</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> probably the best general database to use ? MySQl or Progress? or is</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>there</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> another that might be better.</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> Thanks,</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> _______________________________________________</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> CLUE-Tech mailing list</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> CLUE-Tech@clue.denver.co.us</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> http://clue.denver.co.us/mailman/listinfo/clue-tech</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>_______________________________________________</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>CLUE-Tech mailing list</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>CLUE-Tech@clue.denver.co.us</FONT></FONT></I></PRE>
</BLOCKQUOTE>
<A HREF="http://clue.denver.co.us/mailman/listinfo/clue-tech"><FONT SIZE="3"><I>http://clue.denver.co.us/mailman/listinfo/clue-tech</FONT></I></A>
<BLOCKQUOTE>
<PRE></PRE>
</BLOCKQUOTE>
</BODY>
</HTML>