Instant database clones with PostgreSQL 18

kept by eddie dec 24, 25

PostgreSQL 18 adds instant, zero-copy database cloning via CREATE DATABASE with FILE_COPY and WAL_LOG strategies, enabling template-based cloning for testing and CI.

What are you doing this weekend?
A developer recounts returning to FreeBSD for a home NAS after years on Linux, praising its simplicity for servers but sticking with Arch for desktops.
also on ZFS, #open-source, #developer-tools
Neon, an Indie Studio With an International Bent, Tops Globes Nominations - The New York Times
Neon led all studios in Golden Globe nominations this year with six movies, all of which are non-English language films.
also on Neon
Nanolang: A tiny experimental language designed to be targeted by coding LLMs
Nanolang is a minimal experimental language with prefix notation and compile-time tests, designed to reduce coding errors made by LLMs.
also on #testing, #open-source, #developer-tools
Test, don't (just) verify
AI-assisted formal verification shows promise but faces limitations — autoformalization trust, proof assistant speed, and model complexity — making random testing a necessary complement.
also on #testing, #open-source, #developer-tools
GitHub - kristiandupont/kanel: Generate Typescript types from Postgres
Kanel generates TypeScript types from a live PostgreSQL database, offering type safety without an ORM.
also on #database, PostgreSQL, #open-source, #developer-tools