this post was submitted on 27 Aug 2025
65 points (98.5% liked)

Technology

74994 readers
2727 users here now

This is a most excellent place for technology news and articles.


Our Rules


  1. Follow the lemmy.world rules.
  2. Only tech related news or articles.
  3. Be excellent to each other!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
  9. Check for duplicates before posting, duplicates may be removed
  10. Accounts 7 days and younger will have their posts automatically removed.

Approved Bots


founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] addie@feddit.uk 16 points 2 weeks ago (1 children)

The 'traditional' way of storing a database is on a mainframe or supercomputer, where all the information is stored in tables with the information all uniquely stored, frequently containing id references to other tables. For instance, an 'orders' table would have a customer id in it, and the 'customer' table would have their name and address. The programming language for databases like that is SQL - PostGres and Oracle are examples. That model gives you a lot of advantages - the data is always consistent, changes are either made completely or not at all - but every query has to go through one machine, so performance can suck, and you waste a lot of time 'joining' tables together for certain kinds of query.

If you're storing eg. a blog with comments on it, that model doesn't make sense. Each page has a varied selection of comments, comment will have a username and maybe their icon, which will rarely change, but will need to be evaluated by the database every time. It would make more sense to output the pre-rendered page as a JSON blob, and you could have a hundred machines with a few pages each to share the load. Updating people's icons and adding new comments would need to be done by telling each machine to make a certain update if they've a copy of that page; you'd 'eventually' be consistent, but if you don't care about that then you get a very scalable robust solution quite cheaply. Examples of such 'NoSQL' databases are MongoDB, Hadoop and DocumentDB.

Linux foundation have looked at DocumentDB's license and said 'yes, free enough for us', so they'll adopt it.

[–] doeknius_gloek@discuss.tchncs.de 12 points 2 weeks ago (1 children)
[–] RiQuY@lemmy.zip 3 points 2 weeks ago

Thank you for this, amazing video.