PostgREST: Get started with automated PostgreSQL APIs
PostgREST quick-start guide: Writing APIs by hand is a lot of work. PostgREST automatically generates an API out of your PostgreSQL database.
ER diagrams with SQL and Mermaid
What does ER stand for? An Entity Relationship (ER) diagram is one of the most important tools for database design. […]
Go & PostgreSQL: FOSDEM 2023 talk
Intro On the 5th of February 2023, I had the privilege of giving a talk at the PostgreSQL devroom during […]
PostgreSQL: Finding the current timestamp
How can I find the current timestamp in PostgreSQL? Read more about real time, statement time and transaction time.
A unique constraint where NULL conflicts with everything
by
Laurenz Albe |
01.2023 I have been faced with a request for an unusual unique constraint that puzzled me for a while. Since […]
Pagination and the problem of the total result count
by
Laurenz Albe |
01.2023 When processing a big result set in an interactive application, you want to paginate the result set, that is, […]
Improving GROUP BY with CREATE STATISTICS
For a PostgreSQL time series report - find out how CREATE STATISTICS can improve performance when you group on expressions
UNION ALL, data types and performance
by
Laurenz Albe |
12.2022 A while ago, I wrote about the performance impact of query parameter data types. Recently I encountered a similar […]
Faceting large result sets in PostgreSQL
While the term faceting may sound foreign to you, you almost certainly have run into it in your adventures online. […]
Partition PostgreSQL: which partition did I INSERT my data into?
When partitioning in PostgreSQL, it's not obvious how to find the location of data afterwards. Here's some great partition tips and tricks.
