~postgresweekly | Bookmarks (165)
-
GitHub - ankane/pgslice: Postgres partitioning as easy as pie
pgslice: Postgres Partitioning 'As Easy As Pie' — A tool that can either generate or generate and execute...
-
GitHub - jnidzwetzki/pg-lock-tracer: A BPF based lock tracer for the PostgreSQL database
pg-lock-tracer: A BPF-Based Lock Tracer — An interesting way to dig into lock-related bottlenecks in Postgres...
-
GitHub - zalando/patroni: A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes
Patroni 3.0: Template for Postgres High Availability — A template to create your own customized, high-availability solution...
-
GitHub - oguimbal/pg-mem: An in memory postgres DB instance for your unit tests
pg-mem: An Experimental In-Memory Postgres Instance for Tests — Aimed at Node.js and browser-based use cases...
-
Transaction ID wraparound: a walk on the wild side
Transaction ID Wraparound: A Walk on the Wild Side — "For most people it is an...
-
Ask HN: How do you test SQL? | Hacker News
Ask HN: How Do You Test SQL? — Extensive discussion about the myriad of ways that...
-
Surviving Without A Superuser - Coming to v16
Coming to v16: Surviving Without a Superuser — A superuser in Postgres gets the highest privileges...
-
PostgreSQL supply chain
Postgres's 'Supply Chain' — Every significant project relies on many others. Peter notes that a few...
-
GitHub - k1LoW/tbls: tbls is a CI-Friendly tool for document a database, written in Go.
tbls: A CI-Friendly Tool for Documenting Databases — Document a database automatically in Markdown format with...
-
GitHub - cybertec-postgresql/pg_show_plans: Show query plans of all currently running SQL statements
pg_show_plans: Show Query Plans of All Currently Running Statements — Lets you get live access via SELECT...
-
GitHub - powa-team/pg_qualstats: A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing
pg_qualstats: Extension for Collecting Statistics About Predicates — Analyze the most often used predicates in queries...
-
Debugging PostgreSQL CI failures faster: 4 tips
Debugging Postgres CI Failures Faster — Postgres uses Cirrus CI for its continuous integration system.
-
PGConf NYC 2022
▶ 30+ Talks from PGConf NYC 2022 — We forgot to include this in December, but it’s...
-
PostgreSQL unique constraint, but NULL conflicts with everything
A Unique Constraint Where NULL Conflicts with Everything — Laurenz showcases range data types and exclusion...
-
pganalyze
Join Us for Season 2 of Our “5mins of Postgres” Video Series — After over 50...
-
Puzzling Postgres: a story of solving an unreproducible performance issue
Puzzling Postgres: A Story of Solving An Unreproducible Performance Issue — Going down the rabbit hole...
-
Walk-through of implementing simple Postgres patch. From sources to CI.
▶ Walkthrough of Implementing a Simple Postgres Patch — If you’ve ever been curious about what’s involved...
-
A foreign key pathology to avoid
A Foreign Key Pathology to Avoid — If you have a many-to-many join table with defined...
-
https://www.linode.com/content/understanding-databases-ebook/
[Free Download] Understanding Databases eBook
-
WAL Compression in PostgreSQL and Recent Improvements in Version 15 - Percona Database Performance Blog
A Look into WAL Compression and Recent Improvements in Postgres 15 — Taking another look at the...
-
Waiting for PostgreSQL 16 – Invent random_normal() to provide normally-distributed random numbers. – select * from depesz;
PostgreSQL 16's random_normal() Function — This will give us a way to get normally-distributed random numbers,...
-
SQL-first Golang ORM [get things done in 2022]
Bun 1.1.10: Simple, Performant ORM for Go — Supporting Postgres, MySQL, SQL Server and SQLite, Bun...
-
Building a PostgreSQL Wire Protocol Server using Vanilla, Modern Java 21
Building a Postgres Wire Protocol Server — A Java-oriented tutorial that has two purposes, both to...
-
usql: universal psql?
usql: A 'Universal psql'? — A comparison of the Go-powered usql ‘universal CLI’ for various database...