techhub.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A hub primarily for passionate technologists, but everyone is welcome

Administered by:

Server stats:

4.6K
active users

#databases

15 posts12 participants0 posts today

Database collates are ridiculous. Why would I want to *globally* configure a database's ordering rules? Either I care about presenting locale-appropriate orderings, in which case I need that to be configured PER APPLICATION USER, or I don't care, in which care just use whatever makes the most sense for performance/simplicity (probably ordering by byte value). I don't understand the use case for database-global collate settings. #postgresql #postgres #mysql #databases #rdbms #programming

Why normalize databases?
Yesterday, my tutoring student asked me why databases need to be normalized at all. She said: “Wouldn’t it be easier to just have one big table with all the information?”

It’s a common first question when learning about relational databases.
At first, one big table (e.g. customer name, order date, product name, price) seems easiest.

I told her:
:blobcoffee: Because that quickly leads to data redundancy, anomalies, and integrity issues when inserting, updating, or deleting records.
:blobcoffee: Normalization means structuring data into separate, related tables, so that each fact is stored only once. This reduces redundancy & preserves consistency.

🚀 Opteryx v0.24.0 is out today!

This release is all about performance and reliability—smoother execution, faster queries, and fewer surprises. No flashy features, just solid upgrades where it counts.

Because great engines don’t just go fast—they stay fast. ⚙️💨

Check it out and drop us a ⭐!
🔗 github.com/mabel-dev/opteryx

🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives. - mabel-dev/opteryx
GitHubGitHub - mabel-dev/opteryx: 🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives.🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives. - mabel-dev/opteryx

Turso is the second database project (that I know of) to come out of Finland. It's mission is to become a better drop-in replacement for SQLite. Seems fascinating, will definitely keep an eye on it.

[Aside: The name stands for either an octopus or a mythical sea beast from Finnish folklore.]

github.com/tursodatabase/turso

Turso Database is a project to build the next evolution of SQLite. - tursodatabase/turso
GitHubGitHub - tursodatabase/turso: Turso Database is a project to build the next evolution of SQLite.Turso Database is a project to build the next evolution of SQLite. - tursodatabase/turso

New blog post 📒 Bits of engineering wisdom from a year of the #TalkingPostgres #podcast 🎙️

featuring highlights from 13 episodes in the past year with amazing #PostgreSQL guests including: Tom Lane, Bruce Momjian, Daniel Gustafsson, David Rowley, Melanie Plageman, Robert Haas, Affan Dar, Andrew Atkinson, @BajoranEngineer, Peter Cooper, Peter Farkas, Pino de Candia, & Shireesh Thota

Hope y'all enjoy it! And big +1 🙏 to @asw for co-producing this monthly pod with me techcommunity.microsoft.com/bl

TECHCOMMUNITY.MICROSOFT.COMBits of wisdom from a year of Talking Postgres | Microsoft Community HubHighlights from the past 13 episodes of the monthly Talking Postgres podcast, featuring long-form conversations with PostgreSQL experts. Check it out and let...