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

Add new column to existing table with Entity Framework in C# Tip #111 #softwaredeveloper #codingbasics #codinglife #learncoding #databases #visualstudiocode #codingforbeginners #softwareengineer #sqlserver #vscode #csharp #sql #computerscience #webdevelopment #visualstudio #datascience #linq #coding #dotnet #learntocode

Pogocache - Fast caching software https://lobste.rs/s/1ylyds #c #databases
https://github.com/tidwall/pogocache

Rickrolling Turso DB (SQLite rewrite in Rust) https://lobste.rs/s/svrctd #databases #rust
https://avi.im/blag/2025/rickrolling-turso/

Apply migration without data loss with Entity Framework in C# Tip #110 #visualstudiocode #databases #softwaredeveloper #codingbasics #codinglife #learncoding #codingforbeginners #dotnet #coding #linq #datascience #learntocode #visualstudio #softwareengineer #webdevelopment #computerscience #sqlserver #csharp #vscode #sql

Finally took the time VACUUM FULL all my #PostgreSQL #databases and empty a runaway table. Dropped from ~90% diskusage to ~25% and a hell of a lot less CPU

Easy Steps to Install Entity Framework Migration Tools C# Tip #109 #webdevelopment #softwareengineer #visualstudiocode #databases #softwaredeveloper #sqlserver #computerscience #codingbasics #codinglife #learncoding #sql #csharp #codingforbeginners #dotnet #coding #linq #datascience #learntocode #vscode #visualstudio

Async I/O on Linux in databases

https://blog.canoozie.net/async-i-o-on-linux-and-durability/

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

I've been busy these last few months working part-time on this database, web api, and web front end to store, and report on architectural project data. The source code for the web api can be found on Github (https://github.com/rperez-rosario/XPM_Server). The source code for the front end will soonish follow.