1 May 2023
Exploring history of Postgres pluggable storage and the possibility of landing it in the Postgres core.
21 April 2023
New Features in the v1.2 release of pg_graphql
17 February 2023
Creating validated data types in Postgres
6 February 2023
An example of how to build an AI-powered search engine using OpenAI's embeddings and PostgreSQL.
16 December 2022
A Postgres extension to store encrypted secrets and encrypt data.
Describes new features of PostgREST 11 pre-release
We're making PITR available for more projects, with a new Dashboard UI that makes it simple to use.
Announcing the v1.0 release of pg_graphql
Describes the release of Postgres 15, new features and reasons to use it
15 December 2022
A framework for building Postgres Foreign Data Wrappers which connects to Stripe, Firebase, Clickhouse, and more.
10 December 2022
Embedding Yjs and Automerge into Postgres for collaborative applications.
1 December 2022
Using pgsodium's Transparent Column Encryption to encrypt data and provide your users with row-level encryption.
24 November 2022
How to turn Postgres into an easy-to-use NoSQL database that retains all the power of SQL
27 October 2022
A time-tested method for contributing to the core Postgres code
14 October 2022
Comparing one of the most popular Postgres features against alternatives
3 October 2022
We're open sourcing postgres-wasm, a PostgresQL server that runs inside a browser, with our friends at Snaplet.
8 September 2022
Turns out the question of which identifier to use as a Primary Key is complicated -- we're going to dive into some of the complexity and inherent trade-offs, and figure things out
19 August 2022
Today we're releasing pg_jsonschema, a Postgres extension for JSON validation.
18 July 2022
Different approaches for tracking visitor counts with PostgreSQL.
28 June 2022
Using RLS to create seed files for local PostgreSQL testing.
8 March 2022
PostgreSQL has a robust set of features which we can leverage to create a generic auditing solution in 150 lines of SQL.
2 July 2021
Using Postgres Hooks to protect functionality in your Postgres database.
5 March 2021
Running repetitive tasks with your Postgres database.
27 February 2021
Understand the top PostgreSQL Interview Questions
18 November 2020
Creating and using a view in PostgreSQL.
2 August 2020
Have you ever wanted to restore your database's state to a particular moment in time? This post explains how, using WAL-G.
9 July 2020
What are PostgreSQL templates and what are they used for?
7 July 2020
What are physical and logical backups in Postgres?
