Database Notes
Published on 2/9/2012
Wanna build your schema online and share?
Wanna test your SQL query online and share?
This might come in handy for you, if you are struggling with a SQL query:
If you don’t fully understand JOINs:
A Visual Explanation of SQL Joins
Wanna hot-backup your InnoDB database?
Percona XtraBackup (open source)
Need to recover a corrupt InnoDB table?
Percona Data Recovery Tool for InnoDB (open source)
Need to generate massive test data?
Want to Validate your SQL?
Random:
- if you want decent full-text search, choose PostgreSQL over MySQL, as MySQL doesn’t support free-text search at the same time as foreign keys and transactions.
- Set your database to use the UTC timezone