mastodon.ie

Evan LightToday, I am grateful to find that <a href="https://tenforward.social/tags/heroku" class="mention hashtag" rel="nofollow noopener" target="_blank">#heroku</a> <a href="https://tenforward.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> has pgvector support. I'm going to be using the hell out of it soon. <a href="https://tenforward.social/tags/chrysalis" class="mention hashtag" rel="nofollow noopener" target="_blank">#chrysalis</a>

vascorsdHow we discovered, and recovered from, Postgres corruption on the matrix.org homeserver | Lobsters<a href="https://lobste.rs/s/x6qsw2/how_we_discovered_recovered_from" rel="nofollow noopener" translate="no" target="_blank">https://lobste.rs/s/x6qsw2/how_we_discovered_recovered_from</a><a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://mastodon.social/tags/matrix" class="mention hashtag" rel="nofollow noopener" target="_blank">#matrix</a>

Code of Amor 💘Perhaps next I could give a statistical analysis based on usage per toot? <a href="https://social.codeofamor.net/tags/swearing" class="mention hashtag" rel="nofollow noopener" target="_blank">#swearing</a> <a href="https://social.codeofamor.net/tags/fbombs" class="mention hashtag" rel="nofollow noopener" target="_blank">#fbombs</a> <a href="https://social.codeofamor.net/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a> <a href="https://social.codeofamor.net/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://social.codeofamor.net/tags/mastodon" class="mention hashtag" rel="nofollow noopener" target="_blank">#mastodon</a> <a href="https://social.codeofamor.net/tags/starwars" class="mention hashtag" rel="nofollow noopener" target="_blank">#starwars</a>

Jens W. KleinSo, es ist soweit, ich suche einen Managed <a href="https://nerdculture.de/tags/Kubernetes" class="mention hashtag" rel="nofollow noopener" target="_blank">#Kubernetes</a> Anbieter in <a href="https://nerdculture.de/tags/%C3%96sterreich" class="mention hashtag" rel="nofollow noopener" target="_blank">#Österreich</a> oder sonst wo in der <a href="https://nerdculture.de/tags/EU" class="mention hashtag" rel="nofollow noopener" target="_blank">#EU</a>. Google hab ich schon bedient, aber wenn jemand persönlich gute Erfahrung mit einem Anbieter hat, würde mir das weiterhelfen. Managed <a href="https://nerdculture.de/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#Postgres</a> und <a href="https://nerdculture.de/tags/Kafka" class="mention hashtag" rel="nofollow noopener" target="_blank">#Kafka</a> dabei gibt Pluspunkte ;) Gerne Retoot.

Claire Giordano ✨New blog post 📒 Bits of engineering wisdom from a year of the <a href="https://hachyderm.io/tags/TalkingPostgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#TalkingPostgres</a> <a href="https://hachyderm.io/tags/podcast" class="mention hashtag" rel="nofollow noopener" target="_blank">#podcast</a> 🎙️ featuring highlights from 13 episodes in the past year with amazing <a href="https://hachyderm.io/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> guests including: Tom Lane, Bruce Momjian, Daniel Gustafsson, David Rowley, Melanie Plageman, Robert Haas, Affan Dar, Andrew Atkinson, <a href="https://mastodon.online/@BajoranEngineer" class="u-url mention" rel="nofollow noopener" target="_blank">@BajoranEngineer</a>, Peter Cooper, Peter Farkas, Pino de Candia, & Shireesh ThotaHope y'all enjoy it! And big +1 🙏 to <a href="https://mastodon.social/@asw" class="u-url mention" rel="nofollow noopener" target="_blank">@asw</a> for co-producing this monthly pod with me <a href="https://techcommunity.microsoft.com/blog/adforpostgresql/bits-of-wisdom-from-a-year-of-talking-postgres/4434622" rel="nofollow noopener" translate="no" target="_blank">https://techcommunity.microsoft.com/blog/adforpostgresql/bits-of-wisdom-from-a-year-of-talking-postgres/4434622</a><a href="https://hachyderm.io/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#Postgres</a> <a href="https://hachyderm.io/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#databases</a> <a href="https://hachyderm.io/tags/community" class="mention hashtag" rel="nofollow noopener" target="_blank">#community</a> <a href="https://hachyderm.io/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#opensource</a> <a href="https://hachyderm.io/tags/Microsoft" class="mention hashtag" rel="nofollow noopener" target="_blank">#Microsoft</a> <a href="https://hachyderm.io/tags/developers" class="mention hashtag" rel="nofollow noopener" target="_blank">#developers</a>

