PostgreSQL: from your first database to transactions
Run a PostgreSQL database the way it runs in production: roles, constraints, indexes, transactions, a trigger and a dump.
- PostgreSQL: create a databaseeasy
- PostgreSQL: role with a passwordmedium
- PostgreSQL: table with constraintsmedium
- PostgreSQL: INSERT and SELECTmedium
- PostgreSQL: INNER JOINmedium
- PostgreSQL: GROUP BY and HAVINGmedium
- PostgreSQL: create an indexeasy
- PostgreSQL: RANK window functionmedium
- PostgreSQL: CTE (WITH)medium
- PostgreSQL: view (VIEW)medium
- PostgreSQL: foreign key with CASCADEmedium
- PostgreSQL: seq scan → index scanmedium
- Why a database needs indexesinterview questionmedium
- PostgreSQL: transferring money in a transactionmedium
- Transactions and ACIDinterview questionmedium
- PostgreSQL: audit triggerhard
- PostgreSQL: read-only userhard
- PostgreSQL: dump and restoremedium