[UCLA-LUG] Re: DB use

[Mark James Fasheh]

> Actually, transaction are not just needed in mission critical 
> software, but even in simple software, especially with multiple
> processes inserting data in multiple tables. You want the data to
> be consistent all the time.
> PostgreSQL is free and supports transactions. Interbase, the Borland/Imprise
> DBRMS, was Open Sourced just yesterday and may be worth a look.
Agreed.  Also, postgreSQL does better than row level locking on it's
databases, and afaik, MySQL does *table* level locking.  Not to mention the
fact that MySQL doesn't support subqueries.  Of course, if you don't
need/want these features (many people don't-- though I honestly shudder at
the thought of working without subqueries) then MySQL is def. the way to go.
	--Mark

-- 
If we were meant to get up early, God would have created us with alarm clocks.
Mark James Fasheh <mfasheh@linux.ucla.edu>
President, UCLA LUG
http://www.exothermic.org