From bb2706e6ce991afa231289c48f5ab8fcaebcc959 Mon Sep 17 00:00:00 2001 From: alex Date: Tue, 15 Sep 2026 21:49:12 +0200 Subject: Add some random notes --- blog/content/notes/tech/about-relational-databases.gmi | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'blog/content') diff --git a/blog/content/notes/tech/about-relational-databases.gmi b/blog/content/notes/tech/about-relational-databases.gmi index d08071ac..1760f0b3 100644 --- a/blog/content/notes/tech/about-relational-databases.gmi +++ b/blog/content/notes/tech/about-relational-databases.gmi @@ -25,3 +25,15 @@ Many computer languages have similar concepts: * PHP arrays Relations are a natural concept, so although non-relational data systems exist, most data can be stored as relations. + +## Random notes + +### About schema design + +* Only denormalize when provably forced to. +* If implementing business logic requires complex queries, then the schema might not be optimal. +* Normalization is not always obvious. It might look redundant to include the product unit price in the line item of an order, because the database already stores the product price, but you need to record the price at the time of the order, which might not be permanent. + +### Others + +=> real-time-relations Real-time relations describes a simpler relational database for real-time software. -- cgit v1.2.3