Comment on Trump team leaks AI plans in public GitHub repository

• crookfingerjake@lemmy.world ⁨3⁩ ⁨weeks⁩ ago

  The type of database they are using is called “postgres”, which is also it’s password.

  source

  • SocialMediaRefugee@lemmy.world ⁨3⁩ ⁨weeks⁩ ago

    They should’ve used “1234”

    source

    • faythofdragons@slrpnk.net ⁨3⁩ ⁨weeks⁩ ago

      That’s the combo on my luggage!

      source
  • joyjoy@lemmy.zip ⁨3⁩ ⁨weeks⁩ ago

    I will assume this is just the password they use in development. But they should probably be using pglite.

    source
• ohshit604@sh.itjust.works ⁨3⁩ ⁨weeks⁩ ago

  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.

  source

  • theherk@lemmy.world ⁨3⁩ ⁨weeks⁩ 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.

    source

    • ohshit604@sh.itjust.works ⁨3⁩ ⁨weeks⁩ 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!

      source
• lepinkainen@lemmy.world ⁨3⁩ ⁨weeks⁩ ago

  It’s like having your password set to “password”

  source
• forgeddit@sopuli.xyz ⁨3⁩ ⁨weeks⁩ ago

  The person you replied to doesn’t know what they’re talking about. It’s just an example password used for running a local empty DB for development and has nothing to do with production or even test databases.

  You can see this in the readme: archive.softwareheritage.org/browse/…/directory/?…

  See my longer previous comment if you want to know more. And again, not defending this project, but this whole comment chain was just misinformation.

  source