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.

25 points
*

Computing without databases is like going into a grocery store and all of the items are in one great pile. Sure, given enough time (CPU) and resources (RAM) you could find what you’re looking for, but it’s horribly inefficient.

Instead, things which are similar are grouped together, like the baking aisle (tables) and if you have to get most of the items for a cake, you know it’s on a specific shelf.

permalink
report
reply
3 points

This is nice explanation

permalink
report
parent
reply
21 points
*

ELI5 due to my smooth brain with these concepts

Database is a broad term, nearly any computer system that stores structured data like lists of names or transactions has a database of some kind. Dedicated database platforms like MySQL just make it more efficient / faster / easier to query and store data.

permalink
report
reply
5 points
*

Yeah, even the file system is a hierarchical database, same with Windows registry, Internet domain registry too, not every database has to be SQL or relations based. There also are time based databases like influxdb for storing time based data, like metrics, logs

permalink
report
parent
reply
18 points

I think The Manga Guide to Databases would be a good read for you.

Be sure to avoid places where you can get the book for free such as here.

permalink
report
reply
8 points

Thank you for the warning. I made sure to bookmark it so if i ever stumble upon it by accident, I’ll immediately know i need to leave.

permalink
report
parent
reply
6 points

Yeah, I would never go there. Just like I won’t go here

permalink
report
parent
reply
4 points

Thanks for sharing places to avoid so we can stay safe online 💜

permalink
report
parent
reply
2 points

Hey, that’s awesome! Also, thanks for the warning on that second link. It’s always good to look out for others who don’t know any better.

permalink
report
parent
reply
2 points

I just bought the book off Nostarchpress last month

permalink
report
parent
reply
15 points

If I understood your question correctly,

A database is a base for your data, its where your data lives.

A data is the most important thing for most modern applications. You have an account in Lemmy. You have made posts and comments. All that post texts, images, etc has to be recorded somewhere in the server. Thats what a database does.

permalink
report
reply
10 points

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.

permalink
report
reply

Technology

!technology@lemmy.world

Create post

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


Community stats

  • 18K

    Monthly active users

  • 11K

    Posts

  • 505K

    Comments