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

Take a peek at Johannes Schuetzner’s talk from #PosetteConf 2025 “Fortifying Azure Database for #PostgreSQL: Stop Intrusions in Their Tracks"

https://youtu.be/eay-C2LI3Mk

Handle DBA changed table name with Entity Framework in C# Tip #118 #softwaredeveloper #codingbasics #learntocode #codinglife #learncoding #datascience #visualstudio #databases #sql #softwareengineer #vscode #webdevelopment #csharp #dotnet #visualstudiocode #computerscience #coding #codingforbeginners #sqlserver #linq

Giving Benchmarks a Boat https://lobste.rs/s/regzyw #databases #performance
https://buttondown.com/jaffray/archive/giving-benchmarks-a-boat/

Tune in to Shinya Kato’s talk from #PosetteConf 2025 “Can We Use Rust to Develop Extensions for #PostgreSQL?"

https://youtu.be/0NKFVQq0YuA

Map a class to a specific database table with Entity Framework in C# Tip #117 #sqlserver #linq #codingforbeginners #softwaredeveloper #codingbasics #learntocode #codinglife #learncoding #datascience #coding #visualstudio #databases #sql #softwareengineer #vscode #webdevelopment #csharp #dotnet #visualstudiocode #computerscience

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:
Because that quickly leads to data redundancy, anomalies, and integrity issues when inserting, updating, or deleting records.
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 !
https://github.com/mabel-dev/opteryx

Data Annotations Not Working in Entity Framework in C# Tip #116 #csharp #dotnet #vscode #softwareengineer #sqlserver #linq #codingforbeginners #softwaredeveloper #codingbasics #learntocode #sql #codinglife #learncoding #datascience #coding #visualstudio #databases #webdevelopment #visualstudiocode #computerscience

after bitnami went rogue and giving 28th August deadline to move away from their charts, had to move ≈2Ti #PostgreSQL database. Decided to go for @CloudNativePG and happy I did so.

Clearly the operator handles professionally and gives signals that its developers & maintainers are definite pro-gamers in managing PostgreSQL clusters at scale. Thank you for this amazing project

Data Annotations Max Length Entity Framework in C# Tip #115 #learntocode #learncoding #codingbasics #softwaredeveloper #codinglife #coding #codingforbeginners #linq #datascience #visualstudio #databases #softwareengineer #sqlserver #vscode #csharp #dotnet #visualstudiocode #webdevelopment #computerscience #sql

Nullable but not null https://lobste.rs/s/6qe3ml #databases
https://efe.me/posts/nullable-but-not-null/

See the Actual SQL Script with Entity Framework in C# Tip #114#sql #csharp #databases #dotnet #softwareengineer #sqlserver #learntocode #learncoding #codingbasics #softwaredeveloper #codinglife #vscode #coding #codingforbeginners #linq #datascience #visualstudio #visualstudiocode #webdevelopment #computerscience

The FastLanes File Format https://lobste.rs/s/hvrsfx #pdf #databases
https://github.com/cwida/FastLanes/blob/dev/docs/specification.pdf

PSA: SQLite WAL checksums fail silently and may lose data https://lobste.rs/s/aartyj #databases
https://avi.im/blag/2025/sqlite-wal-checksum/

Migration Files of Entity Framework in C# Tip #113#sql #codingforbeginners #computerscience #webdevelopment #visualstudiocode #csharp #visualstudio #datascience #linq #coding #databases #dotnet #vscode #softwareengineer #sqlserver #learntocode #learncoding #codingbasics #softwaredeveloper #codinglife

How we discovered, and recovered from, Postgres corruption on the matrix.org homeserver https://lobste.rs/s/x6qsw2 #databases
https://matrix.org/blog/2025/07/postgres-corruption-postmortem/

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.]

https://github.com/tursodatabase/turso

Undo the Last Migration (and Roll Back the DB Schema) Entity Framework in C# Tip #112 #sqlserver #vscode #softwareengineer #sql #codingforbeginners #computerscience #webdevelopment #visualstudiocode #csharp #visualstudio #datascience #linq #coding #databases #dotnet #learntocode #learncoding #codinglife #codingbasics #softwaredeveloper

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 https://techcommunity.microsoft.com/blog/adforpostgresql/bits-of-wisdom-from-a-year-of-talking-postgres/4434622