Welcome Nexteam as a Benefactor sponsor of PGDay UK 2025 in London!

https://2025.pgday.uk/sponsors/

Welcome pgMustard as a Supporter sponsor of PGDay UK 2025 in London!

https://2025.pgday.uk/sponsors/

Today it seems clear to me that the biggest impact on improving #health - even in the rich, allegedly ‘developed’ nations - would come from providing #food #security and access to stable #housing. https://tzovar.as/sunsetting-opensnp/ #genetic #database

Some time ago I mentioned here, in half-joking way, self-fixing software I work with. I said Patroni #Postgres has the best regeneration ability I've ever seen. And currently "the best ability" includes:

> After network migrations servers changed IP addresses. It broke etcd config so I had to completely delete that config and initialize etcd cluster again. Which also forced cleaning and renewing Patroni config because it is strongly dependent on etcd. Even when configuration temporarily didn't exist, connection with WAL archives (technically other separate server) wasn't interrupted (I am not even sure if real data transfer could happen at that time). It was seemingly enough to start new #database cluster from last timeline. I don't know WHAT forced servers to immediately pull that data on fresh start. At migration time there weren't any real production data so I didn't even purposely try to restore anything.

> Not so long time later (and now with real production things) some script tests, causing lots of database changes in relatively short time, beyond former server's capacity, killed master server. Patroni switched as intended and I could work on increasing server's capacity (had to do it live, not very convenient). First server finally decided data corruption was too big and to fix it automatically deleted whole /var/lib/postgresql/* directory and started to recreate thing from scratch, using data from new master server (and was doing it with at least 2 GB/s speed because why not? ).

> During above mentioned process impatient tester hit again with their not optimised scripts, finally killing whole cluster. Swearing silently I increased remaining servers as it was only thing I really could do. Postgresql API mostly wasn't responsive, it had limited info about last state before final failure. It wasn't possible to force any change or affect it in any way.
First server decided to delete whole directory again and recreate it (at least this time I saw exact moment in logs), at the same time second server did rewind to state of third server (why??). All these things happened automatically, without my help. I wouldn't even know what to do

And it's only beginning when we use it on production. Now I wait for stubborn users to do some more unintended durability tests... Maybe I would see it's even more invincible

Valkey 8.1 in-memory data store is here with boosts in performance, lower latency, enhanced observability, and more.
https://linuxiac.com/valkey-8-1-in-memory-data-store-unleashes-10-faster-throughput/

OpenVertebrate Presents a Database of 13,000 3D Scans of Specimens

https://www.openculture.com/2024/03/openvertebrate-presents-a-massive-database-of-13000-3d-scans-of-vertebrate-specimens.html

Check out Kothari Nishchay's session "PostgreSQL pgroll – Zero-Downtime, Reversible Schema Migrations" at #PostgreSQLDayBangkok to explore pgroll, a powerful tool for seamless database migrations.

Click here https://youtu.be/uB7egck68Js?si=WD2PXVrdggJw1Yhn to watch on the FOSSASIA YouTube channel

What's the best Windows or web-based #software to produce #SSADM style #database documentation these days? (free for personal use, ideally)

Boosts for reach much appreciated

Watch Michael Paquier's session "AWS and the PostgreSQL Community" at #PostgreSQLDayBangkok to explore how AWS supports the PostgreSQL ecosystem, contributes to its development, and enhances database performance in the cloud.

Click here https://youtu.be/1-ds8RtLqt0?si=dTF_ROYSNkFFCWt_ to watch on the FOSSASIA YouTube channel

INBOX: "Nous avons été sollicité hier soir par le ministère pour identifier d'urgence une liste de bases de données, critiques pour nos activités de recherche, qu'il faudrait "back-uper". Avez-vous des suggestions ? "

𝐌𝐨𝐧𝐠𝐨𝐃𝐁 𝐒𝐲𝐧𝐜 𝐂𝐨𝐧𝐧𝐞𝐜𝐭𝐨𝐫 𝐀𝐥𝐩𝐡𝐚 5 𝐢𝐬 𝐥𝐢𝐯𝐞 --> We’ve upgraded the MongoDB Connector as part of the ObjectBox Sync trial:

MongoDB Transactions support
Improved Change Tracking
Better Error Handling
Updates to MongoDB Admin Page

--> get the update from your customer folder and let us know what you think

Critical Minerals In Ores (CMiO) Database
--
https://lnkd.in/gynRjUfn <-- shared USGS publication
--
https://lnkd.in/gETca3DQ <-- shared link to open data database, web map services, etc
--
https://portal.ga.gov.au/persona/cmmi <-- shared web map
--
https://lnkd.in/gdmMp2zg <-- shared editorial piece on critical minerals and geopolitics
--
#geology #fedscience #opendata #CMMI #CMiO #criticalminerals #minerals #ores #database #opendata #GIS #spatial #mapping #spatialanalysis #commodities #technology #components #geochemistry #deposits #mining #extraction #classifaction #nomenclature #environments #structuralgeology #exploration
@USGS | @GeoscienceAustralia | @GeologicalSurveyOfCanada

#OpenSource #Genetic #Database Shuts Down to Protect Users From 'Authoritarian Governments'

"The risk/benefit calculus of providing free & open access to individual #genetic data in 2025 is very different compared to 14 years ago."
#privacy #dna

https://www.404media.co/open-source-genetic-database-opensnp-shuts-down-to-protect-users-from-authoritarian-governments/

asking for a friend: do you know any database/framework to visualize RNAseq data ? (just like https://github.com/broadinstitute/gnomad-browser for WGS)

Today I'm researching better workflows to backup databases, and create sanitised copies for local development.

I'm not able to find a great deal of informative discussion around best practice.

Is this stuff more obvious than I think - or is it so under-the-radar-unsexy that industry practice is just not very good?

Ever wondered how to compute a function across multiple parties without revealing their inputs?

This technique can be used to split secrets among parties, perform logical operations, or count votes in a way that ensures data privacy is preserved.

Read the #InfoQ article to learn more: https://bit.ly/4cx8sAV

I am a (relational) database guy and have been for decades.

When I read "feature drop" it sounds to me, as if something was removed, not added.

Oh, this is cool: https://diy-synths.snnkv.com

PostgreSQL Shared Libraries: Solving Python Extension Library Path Issues
Smoothly integrate Python extensions with PostgreSQL Shared Libraries, especially when using NumPy. Properly configuring the `shared_libraries` parameter prevents runtime errors by ensuring your database server can locate necessary libraries. Learn how to manage PostgreSQL Shared Libraries for robust Python extensions! #PostgreSQL #Python #SharedLibraries #NumPy #Database #Extensions
https://tech-champion.com/databas...