Foreign keys / Transactions in MySQL.. WTF?

[Aaron Trevena]

On 31/07/07, Peter Corlett <abuse at cabal.org.uk> wrote:
> On Tue, Jul 31, 2007 at 10:46:51AM +0100, ti at lemonia.org wrote:
> [...]
> > Do things like "command-line SQL tool with history that understands your
> > terminal width", "GUI tool that starts in less than tree minutes",
> > "reliable export/import tool", and "readily configured full text search"
> > count as "key features"?
>
> Which other database are you alluding to here?
>
> MySQL's alleged full-text support is a load of gash and no better than LIKE
> '%keyword%" (thus doing a full table scan) but you presumably knew that
> already.

It beats SQL Server and Postgres.

It's not as good as a custom fulltext, but it has fairly sensible
defaults, and in boolean mode matches phrases and all kinds of useful
stuff without wierd syntax.

I've used it successfully as a fallback when there wasn't the
opportunity to do a better job myself. On the other hand most of the
other built in RDBMs fulltext searching has either sucked, or in the
case of Postgres involved yet more installing 3rd party botches.

A.

-- 
http://www.aarontrevena.co.uk
LAMP System Integration, Development and Hosting