this post was submitted on 16 Jun 2025
706 points (98.6% liked)

Technology

71530 readers
4272 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 news or articles.
  3. Be excellent to each other!
  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, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
  9. Check for duplicates before posting, duplicates may be removed
  10. Accounts 7 days and younger will have their posts automatically removed.

Approved Bots


founded 2 years ago
MODERATORS
 

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

you are viewing a single comment's thread
view the rest of the comments
[–] Crozekiel@lemmy.zip 10 points 1 day ago (4 children)

so, uh... can you ELI5 this for those of us that don't know anything?

[–] crookfingerjake@lemmy.world 38 points 1 day ago (2 children)

The type of database they are using is called "postgres", which is also it's password.

[–] SocialMediaRefugee@lemmy.world 5 points 1 day ago (1 children)
[–] faythofdragons@slrpnk.net 7 points 21 hours ago

That's the combo on my luggage!

[–] joyjoy@lemmy.zip 3 points 1 day ago

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

[–] forgeddit@sopuli.xyz 9 points 23 hours 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: https://archive.softwareheritage.org/browse/origin/directory/?origin_url=https%3A%2F%2Fgithub.com%2Fgsa-tts-archived%2Fai-gov-api

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.

[–] ohshit604@sh.itjust.works 16 points 1 day ago* (last edited 23 hours ago) (1 children)

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.world 9 points 1 day ago (1 children)

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.works 2 points 23 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!

[–] lepinkainen@lemmy.world 10 points 1 day ago

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