▲ 695 ▼ Trump team leaks AI plans in public GitHub repository (www.theregister.com) submitted 1 year ago by bytesonbike@discuss.online to c/technology@lemmy.world 90 comments fedilink hide all child comments The AI.gov repository and staging site vanished when we asked questions, but don't worry – we captured backups
[–] titey@jlai.lu 57 points 1 year ago (15 children) DB_PASS="postgres" 😬😬😬 permalink fedilink source hideshow 15 child comments replies: [–] Crozekiel@lemmy.zip 11 points 1 year ago (9 children) so, uh... can you ELI5 this for those of us that don't know anything? permalink fedilink source parent hideshow 9 child comments replies: [–] crookfingerjake@lemmy.world 35 points 1 year ago (3 children) The type of database they are using is called "postgres", which is also it's password. permalink fedilink source parent hideshow 3 child comments replies: [–] SocialMediaRefugee@lemmy.world 5 points 1 year ago (1 child) They should've used "1234" permalink fedilink source parent hideshow 1 child comment replies: [–] faythofdragons@slrpnk.net 7 points 1 year ago That's the combo on my luggage! permalink fedilink source parent [–] joyjoy@lemmy.zip 2 points 1 year ago I will assume this is just the password they use in development. But they should probably be using pglite. permalink fedilink source parent [–] ohshit604@sh.itjust.works 15 points 1 year ago* (last edited 1 year ago) (2 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. permalink fedilink source parent hideshow 2 child comments replies: [–] theherk@lemmy.world 8 points 1 year ago (1 child) 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. permalink fedilink source parent hideshow 1 child comment replies: [–] ohshit604@sh.itjust.works 2 points 1 year 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! permalink fedilink source parent [–] forgeddit@sopuli.xyz 9 points 1 year 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. permalink fedilink source parent [–] lepinkainen@lemmy.world 10 points 1 year ago It’s like having your password set to “password” permalink fedilink source parent [–] Nobilmantis@feddit.it 10 points 1 year ago (1 child) I mean it is called ".env_example" afterall... Probably a env file to use for testing, no? permalink fedilink source parent hideshow 1 child comment replies: [–] forgeddit@sopuli.xyz 13 points 1 year ago I'm really shocked by the confidence people have here with clearly zero knowledge. ".env_example" is literally just the example/template which is only updated if new "config" items are needed and it doesn't contain actual secrets. Developers copy ".env"/prod and ".env_local" files, which are used for the specific environments. These are in .gitignore so that they're not accidentally pushed to .git. For production the ".env" is generated during deployment from secrets in a locked up environment. (I mean they COULD fuck this up, but there's no evidence of this AFAIK) The example postgres password is simply a "hello world" type password that is often used when running a local docker image of the DB so you can get a full dev environment running in a couple minutes, as mentioned in the readme.md: https://github.com/gsa-tts-archived/ai-gov-api It's not even a testing environment, it's a temporary local/dev DB just so you can test your code. I am NOT defending this project, but holy shit this thread is full of misinformation and I had to correct this. permalink fedilink source parent [–] Jakeroxs@sh.itjust.works 8 points 1 year ago (2 children) Is this real lmao permalink fedilink source parent hideshow 2 child comments replies: [–] ArtVandelay@lemmy.world 10 points 1 year ago (1 child) Unfortunately no, it seems. Somebody at least had the bare minimum sense to let GitHub generate the .gitignore for them, which includes most common environment files. https://github.com/gsa-tts-archived/ai.gov/blob/main/.gitignore permalink fedilink source parent hideshow 1 child comment replies: [–] forgeddit@sopuli.xyz 6 points 1 year ago It's from another repo and literally just an example env for an empty local docker DB: https://archive.softwareheritage.org/browse/origin/directory/?origin_url=https%3A%2F%2Fgithub.com%2Fgsa-tts-archived%2Fai-gov-api permalink fedilink source parent
[–] Crozekiel@lemmy.zip 11 points 1 year ago (9 children) so, uh... can you ELI5 this for those of us that don't know anything? permalink fedilink source parent hideshow 9 child comments replies: [–] crookfingerjake@lemmy.world 35 points 1 year ago (3 children) The type of database they are using is called "postgres", which is also it's password. permalink fedilink source parent hideshow 3 child comments replies: [–] SocialMediaRefugee@lemmy.world 5 points 1 year ago (1 child) They should've used "1234" permalink fedilink source parent hideshow 1 child comment replies: [–] faythofdragons@slrpnk.net 7 points 1 year ago That's the combo on my luggage! permalink fedilink source parent [–] joyjoy@lemmy.zip 2 points 1 year ago I will assume this is just the password they use in development. But they should probably be using pglite. permalink fedilink source parent [–] ohshit604@sh.itjust.works 15 points 1 year ago* (last edited 1 year ago) (2 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. permalink fedilink source parent hideshow 2 child comments replies: [–] theherk@lemmy.world 8 points 1 year ago (1 child) 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. permalink fedilink source parent hideshow 1 child comment replies: [–] ohshit604@sh.itjust.works 2 points 1 year 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! permalink fedilink source parent [–] forgeddit@sopuli.xyz 9 points 1 year 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. permalink fedilink source parent [–] lepinkainen@lemmy.world 10 points 1 year ago It’s like having your password set to “password” permalink fedilink source parent
[–] crookfingerjake@lemmy.world 35 points 1 year ago (3 children) The type of database they are using is called "postgres", which is also it's password. permalink fedilink source parent hideshow 3 child comments replies: [–] SocialMediaRefugee@lemmy.world 5 points 1 year ago (1 child) They should've used "1234" permalink fedilink source parent hideshow 1 child comment replies: [–] faythofdragons@slrpnk.net 7 points 1 year ago That's the combo on my luggage! permalink fedilink source parent [–] joyjoy@lemmy.zip 2 points 1 year ago I will assume this is just the password they use in development. But they should probably be using pglite. permalink fedilink source parent
[–] SocialMediaRefugee@lemmy.world 5 points 1 year ago (1 child) They should've used "1234" permalink fedilink source parent hideshow 1 child comment replies: [–] faythofdragons@slrpnk.net 7 points 1 year ago That's the combo on my luggage! permalink fedilink source parent
[–] faythofdragons@slrpnk.net 7 points 1 year ago That's the combo on my luggage! permalink fedilink source parent
[–] joyjoy@lemmy.zip 2 points 1 year ago I will assume this is just the password they use in development. But they should probably be using pglite. permalink fedilink source parent
[–] ohshit604@sh.itjust.works 15 points 1 year ago* (last edited 1 year ago) (2 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. permalink fedilink source parent hideshow 2 child comments replies: [–] theherk@lemmy.world 8 points 1 year ago (1 child) 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. permalink fedilink source parent hideshow 1 child comment replies: [–] ohshit604@sh.itjust.works 2 points 1 year 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! permalink fedilink source parent
[–] theherk@lemmy.world 8 points 1 year ago (1 child) 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. permalink fedilink source parent hideshow 1 child comment replies: [–] ohshit604@sh.itjust.works 2 points 1 year 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! permalink fedilink source parent
[–] ohshit604@sh.itjust.works 2 points 1 year 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! permalink fedilink source parent
[–] forgeddit@sopuli.xyz 9 points 1 year 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. permalink fedilink source parent
[–] lepinkainen@lemmy.world 10 points 1 year ago It’s like having your password set to “password” permalink fedilink source parent
[–] Nobilmantis@feddit.it 10 points 1 year ago (1 child) I mean it is called ".env_example" afterall... Probably a env file to use for testing, no? permalink fedilink source parent hideshow 1 child comment replies: [–] forgeddit@sopuli.xyz 13 points 1 year ago I'm really shocked by the confidence people have here with clearly zero knowledge. ".env_example" is literally just the example/template which is only updated if new "config" items are needed and it doesn't contain actual secrets. Developers copy ".env"/prod and ".env_local" files, which are used for the specific environments. These are in .gitignore so that they're not accidentally pushed to .git. For production the ".env" is generated during deployment from secrets in a locked up environment. (I mean they COULD fuck this up, but there's no evidence of this AFAIK) The example postgres password is simply a "hello world" type password that is often used when running a local docker image of the DB so you can get a full dev environment running in a couple minutes, as mentioned in the readme.md: https://github.com/gsa-tts-archived/ai-gov-api It's not even a testing environment, it's a temporary local/dev DB just so you can test your code. I am NOT defending this project, but holy shit this thread is full of misinformation and I had to correct this. permalink fedilink source parent
[–] forgeddit@sopuli.xyz 13 points 1 year ago I'm really shocked by the confidence people have here with clearly zero knowledge. ".env_example" is literally just the example/template which is only updated if new "config" items are needed and it doesn't contain actual secrets. Developers copy ".env"/prod and ".env_local" files, which are used for the specific environments. These are in .gitignore so that they're not accidentally pushed to .git. For production the ".env" is generated during deployment from secrets in a locked up environment. (I mean they COULD fuck this up, but there's no evidence of this AFAIK) The example postgres password is simply a "hello world" type password that is often used when running a local docker image of the DB so you can get a full dev environment running in a couple minutes, as mentioned in the readme.md: https://github.com/gsa-tts-archived/ai-gov-api It's not even a testing environment, it's a temporary local/dev DB just so you can test your code. I am NOT defending this project, but holy shit this thread is full of misinformation and I had to correct this. permalink fedilink source parent
[–] Jakeroxs@sh.itjust.works 8 points 1 year ago (2 children) Is this real lmao permalink fedilink source parent hideshow 2 child comments replies: [–] ArtVandelay@lemmy.world 10 points 1 year ago (1 child) Unfortunately no, it seems. Somebody at least had the bare minimum sense to let GitHub generate the .gitignore for them, which includes most common environment files. https://github.com/gsa-tts-archived/ai.gov/blob/main/.gitignore permalink fedilink source parent hideshow 1 child comment replies: [–] forgeddit@sopuli.xyz 6 points 1 year ago It's from another repo and literally just an example env for an empty local docker DB: https://archive.softwareheritage.org/browse/origin/directory/?origin_url=https%3A%2F%2Fgithub.com%2Fgsa-tts-archived%2Fai-gov-api permalink fedilink source parent
[–] ArtVandelay@lemmy.world 10 points 1 year ago (1 child) Unfortunately no, it seems. Somebody at least had the bare minimum sense to let GitHub generate the .gitignore for them, which includes most common environment files. https://github.com/gsa-tts-archived/ai.gov/blob/main/.gitignore permalink fedilink source parent hideshow 1 child comment replies: [–] forgeddit@sopuli.xyz 6 points 1 year ago It's from another repo and literally just an example env for an empty local docker DB: https://archive.softwareheritage.org/browse/origin/directory/?origin_url=https%3A%2F%2Fgithub.com%2Fgsa-tts-archived%2Fai-gov-api permalink fedilink source parent
[–] forgeddit@sopuli.xyz 6 points 1 year ago It's from another repo and literally just an example env for an empty local docker DB: https://archive.softwareheritage.org/browse/origin/directory/?origin_url=https%3A%2F%2Fgithub.com%2Fgsa-tts-archived%2Fai-gov-api permalink fedilink source parent