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

Technology

58981 readers
5076 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
 

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] 8 points 5 months ago (1 children)

Databases aren't related to VMs or containers.

https://en.m.wikipedia.org/wiki/Database does a good job of describing what a database is. That page also has a lot of examples of uses of databases.

To answer your question about MySQL: in my experience it's rarely used outside of classrooms or archaic systems. Postgres is a much better general-purpose option for SQL. Sqlite is also nice for different use cases (such as a database on a mobile device).

[–] [email protected] 1 points 5 months ago (1 children)

MySQL is unfortunately still rather popular. Loads of PHP based sites like Wikipedia and WordPress are all MySQL still.

It's catching up a bit, especially the forks like Percona Server and MariaDB.

[–] [email protected] 1 points 5 months ago

Yeah that's what I was referring to by "archaic". Pretty much anything using the LAMP stack falls in that category. I don't generally see new things using it.