Database Notes

Wanna build your schema online and share?

WW SQL Designer

Wanna test your SQL query online and share?

SQL Fiddle

This might come in handy for you, if you are struggling with a SQL query:

Common MySQL Queries

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?

Benerator

Want to Validate your SQL?

Mimer SQL Validator

Random:

1. 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.
2. Set your database to use the UTC timezone