| WebSeitz/wikilog |
| MySQL |
|
| last edited by BillSeitz on Aug 20, 2008 8:17 pm |
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.
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 |