Minimal Modeling

Home
Notes
Archive
About

Sitemap - 2021 - Minimal Modeling

Flexible database schemas

Migrations: migrating attributes, pt. IV

Modeling pairs and tuples

Migrations: migrating attributes, pt. III

Migrations: migrating attributes, pt. II

Migrations: migrating attributes, pt. I

Handling time with supersecond resolution

Migrations: Getting rid of anchors is awesome

Migrations: Getting rid of links

Migrations: getting rid of attributes

Database modeling, stakeholders and their concerns

Migrations: adding links

Migrations: adding attributes

Introduction to schema migrations

Modeling mutual friendship

Best ideas from the first 25 posts

Extending booleans to enums

Making sense of 1NF, pt. II

Designing data access layer, pt. I

A comprehensive guide to storing boolean values

How to delete a lot of data, pt. II

How to delete a lot of data

Propagation delay

UNION ALL, pt. II: polymorphic data

VERTICAL JOIN, pt. I

240 tables and no documentation?

Left joins, pt. II

Many faces of left join

Game theory in database design

Persisting either/or values, or The uselessness of CHECK constraint

Erasure

Requirements change: migrating either/or data schema

How else to store either/or data

How to store either/or data in the database

Structural and pure attributes

Dependent and independent pieces of data

Concatenability of either/or data

Concatenability principle

Database constraints, pt. II

Database Constraints, pt. I

© 2025 Alexey Makhotkin
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture

Share