this post was submitted on 22 Jun 2024
812 points (98.7% liked)
Programmer Humor
32051 readers
1601 users here now
Post funny things about programming here! (Or just rant about your favourite programming language.)
Rules:
- Posts must be relevant to programming, programmers, or computer science.
- No NSFW content.
- Jokes must be in good taste. No hate speech, bigotry, etc.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
You can make an unstructured database? I thought the S in SQL stood for "structured", that it was built into the language itself or something.
Database is organized collection of data, so a disk full of porn in different formats from json to mp4 can be a database, as long as it's organized in some way
Right? Organized, structured, same thing, or? A database can't have no structure, right? I don't even know how one would create such a database.
At a certain level all data is a pair (some name, blob of bytes). You can concatenate sequences of those pairs into a tar archive and call that a database. To access "the last object" you'd have to seek over the "first" objects. So you can build another set of (some name, blob of bytes) that serves as an index into the first set. You'll first have to do at least one full pass over that first set, and you'll need to make space on the books to account for twice as many sets, AND you'll still have to do some seeking over the "first objects" in the indexing collection, but it all keeps recall times very short!