2830
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
Hacking Moltbook: AI Social Network Reveals 1.5M API Keys | Wiz Blog
https://www.wiz.io/blog/exposed-moltbook-database-reveals-millions-of-api-keys
Need support on converting stored procedures from plsql to postgress sql in redshift anyone providing please ping me it's urgent
Читать полностью…
I do wonder why it locked up as it seemed to be on the sending side, but by that time I was out of time and just needed to fix it.
Читать полностью…
I run postgresql on bare metal and it's wonderful, as I said multiple times the packaging of postgresql is stellar and pretty much already "containerized"
Читать полностью…
Yeah, database and image/file handling and general configuration... fixing the server at 3am when logical replication locks up and WAL eats the disk...
Читать полностью…
I mean, the bigger the team the more need there is for a specialist. At the same time I get the impression mid sized companies might use cloud services rather than add headcount, so more DBAAS than handling all aspects of it directly. Don't know that for sure, though.
Читать полностью…
yeah, docker is definitely one of the best things ever made... but working with the OS directly isn't something "outdated". One should choose the best method that works for them
Читать полностью…
They provide docker image of SQL server. Does someone install DBMS on host os in 21th century? Did u try docker?
Читать полностью…
Ms sql? It is cool DBMS for big serious production because there are a lot of stable cool serious instruments
Читать полностью…
First suggestion: get rid of the "sql means SQL Server" mindset.
Second: SQL will be around for a long time. But people will not be willing to pay tons of money for it. Which essentialy means they will end up using PostgreSQL...
Third: yeah, acquiring PostgreSQL knowledge will benefit you
I am an sql dba with 6+ years of experience. Does learning postgresql dba will give more weight to my resume.? Or any other suggestions..?
Читать полностью…
"We identified a misconfigured Supabase database belonging to Moltbook, allowing full read and write access to all platform data. The exposure included 1.5 million API authentication tokens, 35,000 email addresses, and private messages between agents"
Читать полностью…
Did you check out the chapter in the official docs?
Читать полностью…
"I was modelled in Access – but I was made in psql." ⚓
Читать полностью…
Everything’s just fine. I Regret it because PostgreSQL can solve the same—or even more complex—problems with free license, + better quality. My clients just don’t trust FOSS quality, so yeah, that’s it.
For domains I can control, I deploy PostgreSQL fully. We mirror entire SQL Server data to PostgreSQL via SymmetricDS.
Even M$ uses PG as CGPT backend. If they were truly confident SQLSrv is that good, why don’t they use their "own product"?
I am glad the bug I filed in 2019 requesting less JIT got fixed too!
Читать полностью…
On the plus side it got us migrated to Debian Trixie and PG 18!
Читать полностью…
Yeah, I see the same thing in the market. Not so surprising, for exmaple the amount of changes made to db is less, compared to something like the frontend. But most of the roles are database + something (backend, devops, ...)
Читать полностью…
btw, since the topic of dba jobs came up...
what are some roles that focus mostly on the database?
what I see is either teams looking for backend developers who do database stuff (mostly via ORMs) or enterprises looking for experienced DBAs (and oracle is a common thing)
is there anything in between?
For example u can setup DBMS in 1 click. Also u can just delete the docker container and setup DBMS again in 1 click. Also u can setup another DBMS instance in 1 click (for unsafe tests for example)
Читать полностью…
Jokes aside, what caused the most pain? I know some features like filetables are not supported, but "regular" things work fine 🤔
Читать полностью…
buying sql server license is my biggest regret in my life.
i feel very stupid.
we can use .env for our anon key and project url to save the keys import from that
Читать полностью…