Northwind Elixir Traders by Isaak Tsalicoglou is on sale on Leanpub! Its suggested price is $49.97; get it for $35.97 with this coupon: https://leanpub.com/sh/6PDP9txd #ComputerProgramming #Databases #Elixir

DST for async Rust https://lobste.rs/s/qftydp #databases #distributed #rust #testing
https://s2.dev/blog/dst

#Software #Technology #Programming #SoftwareDevelopment #Coding #SoftwareEngineering #Drop #Databases ️

"Managing #PostgreSQL at scale: Challenges, Tools, & Techniques" will be presented by @karenhjex (Karen Jex) at #PosetteConf 2025 (Livestream 3 on Wed Jun 11th @ 9:00am PDT (UTC-7))

Learn more: https://posetteconf.com/2025/talks/managing-postgres-at-scale-challenges-tools-techniques/

Valkey - A new hash table https://lobste.rs/s/lvofny #databases #performance
https://valkey.io/blog/new-hash-table/

Fast Compilation or Fast Execution: Just Have Both https://lobste.rs/s/kvganp #compilers #databases
https://cedardb.com/blog/compilation/

Hands down the best April Fool's day prank

New statement to end transaction in MariaDB - amen

Beautifully crafted by @sigmasternchen

Streaming changes from Postgres: the architecture behind Sequin https://lobste.rs/s/qrb3ve #databases #distributed
https://blog.sequinstream.com/streaming-changes-from-postgres-the-architecture-behind-sequin/

Stop syncing everything https://lobste.rs/s/tjh0qt #databases #distributed
https://sqlsync.dev/posts/stop-syncing-everything/

Is it a code smell for a table in Postgres to have mutually exclusive foreign keys?

For example, table A has foreign keys to table B and C, but there's a constraint in place where only one of those foreign keys can be populated.

My gut says I should be creating separate tables for these, as I'm effectively trying to tie a single table to multiple domain models (that happen to share the same fields).

- https://awstip.com/mastering-django-orm-from-models-to-advanced-queries-be22ec26e8bb

-----------------------
Django ORM turns complex database queries into simple Python code. Instead of writing long SQL statements, you can use:

- Basic filters (filter(), exclude(), get()) to find exactly what you need.
- Smart optimisations (select_related(), prefetch_related()) to speed up your app.
- Handy tricks (annotate(), aggregate()) for calculations without extra code.
-------------------------------------

Fjall 2.8 via @kero https://lobste.rs/s/ssubpj #databases #rust
https://fjall-rs.github.io/post/fjall-2-8/

2024's hottest topics in databases (a bibliometric approach) https://lobste.rs/s/tgbfli #databases
https://rmarcus.info/blog/2025/03/28/hottest-db-topics.html

A Language Server for Postgres via @fanf https://lobste.rs/s/fstz1l #databases #editors
https://github.com/supabase-community/postgres-language-server

New Book Launch! Northwind Elixir Traders by Isaak Tsalicoglou https://leanpub.com/blog/new-book-launch-northwind-elixir-traders-by-isaak-tsalicoglou #books #ebooks #newreleases #programming #databases

Resource: "Journals No Longer Being Indexed By #ERIC" ("The number of actively cataloged sources will be reduced by approximately 45% starting April 24, 2025.") https://docs.google.com/document/d/1H5qSJQE2N-wh6FxnWxBHE9r5Oq9mW-kI5Q_LDf4pKs4/edit?tab=t.0 #databases #education #libraries

Our own worst best customer https://lobste.rs/s/ijntue #databases #distributed #testing
https://antithesis.com/blog/2025/testing_pangolin/

Simple Datalog engine in Rust (2018) https://lobste.rs/s/dqhofu #databases #rust
https://github.com/frankmcsherry/blog/blob/master/posts/2018-05-19.md

Things that go wrong with disk IO https://lobste.rs/s/g8pxhy #databases #linux
https://notes.eatonphil.com/2025-03-27-things-that-go-wrong-with-disk-io.html