--- title: "Even better robots writing SQL" publication: "Postgres Weekly" issue: 540 published_at: "2024-01-31" canonical_url: "https://postgresweekly.com/issues/540" --- Plus Tom Lane takes the gold, and should Postgres and SQLite get along better? | #​540 — January 31, 2024 [Web Version](https://postgresweekly.com/issues/540) Together with [![Hasura\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_285,h_84/e_make_transparent/co_white,e_outline:5/rqccs6gvtpeifpf64bb4.png)](https://hasura.io/graphql/database/postgresql?utm_source=postgres-weekly&utm_medium=newsletter) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/rmrxh02ntgmptq2xt5d3.jpg)](https://gist.github.com/theory/898c8802937ad8361ccbcc313054c29d) [Towards an Ideal Postgres Extension Ecosystem](https://gist.github.com/theory/898c8802937ad8361ccbcc313054c29d) — Tembo [hired](https://tembo.io/blog/welcoming-david-wheeler) David Wheeler, creator of [PGXN](https://pgxn.org/), to work on the Postgres extension ecosystem, and he’s begun to share his initial ideas on how things could look. While there are several independent attempts to aggregate Postgres extensions (we even do it a bit ourselves), could Postgres benefit from a more official, authoritative approach? David Wheeler [pgvector 0.6.0: Now ~30x Faster with Parallel Index Builds](https://supabase.com/blog/pgvector-fast-builds) — The [pgvector](https://github.com/pgvector/pgvector) vector similarity search extension is arguably _the_ Postgres extension of the moment, and it keeps getting better. v0.6 introduces parallel index builds for HNSW, a huge win for rebuilding indexes potentially covering millions of vectors. Egor Romanov (Supabase) [![\](https://copm.s3.amazonaws.com/575c7523.png)](https://hasura.io/graphql/database/postgresql?utm_source=postgres-weekly&utm_medium=newsletter) [Instant Realtime GraphQL APIs on PostgreSQL with Hasura](https://hasura.io/graphql/database/postgresql?utm_source=postgres-weekly&utm_medium=newsletter) — Connect Hasura to your PostgreSQL database and get a secure and highly performant GraphQL API. Query tables and views with filtering, sorting, pagination, aggregations and more. Instantly pull any real-time changes to your data with subscriptions. Hasura sponsor [DuckDB's Multi-Database Support](https://duckdb.org/2024/01/26/multi-database-support-in-duckdb.html) — [DuckDB](https://duckdb.org/) is an SQLite_-esque_ in-process DBMS but focused on OLAP use cases. With the introduction of a pluggable storage and transactional layer, DuckDB can now connect to Postgres (or MySQL or SQLite) databases and work with them. This opens up some interesting use cases like moving data between different databases or formats (including Parquet) all from within DuckDB. Mark Raasveldt (DuckDB) _IN BRIEF:_ - 🤖 [SQLCoder-70b-Alpha](https://huggingface.co/defog/sqlcoder-70b-alpha) is a fine-tuned variant of the _CodeLlama-70B_ LLM designed to turn natural language queries into SQL. It's even licensed such that you can use it commercially. - Serverless Postgres platform [_Nile_ has raised $11.6m](https://www.thenile.dev/blog/funding-seed) to, well, keep building their serverless Postgres platform, which remains in private beta for now. - Robert Haas has done his usual annual analysis of [who contributed to Postgres development in the past year](https://rhaas.blogspot.com/2024/01/who-contributed-to-postgresql.html). As always, [Tom Lane](https://en.wikipedia.org/wiki/Tom_Lane_%28computer_scientist%29) takes gold! 🥇 - Jarred Sumner, creator of the [Bun](https://bun.sh/) JavaScript runtime, [🐦 ponders the idea of 'Postgreslite'](https://twitter.com/jarredsumner/status/1751967157884432652), essentially a dream of SQLite and Postgres being more compatible with one another. - [🐦 Phil Eaton has joined EDB](https://twitter.com/eatonphil/status/1751969053801885994) to work on their multi-master distributed Postgres offering. - Lætitia Avrot [invites you to blog about UUIDs](https://mydbanotebook.org/post/uuid-fight/) and how you use them (alongside Postgres, hopefully!) The deadline is this Friday.. - A look at [how Postgres will participate in FOSDEM 2024](https://andreas.scherbaum.la/post/2024-01-24_postgresql-fosdem-2024/) this weekend. Looks fun! [Getting JSON and SVG from PostGIS into Google Sheets](https://www.crunchydata.com/blog/json-and-svg-from-postgis-into-google-sheets) — A walk through using `pg_featureserv` to create JSON and `pg_svg` to create SVG images directly from your database to feed into a spreadsheet. Elizabeth Christensen [How to Load Stack Overflow's StackExchange Data into Postgres](https://ftisiot.net/posts/stackoverflow-postgresql/) — It’s an interesting process in itself, but the dataset offers potential for experimenting with your analytics skills or just seeing how Postgres scales. Francesco Tisiot [Partitioning Postgres Tables by Timestamp Based UUIDs](https://elixirforum.com/t/partitioning-postgres-tables-by-timestamp-based-uuids/60916) — A story from the Elixir forum about partitioning a table with 28 million rows in order to improve query speeds. _(Note: The approach shown is very much targeted at Elixir developers.)_ Chris O'Brien 📰 Classifieds 📢 100% PostgreSQL distributed across 3 regions with multi-master, latency-based DNS routing available in a fully managed cloud - [free sign up](https://www.pgedge.com/get-started/cloud). --- 🪐 Build your permissions system with Go and open-source. [SpiceDB is the open-source implementation](https://authzed.com/spicedb?utm_source=sponsored_newsletter&utm_medium=display&utm_campaign=golang_newsletter) of Google Zanzibar. 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/vgvmip7umszc8ajysylb.jpg)](https://github.com/cybertec-postgresql/pg_show_plans) [pg_show_plans: Show Query Plans of All Running Statements](https://github.com/cybertec-postgresql/pg_show_plans) — Lets you get live access via `SELECT * FROM pg_show_plans` or you can see it joined against `pg_stat_activity` via the `pg_show_plans_q`view. CYBERTEC PostgreSQL International GmbH - [FerretDB 1.19](https://github.com/FerretDB/FerretDB) – It's like MongoDB, but on Postgres. - [pg_timetable 5.8](https://github.com/cybertec-postgresql/pg_timetable/releases/tag/v5.8.0) – Advanced scheduling extension. - [Prisma 5.9](https://github.com/prisma/prisma/releases/tag/5.9.0) – Next-gen ORM for Node.js & TypeScript. - [pgrx 0.11.3](https://github.com/pgcentralfoundation/pgrx) – A way to build Postgres extensions with Rust. - [pgwire 0.19.2](https://github.com/sunng87/pgwire) – Postgres wire protocol in a Rust library. **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|*).