Distributed System Illustrated by lichuang is a new release on Leanpub!
Master distributed systems through visual diagrams — from clock drift and CAP to Paxos, Raft, and distributed transactions, explained with clear illustrations instead of dense academic papers.
Link: https://leanpub.com/distributed-system-illustrated
#books #ebooks #newreleases #leanpublishing #selfpublishing #distributed_systems #databases
Scaling Rails: 41M Req/Hour, 8 DBs, disable_joins: true
https://andyatkinson.com/how-aura-frames-scales-for-peak-load-ruby-on-rails
📌 Overview Ruby on Rails has helped make it possible to scale out the database layer, meeting the demands of millions of Aura Frames customers enjoying their digital photo frames. In late 2025, the team added additional primary databases to expand capacity for peak write and read load ahead of Christmas Day, the busiest day of the year for the company. Rails manages queries and schema changes for each primary database within the same codebase, and now with the additional capacity of many primary databases. With 8 primary databases in total, each server instance can be vertically scaled ahead of peak load. When load returns to normal levels, instances are scaled down for cost savings. The team leveraged native support for Multiple Databases and the disable_joins: true feature in Active Record, the ORM for Ruby on Rails. The disable_joins feature replaces SQL joins, issuing multiple SELECT statements to combine data in the application from different databases. This post looks back at the technical details of that plan, as well as a variety of additional data layer scaling tactics, that culminated in a successful Christmas 2025 season, with peak U.S. and Canadian Apple App Store and Google Play Store rankings of #1.
Dev Leader's Nick Cosentino (@devleader) writes up a great guide to Entity Framework Core optimization for .NET 10 in a structured fashion. From simple-to-implement read performance enhancements, to deep dives that include bulk operations, connection pooling, caching, parameterized queries, logging using Serilog, and many others.
"EF Core Performance Best Practices in .NET 10"
https://www.devleader.ca/2026/06/23/ef-core-performance-best-practices-in-net-10
#dotnet #csharp #efcore #orm #databases #sql #programming #optimization
Shipping psql Without psql: A Pure-TypeScript Postgres Client in neonctl, by (not on Mastodon or Bluesky):
https://neon.com/blog/shipping-psql-without-psql?ref=frontenddogma.com
"Did you know that because humans organize databases, they lack the ability to ‘guess’ your query the way Google can, therefore requiring more thought?
This means the search must be stripped down to as few words as possible to express the main idea." https://action.everylibrary.org/library_databases_really_have_it_all
#Library #Libraries #Services #Resources #Free #Ebooks #Queries #DigitalResources #LibraryDatabases #Databases #DigitalLibraryCollections
Lobsters
Leanpub
Lobsters
Foojay.io
Rafael Pérez ☀️
Frontend Dogma
EveryLibrary
The Register
