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
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
18 July 2022
Different approaches for tracking visitor counts with PostgreSQL.
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.
22 March 2021
Learn why Kevin is building intheloop.dev with Supabase
11 March 2021
Free hosted relational database from within your node.js repl
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?