this post was submitted on 16 Jun 2025
649 points (98.9% liked)

Technology

71495 readers
4917 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 9 points 19 hours ago (4 children)

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

[–] forgeddit@sopuli.xyz 6 points 13 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.

[–] crookfingerjake@lemmy.world 36 points 19 hours ago (2 children)

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

[–] SocialMediaRefugee@lemmy.world 5 points 13 hours ago (1 children)
[–] faythofdragons@slrpnk.net 6 points 10 hours ago

That's the combo on my luggage!

[–] joyjoy@lemmy.zip 3 points 18 hours ago

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

[–] lepinkainen@lemmy.world 10 points 17 hours ago

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

[–] ohshit604@sh.itjust.works 15 points 19 hours ago* (last edited 13 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 17 hours 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 13 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!