Open Source Relational Data Base engine. Known for simplicity and speed.

But doesn't support transactions and other "advanced" features. For that you typically use Postgre S Q L.

• but few websites really use/need transactions, and Scalabil Ity is pushing people away from those features.

http://www.mysql.com/

Part of the LAMP platform.

installing on MacOsX

• building http://hivelogic.com/narrative/articles/installing-mysql-on-mac-os-x

  • see some comments

    • MAMP http://www.mamp.info/en/index.php - yes, I did that.

  • "still some issues on Tiger"

    • what are they? just the "shared library" problem?

    • I'm actually still running Panther.

  • Mark Pilgrim on the joys of not building yourself.

Command Line interface: mysql http://dev.mysql.com/doc/refman/5.1/en/mysql.html

GUI tools http://dev.mysql.com/doc/#guitools

• Secur Ity concerns often keep you from using such things (because you make your db as inaccessible as possible, except from other machines behind that firewall)

batch input/output

• output/export: "mysqldump" from Command Line

• import: "source" from inside mysql

date queries: MySQL doesn't have as nice date_trunc and date_part functions as Postgre S Q L.

• you can use date(timestamp) to group by whole-date

• there's a month() function but that gives you just the month-number, so doesn't work for cross-year queries

  • though I suppose you could break on year() and month()

User Options Recent Changes Help Page