--- title: "Adding an SQLite column type to Postgres" publication: "Postgres Weekly" issue: 578 published_at: "2024-11-20" canonical_url: "https://postgresweekly.com/issues/578" --- Plus a sneaky compatibility problem for Postgres 17.1. | #​578 — November 20, 2024 [Web Version](https://postgresweekly.com/issues/578) Together with [![Crunchy Data\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_430,h_100/e_make_transparent/co_white,e_outline:7/xyflkz7n00elwtgja9ne.png)](https://www.crunchydata.com/products/warehouse?utm_source=cp-pg-112024) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/xgy2mwq6o3qe9bdghco8.jpg)](https://www.postgresql.org/about/news/postgresql-171-165-159-1414-1317-and-1221-released-2955/) [Postgres 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21 Released](https://www.postgresql.org/about/news/postgresql-171-165-159-1414-1317-and-1221-released-2955/) — A roundup of releases for every maintained line of Postgres including bug fixes and fixes for four security issues. 12.21 also marks the final release of Postgres 12. Be careful with upgrading to Postgres 17.1, though, as there are some potential compatibility issues.. _see the next item!_ PostgreSQL Global Development Group [A Change to ResultRelInfo: A Near Miss with Postgres 17.1](https://www.crunchydata.com/blog/a-change-to-relresultinfo-a-near-miss-with-postgres-17-1) — A seemingly minor change in the Postgres 17.1 release led to compatibility issues with some extensions (such as TimescaleDB and Apache AGE – see [what TimeScale’s CTO had to say here](https://x.com/michaelfreedman/status/1857148280167174455)). Craig explains what the issue is and why it arose here, reminding us that developing extensions robust to such changes is a full time job. Craig Kerstiens [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/3cabfe52.png)](https://www.crunchydata.com/products/warehouse?utm_source=cp-pg-112024) [Postgres Reimagined for Data Warehousing](https://www.crunchydata.com/products/warehouse?utm_source=cp-pg-112024) — Crunchy Data Warehouse combines managed storage, a powerful analytics engine, and unified data pipeline. Seamlessly query data using familiar Postgres tools with the added benefit of columnar storage and performance. Crunchy Data sponsor [Boosting `INSERT` Performance by 50% with `UNNEST`](https://www.timescale.com/blog/boosting-postgres-insert-performance/) — You probably know that using `COPY` is usually the fastest way to ingest data into Postgres at scale, but `INSERT` retains some advantages due to its extra features. Can `INSERT` be sped up? `UNNEST` arrives to shake things up.. James Blackwood-Sewell **QUICK BITS:** - 📅 Microsoft's virtual [POSETTE Postgres conference](https://posetteconf.com/2025/) is back in 2025 and [it has a call for proposals now open](https://posetteconf.com/2025/cfp/) if you'd like to speak. It takes place in June 2025, but you have until February 9 to get your proposals sent in. - 📅 [The CFP](https://2025.pgconf.dev/cfp) for [PGConf.dev 2025](https://2025.pgconf.dev/), taking place in Montreal next May, is also open right now until January 1. - 🗣️ [EDB's Ayse Bilge Ince](https://postgresql.life/post/ayse_bilge_ince/) is this week's _PostgreSQL Person of the Week_interviewee. - 🧊 [Crunchy Data has unveiled _Crunchy Data Warehouse_](https://www.crunchydata.com/blog/crunchy-data-warehouse-postgres-with-iceberg-for-high-performance-analytics), a managed service that brings a high performance analytics database into Postgres. [Easy Totals and Subtotals in Postgres with Rollup and Cube](https://www.crunchydata.com/blog/easy-totals-and-subtotals-in-postgres-with-rollup-and-cube) — Handy additions for performing more analytical queries. `ROLLUP` can create hierarchical subtotals along with a grand total, while `CUBE` generates subtotals for every possible combination of grouping columns. Elizabeth Christensen [Loading the World: An OpenStreetMap Import in Under 4 Hours](https://www.crunchydata.com/blog/loading-the-world-openstreetmap-import-in-under-4-hours) — Did you know that OpenStreetMap’s database is a whopping 750GB in size, and you can grab it and set it up for yourself as a way to stress-test Postgres? Greg looks at how long it takes to ingest, how to make it faster, and performance improvements over the years. _(Minor spoiler: Postgres 17 is 3% faster than Postgres 16 on this benchmark.)_ Greg Smith [Running Postgres on Spot VMs? 🤯](https://kmoppel.github.io/2024-11-19-postgres-on-spot-vms-only-for-the-crazy/) — Building on a talk from PGConf Europe, Kaarel looks at how viable it is to run Postgres on instances that could, well, disappear at almost any time. [pg-spot-operator](https://github.com/pg-spot-ops/pg-spot-operator) is a utility he’s built to make it work. Kaarel Moppel [The Doom That Came To Postgres: When Collations Change](https://thebuild.com/blog/2024/11/15/the-doom-that-came-to-postgresql-when-collations-change/) — What can happen when the library that provides locales changes out from under an existing Postgres database? _It’s not pretty.._ Christophe Pettus 📄 [What Happens Behind the Scenes When You Modify a Row in Postgres?](https://stormatics.tech/blogs/what-happens-behind-the-scenes-when-you-modify-a-row-in-postgresql) Semab Tariq 📄 [Grouping Data into Arrays of Sums – Fun with Custom Aggregates](https://www.depesz.com/2024/11/15/grouping-data-into-array-of-sums-fun-with-custom-aggregates/) Hubert depesz Lubaczewski 📄 [Accessing Large Language Models from Postgres](https://www.crunchydata.com/blog/accessing-large-language-models-from-postgresql) – A look at a few approaches. Paul Ramsey 🛠 Code and Tools [pglite-fusion: Embed SQLite Databases in Postgres Tables](https://github.com/frectonz/pglite-fusion) — An extension that gives you the ability to embed SQLite databases into Postgres tables by way of a special new `SQLITE` column type (so, yes, every row in a table could itself have an embedded SQLite database..) frectonz [DBngin: Simple Postgres, MySQL and Redis on Mac and Windows](https://dbngin.com/) — You could use [Docker](https://www.docker.com/blog/how-to-use-the-postgres-docker-official-image/), you could use [Postgres.app](https://postgresapp.com/).. but if you’d like to spin up different versions of several common databases using a simple UI, this could fit the bill. DBngin **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|*).