--- title: "Are Postgres committers morning people?" publication: "Postgres Weekly" issue: 485 published_at: "2022-12-14" canonical_url: "https://postgresweekly.com/issues/485" --- Plus CRDTs, faceting, and using Postgres for everything (even Advent of Code). | #​485 — December 14, 2022 [Web Version](https://postgresweekly.com/issues/485) Together with [![Timescale logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_350,h_90/e_make_transparent/co_white,e_outline:7/vpntubykyv5ujmbzw501.png)](https://www.timescale.com/blog/expanding-the-boundaries-of-postgresql-announcing-a-bottomless-consumption-based-object-storage-layer-built-on-amazon-s3/) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/vhowdywxuu4l6ywak43k.jpg)](https://supabase.com/blog/postgres-crdt) [pg_crdt: An Experimental CRDT Extension](https://supabase.com/blog/postgres-crdt) — Supabase has open sourced a new extension (that they’re _very_ keen to stress is ‘experimental’) for supporting conflict-free replicated data types (CRDTs) as commonly used in distributed and collaborative systems to allow multiple users to make simultaneous changes which are then reconciled thereafter. Paul Copplestone (Supabase) [Faceting Large Result Sets in Postgres](https://www.cybertec-postgresql.com/en/faceting-large-result-sets/) — When it comes to searching and query interfaces, ‘faceting’ is the idea of honing in on a result set by applying increasing numbers of conditions (for example, a shirt.. that’s red.. in a certain size). Counting all of the matching rows for a certain set of facets can be made more efficient, as shown here. Ants Aasma (Cybertec) [![\](https://copm.s3.amazonaws.com/e89f04d7.jpg)](https://www.timescale.com/blog/expanding-the-boundaries-of-postgresql-announcing-a-bottomless-consumption-based-object-storage-layer-built-on-amazon-s3/) [Timescale Launches New Object Storage Layer on Amazon S3](https://www.timescale.com/blog/expanding-the-boundaries-of-postgresql-announcing-a-bottomless-consumption-based-object-storage-layer-built-on-amazon-s3/) — With Timescale’s new capability, learn how you can now store an infinite amount of data in Timescale Cloud, paying only for what you store and accessing it as if it all lived in one single continuous PostgreSQL table. Timescale sponsor ['Just Use Postgres for Everything'](https://www.amazingcto.com/postgres-for-everything/) — Preaching to the choir here and we agree with most of the points, but this brief opinion piece is interesting, too, partly because of [speculation](https://news.ycombinator.com/item?id=33934745) that [ChatGPT](https://openai.com/blog/chatgpt/) wrote it(!) Stephan Schmidt **IN BRIEF:** - Peter Eisentraut decided to do some [analysis on commit times on the official Postgres source repo](http://peter.eisentraut.org/blog/2022/12/13/postgresql-commit-times) and, naturally, used Postgres to do it. _Spoiler: Postgres committers seem to increasingly be morning people_ 😁 - 🎄 Can you solve [Advent of Code](https://adventofcode.com/)'s daily programming challenges using just Postgres? Greg Sabino Mullane is [certainly trying to do so.](https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-1) And [here's day two](https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-2). - Chris Winslett reflects on [Postgres's JSON support being 10 years old.](https://www.crunchydata.com/blog/state-of-json-in-postgres-2022) - [Amazon RDS Proxy now supports](https://aws.amazon.com/about-aws/whats-new/2022/12/amazon-rds-proxy-supports-postgresql-major-version-14/) Postgres 14. [Enums vs Check Constraints in Postgres](https://www.crunchydata.com/blog/enums-vs-check-constraints-in-postgres) — Enums or check constraints, which one is better? Craig suggests that check constraints offer more options. Craig Kerstiens [pg_dump Compression Specifications in Postgres 16](https://www.cybertec-postgresql.com/en/pg_dump-compression-specifications-postgresql-16/) — Dumps created with `pg_dump` can be compressed by `pg_dump` itself by using various command line flags. Postgres 16 will take things a step further by letting you specify the level of compression _and_ method of compression via flags. Pavlo Golub ['I Migrated from a Postgres Cluster to Distributed SQLite with LiteFS'](https://kentcdodds.com/blog/i-migrated-from-a-postgres-cluster-to-distributed-sqlite-with-litefs) — Not your typical database migration, but with interest around the file-oriented SQLite database picking up, I think we’ll continue to see it pick up more use cases that may have traditionally fallen to Postgres or MySQL. Kent C Dodds ▶[Being a Better Developer with `EXPLAIN`](https://www.youtube.com/watch?v=IwahVdNboc8) — This isn’t new but is a classic 40-minute talk that digs into the world of query parsing and planning and how to analyze query plans created with the `EXPLAIN` command. Continues to be relevant and useful. Louise Grandjonc 🛠 Code and Tools ['How We Built the Fastest Postgres DB for Analytics'](https://hydras.io/blog/2022-12-13-how-we-built-fastest-postgres-db-for-analytics) — A bold claim. Hydra is an open-source ([code here](https://github.com/HydrasDB/hydra)) data warehouse built on top of Postgres for OLAP and hybrid workloads that’s commercialized by way of a fully-managed platform. Along with the expected favorable benchmarks, this post goes into some depth on just _how_ Hydra approaches the performance issue. Joe Sciarrino (Hydra) [PGTracer: EBPF-Powered Tracing Tools for Postgres](https://github.com/aiven/pgtracer) — For when you want to go deep. Uses Linux’s eBPF facilities (in short, a way to inspect activities within the kernel that began its life as a packet filtering tool) to attach to a running Postgres backend, monitor queries, and instrument things. Aiven [Dynaboard: The Pro-Code Web App Builder Made for Developers](https://dynaboard.com/?utm_source=cooperpress&utm_medium=email&utm_campaign=procode-q42022) Dynaboard sponsor [An 'Edge-Compatible' Serverless Driver for Postgres on Neon](https://neon.tech/blog/serverless-driver-for-postgres/) — A [serverless PostgreSQL driver](https://www.npmjs.com/package/@neondatabase/serverless) for connecting to [Neon](https://neon.tech/) (a new ‘serverless Postgres’ platform) databases from Cloudflare Workers and other environments supporting WebSockets. George MacKerron (Neon) [Redis FDW: A Postgres Foreign Data Wrapper for Redis](https://github.com/pg-redis-fdw/redis_fdw) — Bills itself as an “_at your own risk_” project, but is apparently used in production. Andrew Dunstan and Dave Page - [pg_graphql 1.0.1](https://github.com/supabase/pg_graphql) ↳ Add GraphQL support to your Postgres. - [Norm 2.6.1](https://github.com/moigagoo/norm) ↳ A Nim ORM for SQLite and Postgres. - [Slashbase 0.1](https://github.com/slashbaseide/slashbase) ↳ In-browser database IDE. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter.](https://postgresweekly.com/leave/*|UID|*)