Updated: The AI.gov repository and staging site vanished when we asked questions, but don't worry – we captured backups

The AI.gov repository and staging site vanished when we asked questions, but don’t worry – we captured backups

  • ohshit604@sh.itjust.worksEnglish
    161·
    9 hours ago

    Postgres, SQLite, etc are tools for database management, things like user data, application data and so on are collected here.

    Edit: the DB_PASS=“postgres” is the default password when setting up a Postgres database.

    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.

    • theherk@lemmy.worldEnglish
      9·
      14 hours ago

      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.

      • ohshit604@sh.itjust.worksEnglish
        2·
        9 hours ago

        Interesting that you chose Reddit as an example.

        I was in a rush! Honestly it was the quickest thing I could come up with on the spot, plus database tools are something I lack a lot of knowledge about so I really couldn’t go in depth even if I wanted to.

        Appreciate the history behind Reddit’s database!