Tag: data modeling

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: data modeling. You can go back to all blog posts or take a look into our other categories & tags.

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

by Michał Małecki | 01.2022
Normalization by Osmosis Part 2: Practical Examples of Data Normalization in PostgreSQL Having gone through a theoretical introduction in part […]

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

by CYBERTEC Guest | 11.2020
A few years ago, I wrote a short post on a similar topic; since then, I’ve often seen that the […]

Insert-only data modeling with PostgreSQL?

by CYBERTEC Guest | 08.2016
By Kaarel Moppel - In recent years, there has been quite a lot of buzz about “insert-only” approaches and some […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram