--- title: "PopSQL joins Timescale" publication: "Postgres Weekly" issue: 550 published_at: "2024-04-10" canonical_url: "https://postgresweekly.com/issues/550" --- Plus writing functions in C# and F#, and a WASM-based way to run Postgres for test scenarios. | #​550 — April 10, 2024 [Web Version](https://postgresweekly.com/issues/550) Together with [![Microsoft\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_280,h_60/e_make_transparent/co_white,e_outline:7/om9hjsmudy5lsvba59eb.png)](https://www.addevent.com/event/AE19906747) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/gflqbnsthccpjlwtvemc.jpg)](https://dhamaniasad.github.io/awesome-postgres/) [Awesome Postgres: A Curated List of 200+ Libraries, Tools, and Resources](https://dhamaniasad.github.io/awesome-postgres/) — A handy, curated resource that’s been around for years but continues to get updates. It covers all areas from backups to GUI clients, managed services to Docker images, blogs, and more. You can also contribute your own suggestions via [the repo](https://github.com/dhamaniasad/awesome-postgres). Asad Dhamani and Contributors [A Simple Query with a Big Problem](https://render.com/blog/postgresql-simple-query-big-problem) — _“Most of the time, PostgreSQL invisibly optimizes our queries, but sometimes, a query wreaks havoc..”_ If you like debugging stories, this is a good one. Eric Fritz [![\](https://copm.s3.amazonaws.com/ce2d7b6b.png)](https://www.addevent.com/event/AE19906747) [Save the Date for POSETTE: An Event for Postgres](https://www.addevent.com/event/AE19906747) — Wondering who will be speaking at the 3rd annual [POSETTE: An Event for Postgres](https://www.citusdata.com/posette/2024/)? POSETTE is a free & virtual developer event organized by the Postgres team at Microsoft. Schedule drops May 1, event is Jun 11-13. In the meantime, save the date! Microsoft sponsor [Protect Your Database with `pg_tde` (Transparent Data Encryption)](https://www.percona.com/blog/protect-your-postgresql-database-with-pg_tde-safe-and-secure/) — A tech preview release of an extension from Percona designed to provide transparent data encryption capabilities to Postgres. [GitHub repo.](https://github.com/Percona-Lab/pg_tde) Kai Wagner (Percona) [Compiling Postgres on macOS to Test Documentation and Patches](https://andyatkinson.com/blog/2024/04/09/compiling-postgresql-macos-docs-patches) — One developer’s experience compiling and installing Postgres from source. (And not just _any_ developer, but the author of Pragmatic’s [High Performance PostgreSQL for Rails](https://andyatkinson.com/pgrailsbook)). Andrew Atkinson 🎤 [Becoming Expert at Using PostgreSQL with Chris Ellis](https://pathtocituscon.transistor.fm/episodes/becoming-expert-at-using-postgresql-with-chris-ellis) — The latest episode of the _Path to Citus Con_ podcast. Chris Ellis et al. 📄 [Why Postgres Extensions Should be Packaged and Distributed as OCI Images](https://www.ongres.com/blog/why-postgres-extensions-should-be-distributed-and-packaged-as-oci-images/) Álvaro Hernández 📄 [PL/pgSQL Conversion Gotchas: How to Handle Conflicting Variables.](https://databaserookies.wordpress.com/2024/04/10/pl-pgsql-conversion-gotchas-how-to-handle-conflicting-variables/) Deepak Mahto 📄 [A Day in the Life of a Postgres Engineer at Fujitsu](https://www.postgresql.fastware.com/blog/day-in-the-life-hayato-kuroda) Hayato Kuroda 📄 [PgBouncer Connection Pooler for Postgres Now Supports More Session Vars](https://medium.com/flow-type/announcing-component-syntax-b6c5285660d0) Emel Simsek (Citus Data) 📄 [Features I Wish Postgres Had as a Developer](https://www.bytebase.com/blog/features-i-wish-postgres-had/) Tianzhou (Bytebase) 📰 Classifieds ▶️ [How Figma scaled out their Postgres installation by 100x over 4 years](https://pganalyze.com/blog/5mins-postgres-figma-dbproxy-sharding-postgres), and switched to horizontal sharding using their DBProxy query proxy. --- Tech professionals using Postgres need their domains from a registrar they can trust. Get .dev, .app, or .foo for just $5 from [Porkbun](https://sponsr.is/tld_postgresweekly)now. 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/p83wrccnvpaf7zm9fyoq.jpg)](https://www.timescale.com/blog/best-postgresql-gui-popsql-joins-timescale/) [Building the Best Postgres GUI? PopSQL Joins Timescale](https://www.timescale.com/blog/best-postgresql-gui-popsql-joins-timescale/) — The team behind the [PopSQL](https://popsql.com/) collaborative SQL editor has joined Timescale. Timescale [pgmock: An In-Memory Postgres for Unit/E2E Testing](https://github.com/stackframe-projects/pgmock) — No external dependencies and runs entirely within WebAssembly on both Node.js and the browser. [Here’s how it works.](https://github.com/stackframe-projects/pgmock?tab=readme-ov-file#how-does-it-work) Stackframe [Announcing PL/.NET 0.99: A Public Beta Release](https://www.postgresql.org/about/news/announcing-pldotnet-version-099-beta-2838/) — pl/dotnet adds full support for C# and F# to Postgres ([like this](https://github.com/Brick-Abode/pldotnet/?tab=readme-ov-file#usage-examples)). If you're in the .NET space, they want you to kick the tires a bit ahead of a final 1.0 release. [GitHub repo.](https://github.com/Brick-Abode/pldotnet/) Brick Abode - [pg_partman v5.1.0 & v4.8.0](https://github.com/pgpartman/pg_partman/releases/tag/v5.1.0) – Partition management extension. - [pg_dumpbinary v2.16](https://www.postgresql.org/about/news/pg_dumpbinary-v216-released-2836/) – Dump a database in binary format. - [pgAdmin 4 v8.5](https://www.pgadmin.org/docs/pgadmin4/8.5/release_notes_8_5.html) – Popular admin platform for Postgres. - [PGlite 0.1.2](https://github.com/electric-sql/pglite) – Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno. - [ParadeDB 0.6](https://github.com/paradedb/paradedb/releases/tag/v0.6.0) – Postgres for search and analytics. - [Mikro ORM 6.2](https://github.com/mikro-orm/mikro-orm) – TypeScript ORM for Node.js. **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|*).