Did you know that Set Theory is a fundamental building block for studying databases? : )

Can't beat a good old fashioned for loop.

EVERYTHING IS MATH, AAASA

What if I told you that you can build a database without having studied that all. Fundamental, my ***

did you know that boolean logic is a fundamental building block for computer science?

..oh - what? sorry. i thought we all were writing down obvious stuff.

@tosensei I was passing in front of Boole's house everyday when i was living in ireland.

He had a very pretty house.

@retoor I swear just make up new terminology all the time

@jestdotty Is that Mexican? lol

@donkulator A binary search tree could be faster.

@retoor For me, joins weren't easy to understand. The entire aggregation and filtering principle of data also relies on that theory. It provides the mathematical foundation for how data is stored, organized, and queried and it helps with design and the mental models.

Union, intersection, difference, cartesian product are all fundamentals of how data is queried in a database.

Moreover, if you have an issue, you can extrapolate it to a mathematical model, solve it there and then map it back to the implementation. Better understanding of queries, optimization (e.g. associativity), engineering etc. You have a common language.

Without it, databases wouldn’t exist as we know them. It’s the engine under the hood — defining how data is stored, how queries are structured, and how logic is applied.

These principles ensure databases are reliable, efficient, and maintain data integrity, which cannot be said for most db design these days.

@retoor Fundamental, my fundament?

@CaptainRant what kept sqlite so reliable is one single developer not accepting pull requests. One guy that knows what he's doing. I LOVE sqlite, I've read a lot of source code. It's also so extensible. That sqlite would be good for only small websites is a hoax. Nothing is really concurrent. If you implement sqlite in your application, your application IS the database being able to do tens of queries while the other databases are still waiting for their data to be streamed or something. Never had a corrupt database so far. Can't say the same for MySQL.

There are amazing hours long videos online about sqlite implementation.

Molodetz.nl is the result of 14.431.838 records stored in sqlite. My key logger data since months. Statistics run still fast. I regenerate them all almost daily. The key logger literally never faced an issue because of integrated database and C. Normally you would have some service that had to boot first or required maintenance.