mastouille.fr est l'un des nombreux serveurs Mastodon indépendants que vous pouvez utiliser pour participer au fédiverse.
Mastouille est une instance Mastodon durable, ouverte, et hébergée en France.

Administré par :

Statistiques du serveur :

639
comptes actifs

#PostgreSQL

12 messages9 participants0 message aujourd’hui
A répondu dans un fil de discussion

@carloshr @tecnologia

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:

blog.prosody.im/great-invitati

No tengo experiencia con otros servidores, como #Tigase por @tigase u #Openfire por @news.

blog.prosody.im · Great Invitations
Plus via Prosody IM

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.

🛢️ #ChartDB: редактор діаграм баз даних з відкритим вихідним кодом.

Інструмент дозволяє швидко створювати діаграми і таблиці з вашої БД. Один запит - і ви отримуєте схему бази даних у форматі JSON.

Підтримує #PostgreSQL, #MySQL, #SQLServer, #MariaDB, #SQLite та інші.
#database
🔗GitHub github.com/chartdb/chartdb?tab
🔗Сайт 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: hubs.la/Q03qbnT70

Join us on Tuesday at 11am ET here: hubs.la/Q03qbltY0

hubs.laTech TuesdaysTune in every Tuesday to join our Postgres experts and distributed Postgres solution architects

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.

github.com/wey-gu/py-pglite

PGlite wrapper in Python for testing. Test your app with Postgres just as lite as SQLite. - wey-gu/py-pglite
GitHubGitHub - wey-gu/py-pglite: PGlite wrapper in Python for testing. Test your app with Postgres just as lite as SQLite.PGlite wrapper in Python for testing. Test your app with Postgres just as lite as SQLite. - wey-gu/py-pglite

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:

blog.thms.uk/2025/06/upgrade-p

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.

blog.thms.ukUpgrading Mastodon from PostgreSQL 15 to PostgreSQL 17 - blog.thms.ukUpgrading Mastodon’s database from PostgreSQL 15 to 17 on Ubuntu 24.04 is fast and easy using `pg_upgradecluster` with link mode. Here’s a quick guide with steps, tips, and cleanup.

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.

mirrors.dotsrc.org/fosdem/2025

#devcommunity#foss#oss