Data BeneNous sommes convaincus que les entreprises du monde entier peuvent bénéficier du projet open source <a href="https://fosstodon.org/tags/IvorySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#IvorySQL</a> pour une transition fluide d'Oracle vers <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a>. Profitez de la puissance de la gestion des données open source avec l'assistance, les options consultatives, et la formation de Data Bene ; nous sommes là pour vous aider avec des décennies d'expérience dans Postgres et une participation active au projet <a href="https://fosstodon.org/tags/IvorySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#IvorySQL</a>. 🐘 <a href="https://fosstodon.org/tags/technologie" class="mention hashtag" rel="nofollow noopener" target="_blank">#technologie</a> <a href="https://fosstodon.org/tags/foss" class="mention hashtag" rel="nofollow noopener" target="_blank">#foss</a> <a href="https://fosstodon.org/tags/oss" class="mention hashtag" rel="nofollow noopener" target="_blank">#oss</a> <a href="https://fosstodon.org/tags/donnees" class="mention hashtag" rel="nofollow noopener" target="_blank">#donnees</a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/oracle" class="mention hashtag" rel="nofollow noopener" target="_blank">#oracle</a>

Stefanie Janine StöltingThe <a href="https://digitalcourage.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> 18 beta2 <a href="https://digitalcourage.social/tags/Docker" class="mention hashtag" rel="nofollow noopener" target="_blank">#Docker</a> container are available. If you haven't started testing against <a href="https://digitalcourage.social/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#Postgres</a> 18, now is your chance. <a href="https://hub.docker.com/_/postgres/" rel="nofollow noopener" translate="no" target="_blank">https://hub.docker.com/_/postgres/</a>

Hacker News 50We made Postgres writes faster, but it broke replicationLink: <a href="https://www.paradedb.com/blog/lsm_trees_in_postgres" rel="nofollow noopener" translate="no" target="_blank">https://www.paradedb.com/blog/lsm_trees_in_postgres</a> Discussion: <a href="https://news.ycombinator.com/item?id=44633933" rel="nofollow noopener" translate="no" target="_blank">https://news.ycombinator.com/item?id=44633933</a><a href="https://social.lansky.name/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a>

Matej CernyAWS has open-sourced pgactive, an extension enabling multi-region, active-active replication for PostgreSQL. If you are familiar with DynamoDB global tables, it uses the same approach - eventual consistency via "last-write-wins" conflict resolution. <a href="https://witter.cz/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://witter.cz/tags/dynamodb" class="mention hashtag" rel="nofollow noopener" target="_blank">#dynamodb</a> <a href="https://aws.amazon.com/about-aws/whats-new/2025/06/open-sourcing-pgactive-active-active-replication-extension-postgresql/" rel="nofollow noopener" translate="no" target="_blank">https://aws.amazon.com/about-aws/whats-new/2025/06/open-sourcing-pgactive-active-active-replication-extension-postgresql/</a>

Hacker News 50AWS open-sourced Postgres active-active replication extensionLink: <a href="https://github.com/aws/pgactive" rel="nofollow noopener" translate="no" target="_blank">https://github.com/aws/pgactive</a> Discussion: <a href="https://news.ycombinator.com/item?id=44580257" rel="nofollow noopener" translate="no" target="_blank">https://news.ycombinator.com/item?id=44580257</a><a href="https://social.lansky.name/tags/aws" class="mention hashtag" rel="nofollow noopener" target="_blank">#aws</a> <a href="https://social.lansky.name/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a>

altoHow are people here running <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> in <a href="https://fosstodon.org/tags/highavailability" class="mention hashtag" rel="nofollow noopener" target="_blank">#highavailability</a> mode when <a href="https://fosstodon.org/tags/selfhosting" class="mention hashtag" rel="nofollow noopener" target="_blank">#selfhosting</a>?

