Database Cheat Sheet

This is a general guide on how to get up and running with specific databases and database-related tools, as well as other useful database info.

Popular Databases

Cassandra

The Apache Cassandra database is designed for high scalability.

• Apache Cassandra database
• Node cassandra client

Note: The largest known Cassandra cluster has over 300 TB of data in over 400 machines.

CouchDB

DynamoDB

Hadoop

• https://github.com/mongodb/mongo-hadoop

MongoDB

MySQL

Neo4j

• http://neo4j.org/

OrientDB

• http://www.orientdb.org/

PostGreSQL

Riak

Redis

SQLite3

Titan

• http://thinkaurelius.github.com/titan/

Database Features

Database Feature Comparison

@@@ coffeescript table -> thead -> th -> td '' td 'MongoDB' td 'CouchDB' td 'Cassandra' td 'Neo4j' td 'PostGreSQL' td 'MySQL' td 'SQLite3' td 'Redis' tbody -> tr -> td 'Type' td 'Document' td 'Document' td 'Document' td 'Graph' td 'SQL' td 'SQL' td 'SQL' tr -> td 'ACID Compliant' @@@

ACID Compliance

Map/Reduce

• http://www.mongodb.org/display/DOCS/MapReduce

Resources

• http://nosql-database.org/