Let’s say you created a Go program that stores data in PostgreSQL — you installed PostgreSQL, wrote the Go code, and everything works; great! But after writing a test for your code, you wonder: how do you best provide PostgreSQL to your automated tests?

Upgrades between PostgreSQL major versions are famously annoying. You can’t just install the server binaries and restart, because the format of the data directory is incompatible. Why is that? Why can’t we just keep the data format compatible?

See what PostgreSQL batch ingest method is right for your use case: in this article, we benchmark INSERT (VALUES and UNNEST) vs. COPY (text and binary).

Spot vulnerabilities in postgres SQL scripts. Contribute to timescale/pgspot development by creating an account on GitHub.

Ok folks, this is kind of a weird one. I'm going to put it in the "you won't ever need this, but if you do, you are going to be glad I wrote this up for ya" category. As you may or may not know, I recently acquired fireside.fm,

Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved. - frectonz/pglite-fusion

Paul shows you how to use a new OpenAI API extension for working with LLMs in Postgres.

Postgres is already great, surely - even “too popular” one could complain with a twist…as this broadcast “was” actually supposed to be my Lightning Talk at last month’s pgConf.eu in Athens 🙂 But indeed, seems Postgres has in an awesome way gotten so big that it’s not like that anymore...

Read how you can double your Postgres INSERT performance using the UNNEST function.

A new point version was released on Nov 14th for 17.1, 16.5, 15.9, and others. This included an update to the Postgres ABI potentially breaking extensions. Craig digs into the change and what you need to know.

Postgres to Elasticsearch/OpenSearch sync.

psql is a CLI editor that ships with Postgres. It’s incredibly powerful for working with Postgres, and doesn’t take too much of a learning curve to start to get comfortable so you can really feel like an expert working with your database. Just a rundown of a few things to get you started:

A key aspect of maintaining backup integrity is understanding data checksums. Without proper checksum validation, detecting data corruption becomes virtually impossible. Therefore, we will start with The...

Official PostgreSQL port of Sqids. Generate short unique IDs from numbers. - sqids/sqids-postgresql

PostgreSQL 17 on Cloud SQL has new features across security, developer experience, performance, tooling, and observability.

A wrapper around psql where connection information is pulled from Azure Key Vault - kometen/rusty_psql

Parses PostgreSQL dump files into an array of schema objects. - gajus/pg-dump-parser

The reigning champion of MySQL proxies, ProxySQL, has set its sights to conquer new territory. Today marks the dawn of a new era as ProxySQL unveils its 3.0.0-Alpha release, bringing PostgreSQL - the darling of developers, and the titan of open source databases - under its formidable umbrella. A Game Changing Expansion Long respected for its

Accelerated Sparse Linear Algebra with Postgres and SuiteSparse - OneSparse/OneSparse

I wrote a blog post a couple of weeks ago entitled Is pg_dump a Backup Tool? . In that post, I argued in the affirmative, but also said that...

Because Postgres have counterintuitive rules around case.

Today, I want to share a different type of post. Nothing polished. Just me goofing around with PostgreSQL's full-text search capabilities.

PostgreSQL and MariaDB are the fastest mainstream open-source databases. MySQL has some catching up to do.

Migrating in-place from PostgreSQL to MySQL Alex Toumazis, Software Engineer Oct 7, 2024 The Yelp Reservations service (yelp_res) is the service that powers reservations on Yelp. It was acquired along...

We at Tembo truly love Postgres. We're convinced everyone would love Postgres just as much as we do if only upgrading Postgres between major versions wouldn't be so darn difficult.

Iceberg/Delta Columnstore Table in Postgres.

Simple HTTP server to help build intuition for MemoryContexts in Postgres - eatonphil/pgweb