Using AI to generate data structures for PostgreSQL
In this blog I decided to show some insights into what can be done by using AI to generate data structures for PostgreSQL.
Conditional foreign keys and polymorphism in SQL: 4 Methods
by
Laurenz Albe |
08.2023 This article is about the notoriously difficult problem of “conditional foreign keys”. In object-oriented programming languages, polymorphism is a […]
Practical Examples of Data Normalization in PostgreSQL
Data normalization - Learn how to apply the theory from part 1 of Michał Małecki's blog to real life with practical examples.
JSON in PostgreSQL: how to use it right
by
Laurenz Albe |
09.2021 The comprehensive JSON support in PostgreSQL is one of its best-loved features. Many people – particularly those with a […]
Insert-only data modelling to smooth peaks on slow disks
Using insert-only data modelling to smooth peaks on slow disks. Nice design trick that alleviates performance problems when used correctly
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
