Databases
9 sheets
- MariaDB Cheat-SheetMariaDB is a community fork of MySQL. Day-to-day SQL, backup and user commands are the same, see MySQL. General SQL: SQL.
- MongoDBMongoDB is a document database that stores JSON-like (BSON) documents in collections. This sheet covers mongosh, users and roles, indexes, everyday queries…
- MySQLMySQL is an open source relational database. MariaDB is a compatible fork, see MariaDB Cheat-Sheet. Most commands below work on both.
- MySQL and MariaDB ReplicationAsynchronous source/replica replication using GTIDs (global transaction IDs), how to watch lag, and how to fail over. MySQL 8.4 and MariaDB use different GTID…
- PostgreSQL Backup and ReplicationLogical dumps with pg_dump, physical base backups, WAL archiving with point-in-time recovery (PITR), streaming replication and logical replication. Basic…
- PostgreSQL Cheat-SheetPostgreSQL, also known as Postgres, is a free and open-source relational database management system. PostgreSQL features transactions with Atomicity…
- RedisRedis is an in-memory data store used as a cache, session store, queue and simple database. It keeps data in RAM and can persist it to disk with snapshots…
- SQLStandard SQL basics and common queries, with the points where PostgreSQL, MySQL/MariaDB and SQLite differ. Engine-specific administration is in PostgreSQL…
- SQLite Cheat-SheetGeneral SQL and engine differences: SQL.