{:ok, "Joel Jucá"}I've used <a href="https://functional.cafe/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> before (last time was 2016, I think), but today I'm mostly onto <a href="https://functional.cafe/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#Postgres</a> (and sometimes, <a href="https://functional.cafe/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>). I know PG is superior to MySQL is pretty much all aspect I could think of, but still, it seems that MySQL still has a quite big user base.What's the catch? What am I missing here? Why would someone use MySQL over Postgres to build smt since Postgres [apparently] is better than MySQL in every single possible aspect?It's a honest question. Please help me understand it – and perhaps, consider modern MySQL/MariaDB in next projects. :)

Hacker News 50When Sigterm Does Nothing: A Postgres MysteryLink: <a href="https://clickhouse.com/blog/sigterm-postgres-mystery" rel="nofollow noopener" translate="no" target="_blank">https://clickhouse.com/blog/sigterm-postgres-mystery</a> Discussion: <a href="https://news.ycombinator.com/item?id=44567888" rel="nofollow noopener" translate="no" target="_blank">https://news.ycombinator.com/item?id=44567888</a><a href="https://social.lansky.name/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a>

PGConf.EUWelcome Fujitsu Enterprise Postgres as a Gold sponsor of PGConf.EU 2025 in Riga!<a href="https://2025.pgconf.eu/sponsors/" rel="nofollow noopener" translate="no" target="_blank">https://2025.pgconf.eu/sponsors/</a><a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://mastodon.social/tags/pgconfeu" class="mention hashtag" rel="nofollow noopener" target="_blank">#pgconfeu</a> <a href="https://mastodon.social/tags/riga" class="mention hashtag" rel="nofollow noopener" target="_blank">#riga</a> <a href="https://mastodon.social/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#opensource</a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a>

Clovis :bdx_town:Je suis content, après des débuts difficiles en gestion de perf j'ai vraiment l'impression qu'on a atteint quelque chose de satisfaisant ici, avec des ressources plus que limitées Je vais faire un article de blog sur le sujet mais je pense que c'est principalement du à la désactivation du nettoyage (vaccum) auto de la base postgres: La suppression d'une entrée dans une base postgres n'entraîne pas la supppression réelle de la donnée sur le disque. Ce processus n'est effectuée qu'après X suppressions de données. Le soucis c'est qu'il est très coûteux et la façon dont est codé Pleroma/Akkoma produit bcp de suppressions donc bcp de vaccum. La base est donc continuellement busy à cause de ce processus, empêchant de répondre correctement aux requêtes des utilisateurs. Ce que j'ai fait ici c'est de complètement désactiver ce processus, qui tourne maintenant une seule et unique fois chaque nuit, quand le serveur est down pour sauvegarde. Je pense que j'aurai pu tweak les paramètres pour juste faire moins d'auto vacuum mais on aurait quand même eu le soucis assez régulièrement de requêtes qui prennent des plombes à cause de ça Je pense qu'en l'état c'est un système satisfaisant ! <a class="hashtag" href="https://bdx.town/tag/postgres" rel="nofollow noopener" target="_blank">#postgres</a> <a class="hashtag" href="https://bdx.town/tag/akkoma" rel="nofollow noopener" target="_blank">#akkoma</a>

YogthosInstall and run a PostgreSQL database locally on Linux, MacOS or Windows. PostgreSQL can be bundled with your application, or downloaded on demand.This library provides an embedded-like experience for PostgreSQL similar to what you would have with SQLite.<a href="https://github.com/theseus-rs/postgresql-embedded" rel="nofollow noopener" translate="no" target="_blank">https://github.com/theseus-rs/postgresql-embedded</a><a href="https://social.marxist.network/tags/technology" class="mention hashtag" rel="nofollow noopener" target="_blank">#technology</a> <a href="https://social.marxist.network/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#programming</a> <a href="https://social.marxist.network/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a>

