Address
:
[go:
up one dir
,
main page
]
Include Form
Remove Scripts
Accept Cookies
Show Images
Show Referer
Rotate13
Base64
Strip Meta
Strip Title
Session Cookies
Minimal Modeling
Subscribe
Sign in
Home
Notes
Archive
About
Database Design Book released!
137-page PDF, €32. See table of contents and sample chapters.
Apr 21, 2025
•
Alexey Makhotkin
3
Latest
Top
Discussions
Subtypes and status-dependent data: pure relational approach
Using constant columns to solve a common problem of encoding status-dependent information (or subtypes, more generally).
Jan 29
•
Alexey Makhotkin
3
Common SQL queries through a non-1NF lens
For the past few months I’ve been working on “A modern guide to SQL JOINs” and some other book-related content.
Jan 12
•
Alexey Makhotkin
2
Documenting your data: WordPress case study, pt. 1
240 tables and no documentation: making sense of your database
Oct 1, 2025
•
Alexey Makhotkin
4
Virtual 6NF
Decomposing any database into minimal elements
Aug 8, 2025
•
Alexey Makhotkin
4
1
2
Multi-join queries design: investigation
From the ground up: studying multi-join queries.
Jun 9, 2025
•
Alexey Makhotkin
6
1
Systematic design of multi-join GROUP BY queries
I wrote a long-ish (5000+ words) tutorial on systematic design of complex analytical SQL queries.
May 25, 2025
•
Alexey Makhotkin
2
Relational modeling challenge
"Make invalid states unrepresentable" and the relational model
Feb 2, 2025
•
Alexey Makhotkin
7
14
1
See all
Minimal Modeling
Making sense of your database.
Subscribe
Recommendations
benn.substack
Benn Stancil
zverok on lucid code
Victor Shepelev aka zverok
Minimal Modeling
Subscribe
About
Archive
Recommendations
Sitemap
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts
