Foreign keys / Transactions in MySQL.. WTF?
aaron.trevena at gmail.com
Tue Jul 31 12:13:16 BST 2007
On 31/07/07, ti at lemonia.org <ti at lemonia.org> wrote:
> > How did MySQL get so popular when it still seems to be missing key
> > features?
> > tjc
> 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"?
- built in replication and transaction logging.
- doesn't need to vacuum tables regularly, killing performance.
- easy and clear authentication and authorisation (done and
documented) in one place.
- DWIMery instead of pedantry.
I've used Oracle, Postgres, SQL Server and MySQL, and still find it
quicker and easier to use MySQL, and still haven't been bitten by it
in more than 8 years.
It's not *that* bad, just accept it for what it is, a slightly quirky
and overfriendly lightweight rdbms-type-thing.
LAMP System Integration, Development and Hosting
More information about the london.pm