We've posted a video of Jonathan Katz's talk Vector search is now boring, but PostgreSQL has ways to go https://youtu.be/frG8L7GDcLc #postgresql #PGConfdev
#OutboxKit now supports #PostgreSQL and #MongoDB, in addition to the originally supported #MySQL.
https://outboxkit.yakshavefx.dev
#DotNet #CSharp #OutboxPattern
Tengo instalaciones de #ejabberd por @ejabberd y #prosody por @prosodyim. Ambos facil de instalar (paquetes de #Debian) y mantener, con muy poco mantenimiento.
La configuración de ejabberd (YAML) me gusta mas que prosody (Lua). Uso ejabberd con #PostgreSQL, prosody con "file storage".
Prosody ya tiene invitaciones, que me parece buenisimo:
https://blog.prosody.im/great-invitations/
No tengo experiencia con otros servidores, como #Tigase por @tigase u #Openfire por @news.
And why does `substr()` in #PostgreSQL treat `1` as the first character, instead of `0`, LIKE EVERYTHING ELSE?!
Using #gotosocial + #postgresql for a small instance (25 to 50 users) on a small server (intel N2800/4Gb/SSD). A good idea? Any feedbacks?
Message de service : notre instance #mobilizon est en maintenance depuis 3 jours.
Contexte : suite à la dernière mise à jour mineure, on a découvert que la version minimum de #PostgreSQL est passée de 11 à 13. On doit donc mettre à jour notre cluster PGSQL pour régler le problème.
La communauté tech de #Lille est vibrante ! Aujourd'hui et demain au #DevLille, les organisateurices des nombreux groupes bénévoles se tiennent au stand communautaire. Appréciez notre petit Slonik exposé lors de la Keynote de ce matin
#postgresql
@devoxxpl 2025 is now!
Let's meet Thursday for a 2 talks, one about #PostgreSQL and another about #Kubernetes
* https://link.davinkevin.fr/amazing-pg-devoxxpl25-program
* https://link.davinkevin.fr/GwAPI-devoxxpl25-program
The program is live! We'll highlight all the separate sessions in detail over the next few weeks, but here's the schedule for our September conference: https://www.postgresql.eu/events/pgdaynl2025/schedule/ #PostgreSQL
@RichiH Does this grow #PostgreSQL databases? ;-)
The #Docker container for #PostgreSQL 18 beta 1 is available.
That's a good time to start with tests.
https://hub.docker.com/_/postgres/
We've posted a video of Sam Willis's talk Compiling Postgres to WASM with PGlite (PGConf.dev 2025) https://youtu.be/hlWWG5WZHOA
#postgresql #PGConfdev
#ChartDB: редактор діаграм баз даних з відкритим вихідним кодом.
Інструмент дозволяє швидко створювати діаграми і таблиці з вашої БД. Один запит - і ви отримуєте схему бази даних у форматі JSON.
Підтримує #PostgreSQL, #MySQL, #SQLServer, #MariaDB, #SQLite та інші.
#database GitHub https://github.com/chartdb/chartdb?tab=readme-ov-file
Сайт https://chartdb.io/
Every Tuesday at 11:00am ET, join the pgEdge team for #TechTuesday — all about mastering Distributed #PostgreSQL high availability, and edge-ready database solutions. Whether you’re scaling apps or seeking zero downtime, these sessions are packed with hands-on insights, real-world demos, and live Q&A with the experts.
Don’t miss out! Learn more here: https://hubs.la/Q03qbnT70
Join us on Tuesday at 11am ET here: https://hubs.la/Q03qbltY0
Test Postgres in Python Like SQLite : A #Python testing library that provides seamless integration between PGlite and Python test suites. Get the full power of PostgreSQL in your tests without the overhead of a full PostgreSQL installation.
Yesterday I upgraded my Mastodon instance to go from PostgreSQL 15 PostgreSQL 17. The whole process was so simple that it almost seems silly to blog about it, but I did it anyway, in case anyone is interested:
https://blog.thms.uk/2025/06/upgrade-postgres-15-17-mastodon?utm_source=mastodon
Special thanks to @ruud who told me about link mode in pg_upgradecluster
which was the missing piece I needed in oder to get the upgrade done with my limited disk space.
A great way to spend an afternoon is watching past #tech talks at conferences... no?
Well, if it's interesting enough to you, maybe take a look at "Stats roll, baby, stats roll" from Cédric Villemain, presented at #FOSDEM2025. Here, he discusses using the PACS (#PostgreSQL Advanced Cumulative Statistics) extension to explore what is offered by #Postgres as well as how to define your own new kind of statistics.
https://mirrors.dotsrc.org/fosdem/2025/ua2220/fosdem-2025-4496-stats-roll-baby-stats-roll-.mp4