Hey #Montreal, did you know Postgres Extensions Day is coming May 12?

Anyone working with PostgreSQL or who is interested in extension development can benefit from this event. Sign up for free, here: https://pgext.day

Questions? Get in touch with @yrashk

Do you, like me, LOVE SQL??

I'm not kidding.

Check out the SQL murder mystery!
It's a fun way to exercise your SQL skills.

https://mystery.knightlab.com/

NO SPOILERS - yes, I know who did it.

MCP: lo standard che collega modelli AI e dati in tempo reale

https://gomoot.com/mcp-lo-standard-che-collega-modelli-ai-e-dati-in-tempo-reale/

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 ? "

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/

Bless your transactions by committing them with "amen" in @mariadb

https://mariadb.org/amen-statement-for-committing-transactions/

#AprilFools
#MariaDB
#Database
#Transaction

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

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

Introducing: Prairie Postgres, a 501(c)(3) nonprofit organization chartered in Illinois, the Prairie State, serving the Midwestern United States!

We are devoted to training, professional development, and networking opportunities for technical practitioners and researchers.

For more information, check out our website: https://prairiepostgres.org

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.

Found the antichrist on myself.

Hans-Juergen Schoenig: PostgreSQL: 1 trillion rows in Citus

https://postgr.es/p/73O

Troubleshooting DB2 REORG in Compound SQL Statements: Why Does It Fail?
Troubleshooting DB2 REORG compound statements. Learn the difference between compiled and inlined compound SQL blocks in DB2 LUW to avoid errors and optimize database reorganization. Key takeaways include best practices, error handling, and performance considerations. #DB2 #REORG #SQL #Database #Troubleshooting #Performance
https://tech-champion.com/programming/troubleshooting-db2-reorg-in-compound-sql-statements-why-doe...

How to Overcome the Listagg Limit of 4000 Characters
Overcome the LISTAGG limit in SQL for large datasets! Strategies like chunking and recursive CTEs help manage massive concatenated strings. Learn practical solutions for efficient SQL queries. #SQL #LISTAGG #StringConcatenation #Database #SQLQueries #LargeDatasets
https://tech-champion.com/database/how-to-overcome-the-listagg-limit-of-4000-characters/
...

How to Find the Exact Count of Records in All Persistent Tables in a Database?
Finding accurate Total persistent table records in DB2 LUW can be tricky. Standard methods aren't always precise, especially in high-transaction environments. Learn alternative, efficient techniques to get accurate counts. #DB2LUW #SQL #Database #Performance #RecordCounts #TableCounts
https://tech-champion.com/programming/how-to-find-the-exact-count-of-records-in-all-persistent-tables-in-a-database/
...

DB2 for i Date Comparison: A Guide to Efficient Date Handling
Master DB2 for i Date Comparison! Learn efficient techniques for accurate & reliable date handling in your DB2 applications. Improve query efficiency & avoid common pitfalls. #DB2 #DateComparison #Database #SQL #Programming #iSeries
https://tech-champion.com/database/db2luw/db2-for-i-date-comparison-a-guide-to-efficient-date-handling/
...

How to Change Column Collation in MySQL
Need to change column collation in MySQL? Our guide covers updating single columns, tables, and databases for better character support. Learn SQL commands & automation tips! #MySQL #Collation #Database #SQL #CharacterSet #UTF8MB4
https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/
...

Find the Oldest Even-Numbered Patient Visit Using SQL
Learn to extract the Oldest Even Visit SQL record! This tutorial covers various SQL techniques, including CTEs and subqueries, to efficiently retrieve this data. Optimize your queries for speed and handle missing data. #SQLqueries #DataAnalysis #Database #OldestRecord #EvenVisit #Coding
https://tech-champion.com/database/sql-server/find-the-oldest-even-numbered-patient-visit-using-sql/
...