#postgresql

👋 Hi, Mastodon! This is SQLtest.online, a free SQL trainer that runs in your browser. • 480+ practice tasks with instant automatic checks • Real database engines: PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, Firebird, DuckDB • A step-by-step SQL course, a skills test and an interview simulator • No install, no paywall, open source Here we'll share new lessons, tasks and SQL tips. Questions welcome! https://sqltest.online #SQL #LearnSQL #PostgreSQL #MySQL #Database #Introduction

A critical PostgreSQL RCE vulnerability allows remote code execution. Details and PoC for this PostgreSQL RCE vulnerability are now public. Update now. #PostgreSQL #CVE202615742 #RCE #Cybersecurity #DatabaseSecurity

Always impressed by what PostgreSQL has built right into the core. 🐘 Needed an automatic checksum on rows and was already reaching for a trigger until I remembered / rediscovered 𝗚𝗲𝗻𝗲𝗿𝗮𝘁𝗲𝗱 𝗖𝗼𝗹𝘂𝗺𝗻𝘀. Clean, declarative, and zero trigger boilerplate needed: https://www.postgresql.org/docs/current/ddl-generated-columns.html #PostgreSQL

RE: https://mastodon.au/@xrobau/117300844625946496 Edit: We have figured it out, and are manually importing to a new temp table. --- Any #PostgreSQL exports around to help me out here? After a storage server crash, I've ended up with (at least one) table having corrupt time data in it. There is, apparently, no way to pg_dump and ignore errors, and \COPY also doesn't appear to continue-on-error. What I want to do is just get a list of the IDs of the rows with the corrupt time entries so I can either fix them, or just delete them. This is the 'status_stats' table from #MastodonNZ, and has about 70m rows. My current plan is that I've copied the schema of status_stats to status_stats_new, changing the time rows to just 'text' and I'm doing 'insert into status_stats_new select * from status_stats ON CONFLICT DO NOTHING;' then a left join to find missing ones. IS THERE A BETTER WAY? Halp!

Sorry #MastodonNZ but there is a good chance I'm going to have to do a complete database dump and restore, as there's still some bits of corruption left over from the crash the other day. This is probably an hour or so outage. I'm actually not even totally sure that #PostgreSQL will even restart properly when I shut it down. More information will be in this thread (so you can look at it on #MastodonAU directly via the web interface.)

Blockchain.com is hiring Technical Lead, Lending & Savings 🔧 #java #kotlin #kafka #nosql #postgresql #redis #techlead 🌎 London, United Kingdom ⏰ Full-time 🏢 Blockchain.com Job details https://jobsfordevelopers.com/jobs/technical-lead-lending-savings-at-blockchain-com-aug-3-2026-c6047e?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting #jobalert #jobsearch #hiring

as promised - the weekly update on parley's development status! https://river-studio.net/posts/choosing-db-for-parley/ #python #postgresql #rust #rustlang #parley #foss

The Miraak framework hides its C2 inside a cloud PostgreSQL database, using DB tables as a command queue to control infected Windows machines covertly. #Miraak #PostgreSQL #C2 #PostExploitation #BlackpointCyber

Starting a startup today.

Which database are you choosing?

• PostgreSQL
• MongoDB
• Firebase / Firestore
• Neon

#PostgreSQL #MongoDB #Startups

Contentful is hiring Engineering Manager - Content API (f/m/d) 🔧 #api #javascript #typescript #react #node #graphql #rest #postgresql #engineeringmanager 🌎 London, United Kingdom ⏰ Full-time 🏢 Contentful Job details https://jobsfordevelopers.com/jobs/engineering-manager-content-api-f-m-d-at-contentful-com-jul-20-2026-8556ba?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting #jobalert #jobsearch #hiring

Hello techhub.social! 👋 Time for an official #Introduction. I'm Truediff, a data and #Linux enthusiast who strongly believes in #DigitalSovereignty and #opensource Here is the real picture: -> Day Job: Business Analyst for payment ops and core banking. Just making complex financial systems play nicely together. -> The Tech: Not a dev, but a tinkerer. I rely on trial-and-error, tutorials, and AI-assisted (not AI-dependent) learning to build my setups. -> The Passion: #MMORPGs and RPGs. Gaming is the lens for my tech projects. -> The Projects: My #Python ETL pipelines, #PostgreSQL databases, and #SelfHosted infra all exist to build analytics for the game economies I love. Follow along if game data, open-source tinkering, and tech rabbit holes are your thing!