Crazy-to-Bike<a href="https://mastodon.social/@alexantemachina" class="u-url mention" rel="nofollow noopener" target="_blank">@alexantemachina@mastodon.social</a> Warum meinst du? Datenbanken nehmen ja durch eine volle Platte nicht Schaden, im Sinne bereits gespeichertes ist auf einmal weg, sondern, dass neue Daten nicht oder nur korrupt gespeichert werden. Grundsätzlich verstehe ich auch nicht, warum bei <a href="https://fediworld.de/tags/HomeAssistant" rel="nofollow noopener" target="_blank">#HomeAssistant</a> als Standard auf <a href="https://fediworld.de/tags/SQlite" rel="nofollow noopener" target="_blank">#SQlite</a> gesetzt wird. Egal welches System mit Datenbank ich bisher installiert habe, wurde entweder direkt auf <a href="https://fediworld.de/tags/mySQL" rel="nofollow noopener" target="_blank">#mySQL</a>, <a href="https://fediworld.de/tags/MariaDB" rel="nofollow noopener" target="_blank">#MariaDB</a> oder <a href="https://fediworld.de/tags/Postgres" rel="nofollow noopener" target="_blank">#Postgres</a> gesetzt, oder zumindest empfohlen, nicht SQlite zu nehmen.

Johan ForsellWho said data engineering was uninteresting!? (Me, I’ve probably said that 🫣)You can consider me a converted man though, SQL is my new jam.<a href="https://iosdev.space/tags/datablessed" class="mention hashtag" rel="nofollow noopener" target="_blank">#datablessed</a> <a href="https://iosdev.space/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a> <a href="https://iosdev.space/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://iosdev.space/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a>

BLACKVOID ⚫️@jhx almost 90 across 5 docker hosts. <a href="https://mastodon.social/tags/ghost" class="mention hashtag" rel="nofollow noopener" target="_blank">#ghost</a> <a href="https://mastodon.social/tags/plex" class="mention hashtag" rel="nofollow noopener" target="_blank">#plex</a> <a href="https://mastodon.social/tags/vaultwarden" class="mention hashtag" rel="nofollow noopener" target="_blank">#vaultwarden</a>, <a href="https://mastodon.social/tags/mattermost" class="mention hashtag" rel="nofollow noopener" target="_blank">#mattermost</a> <a href="https://mastodon.social/tags/freshrss" class="mention hashtag" rel="nofollow noopener" target="_blank">#freshrss</a> <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://mastodon.social/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a> <a href="https://mastodon.social/tags/shellngn" class="mention hashtag" rel="nofollow noopener" target="_blank">#shellngn</a> <a href="https://mastodon.social/tags/midnightcommander" class="mention hashtag" rel="nofollow noopener" target="_blank">#midnightcommander</a> <a href="https://mastodon.social/tags/sonarr" class="mention hashtag" rel="nofollow noopener" target="_blank">#sonarr</a> <a href="https://mastodon.social/tags/radarr" class="mention hashtag" rel="nofollow noopener" target="_blank">#radarr</a> <a href="https://mastodon.social/tags/grafana" class="mention hashtag" rel="nofollow noopener" target="_blank">#grafana</a> <a href="https://mastodon.social/tags/influx" class="mention hashtag" rel="nofollow noopener" target="_blank">#influx</a> <a href="https://mastodon.social/tags/nginx" class="mention hashtag" rel="nofollow noopener" target="_blank">#nginx</a> <a href="https://mastodon.social/tags/npm" class="mention hashtag" rel="nofollow noopener" target="_blank">#npm</a> <a href="https://mastodon.social/tags/adguard" class="mention hashtag" rel="nofollow noopener" target="_blank">#adguard</a> to name a few

Scott Williams 🐧*Takes a deep breath*<a href="https://mastodon.online/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#MariaDB</a> might be the best general database engine ever and it sucks that the for-profit company using the name kept stepping on rusty rakes over and over again so that people in suits who can't distinguish the corp from the foundation pushed for other platforms.Side note: <a href="https://mastodon.online/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a>, I want to love you, but I have so many similar feelings about you as I do about coding in rust. You're too pedantic for your own good.<a href="https://mastodon.online/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://mastodon.online/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a> <a href="https://mastodon.online/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a>

Recent searches

Search options

Administered by:

Server stats:

#postgres