CYBERTEC PostgreSQL Logo

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.

Using AI to generate data structures for PostgreSQL

by Hans-Jürgen Schönig | 07.2024
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

by Michał Małecki | 01.2022
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

by CYBERTEC Guest | 11.2020
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?

by CYBERTEC Guest | 08.2016
Introduction to insert-only data modeling with PostgreSQL. And a test scenario for a possible use case, highlighting performance benefits
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


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

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