Tag: databases
-
MariaDB’s INT
Reminder to self: INT(3) DOES NOT mean the database will manage a smaller amount of memory or storage than INT(255). No, it doesn’t work that way. This is how it works. So instead of using INT(3) to hold somebody’s age data, we should use TINYINT(3). source: https://planetscale.com/learn/courses/mysql-for-developers/
-
UnFUDding SQLite for Web Development
One can safely assure that there are 4 things that keep human life possible on planet Earth: SQLite is this open-source ubiquitous small footprint database used by mostly every digital device on the planet. It’s everywhere: phones, TVs, billboard displays, navigation systems… you name it. However, despite its long time world wide adoption by virtually…
-
Codd’s 12 Rules
The year is 2025 and only now I learned about Edgard F. Codd’s 12 rules for database systems to be considered relational. For the records, I had my first contact with relational databases back in 1994. the rules Rule 0, The foundation rule: For any system that is advertised as, or claimed to be, a relational data…