Postgres, SQLite, etc are tools for database management, things like user data, application data and so on are collected here.
Take Reddit’s Karma system or Upvotes/Downvotes for example, they’re stored in a database and however Reddit wants to utilize that data Postgres makes it easy to call upon it.
I’m sure others can give more detailed responses, I’m typing this out in a rush.
Interesting that you chose Reddit as an example. They have a fascinating origin story with respect to data mart. Early Reddit had just two tables: Thing and Data, where Thing was metadata about types and Data was a three column table with: type, id, and value.
Wrap your head around that. All of Reddit, two tables. A database couldn’t be less normalized (final boss of normal forms) and they did it in an rdb. So horrific it’s actually kind of cool.
DB_PASS=“postgres” 😬😬😬
so, uh… can you ELI5 this for those of us that don’t know anything?
It’s like having your password set to “password”
The type of database they are using is called “postgres”, which is also it’s password.
I will assume this is just the password they use in development. But they should probably be using pglite.
Postgres, SQLite, etc are tools for database management, things like user data, application data and so on are collected here.
Take Reddit’s Karma system or Upvotes/Downvotes for example, they’re stored in a database and however Reddit wants to utilize that data Postgres makes it easy to call upon it.
I’m sure others can give more detailed responses, I’m typing this out in a rush.
Interesting that you chose Reddit as an example. They have a fascinating origin story with respect to data mart. Early Reddit had just two tables: Thing and Data, where Thing was metadata about types and Data was a three column table with: type, id, and value.
Wrap your head around that. All of Reddit, two tables. A database couldn’t be less normalized (final boss of normal forms) and they did it in an rdb. So horrific it’s actually kind of cool.
Is this real lmao