Databases in an evening: SQLite, PostgreSQL, Redis
Try three popular databases in one evening: tables and queries in SQLite and PostgreSQL, keys, queues and TTLs in Redis.
- SQLite: a book catalog in one fileeasy
- SQLite: how many pages in the catalogeasy
- SQLite: update the dataeasy
- SQLite: create an indexeasy
- SQLite: join the tablesmedium
- Your first PostgreSQL databaseeasy
- A reader for the library databasemedium
- Book catalog: INSERT and SELECTmedium
- Books and authors with a JOINmedium
- Dump a PostgreSQL databasemedium
- Redis with a passwordmedium
- Redis: key with TTLeasy
- A counter with INCRBYeasy
- Redis: visit countereasy
- Redis: a queue with a listeasy
- Redis: profile in a hasheasy
- Delete keys by patternmedium