Insert-only data modeling with PostgreSQL?
Introduction to insert-only data modeling with PostgreSQL. And a test scenario for a possible use case, highlighting performance benefits
Logging of data modifications and the “log_statement” configuration parameter
A short reminder on how PostgreSQL logs executed statements. Also included: a closer look at the log_statement parameter.
Inheritance - One more reason to love PostgreSQL
The PostgreSQL feature "inheritance" works like a charm. You ask why? Well, here are the details we really like about it.
PostgreSQL exclusion constraints: Beyond UNIQUE
UPDATED AUGUST 2023: A couple of years ago, PostgreSQL introduced so called “exclusion constraints”, which are defined with the EXCLUDE […]
By coincidence I noticed that psql can produce perfect LaTeX code. How cool is that? We show you how to do it, with examples.
Flexible grouping: Some dirty SQL trickery
How to group PostgreSQL data with some dirty SQL trickery. Find the difference between timestamps; how to use flexible grouping.
Indexing Wikipedia with PostgreSQL | The goal is to see which settings are most suitable for the creation of a GIN index.
Fuzzy search solves the problem of spelling errors in searches. The goal is really to make sure that users have a chance - even with typos.
Partial aggregation: The beautiful way
Partial aggregation: Functions such as min, max, count, sum, avg and so on are used in virtually every application. Find out more.
Forking databases - the art of copying without copying
I received a question about how to fork PostgreSQL databases like you can do on Heroku. As I did not […]