this post was submitted on 28 May 2024
37 points (84.9% liked)

Technology

59148 readers
2703 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 content.
  3. Be excellent to each another!
  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, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots

founded 1 year ago
MODERATORS
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
37
Databases and their real world use examples (lemmy.world)
submitted 5 months ago by [email protected] to c/[email protected]
21 comments fedilink hide all child comments
 

I am very curious as to how databases are used in the real world, whether you're using MySQL and what not, how does it all come together in a real world business? Banking and gaming I know, but is it something that gets stored on data centres and then put into a VM?

I might be overcomplexing this but I understand the good use cases with VMs and containers etc just not with databases.

I'd google, but I'd like a ELI5 due to my smooth brain with these concepts, thank you.

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 10 points 5 months ago

The Lemmy app we are using on our phones needs to download content from Lemmy so it can be displayed to us. Lemmy might just have one big file full of links, but that's annoying to have to write code to handle. Or it might have a folder full of files where each file is a post, but that's also a bit annoying to write code to manage.

It (probably) uses a local SQLite database to store all of the cached posts.

Conceptually, a database is just a place to store things, just like a big text file. The database just handles a lot of the grunt work for you and makes it easier to search, organize, and filter the data.

So anywhere there is data, there could be a database.