Alter Verwalter, dass PostreSQL die Datenbank migrationen nur einem Kern von 8 laufen lässt, lässt den Spaß dann halt 15 Minuten dauern. #Akkoma #PostgreSQL

Sorry about that long-ish outage, but we were YET AGAIN getting smashed by AI bots. I have given up fighting them, and I'm just scaling up until #mastodonAU can handle the load. This time the #PostgreSQL database was running at a load of 100+ because it was disk IO bound. I did *try* to live migrate it, but it was just insanely slow so I made the call to shut it down (hence the 'Something went wrong' errors) and move it offline. It's moved. Now it's running on a pure SSD-only backing store, which hopefully will handle everything the #AI scrapers throw at us. I'll be doing the same thing with #MastodonNZ too, shortly (but hopefully without the outage, as that's a much more lightweight instance) I also really need to fix the status page that comes up when mau is down.

Aircall is hiring Front End / Fullstack Engineer - Messaging Team 🔧 #ruby #typescript #react #node #api #graphql #aws #cicd #postgresql 🌎 Madrid, Spain ⏰ Full-time 🏢 Aircall Job details https://jobsfordevelopers.com/jobs/front-end-fullstack-engineer-messaging-team-at-aircall-io-may-26-2026-30b321?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting #jobalert #jobsearch #hiring

A PHP SQL injection flaw, CVE-2026-17543, was patched alongside two memory bugs. Update to PHP 8.2.33, 8.3.33, 8.4.24, or 8.5.9 now. #PHP #SQLInjection #CVE202617543 #PostgreSQL #Vulnerability #InfoSec

Database Workbench 7.0.5 released ✅ #AI Assistant improvements ✅ Improved XML data export ✅ Much faster ODS and XLS data import ✅ Improved Welcome Window Read more ➡️ https://www.upscene.com/news/item/20260722 #Firebird #MySQL #MariaDB #Oracle #PostgreSQL #SQLServer #InterBase #SQLite #NexusDB #databasedevelopment #DatabaseWorkbench #AIDevelopment

Upgraded the Mastodon backend postgresql server from 14 to 18 with pgautoupgrade. Found out that I had some uniqueness violations (possibly due to collation changes) that needed some manual DB operations to merge accounts and remove duplicate entries before I could run tootctl maintenance fix-duplicates. Then used pg_repack to remove bloat and finally used REINDEX to fix the last bits.

Everything's fresh and smooth again!

#MastoAdmins #PgAutoUpgrade #PgRepack #postgresql #postgres

"Using #AI to Update Audit Triggers After Schema Changes" Generating an audit trigger is only the beginning. As a database evolves, tables change, new columns are added, and existing audit triggers need to evolve with them. This is another area where AI can save developers valuable time. https://www.upscene.com/articles/article/8/ai-to-update-triggers-after-database-schema-changes #databasedevelopment #DatabaseWorkbench #sql #AIDevelopment #sqlite #sqlserver #PostgreSQL #FirebirdSQL #mysql #MariaDB #sqlserver #oracle #InterBase

PostgreSQL MVCC: tradeoffs compared to other engines https://boringsql.com/posts/mvcc-bad-bad/ #Databases #PostgreSQL #Tech

It has been a while since I wrote a proper long guide about something I actually love doing. In September 2025 I wrote up how to run Mastodon on Kubernetes. That blog is gone, the guide survives only in the Web Archive. A text about backups that exists as somebody else's copy. At least it stayed on topic. So I rewrote all of it against Mastodon 4.6. The part I got wrong the first time was the most important one: Postgres as a Deployment with a PVC next to it. Kubernetes sends SIGTERM, Postgres reads that as a smart shutdown and waits for every client to disconnect. Sidekiq never does. Thirty seconds later, SIGKILL and a crash recovery. CloudNativePG and continuous WAL archiving now, RPO down from 24 hours to minutes. Still no Helm, everything by hand, because I want to understand what runs. My own instance came off Kubernetes in March, purely on cost. This is the config as it last ran. https://www.dol.ch/en/blog/mastodon-4-6-kubernetes?=s1 #Kubernetes #PostgreSQL #CloudNativePG #SelfHosting #DevOps #Mastodon #Blog #Fediverse