https://explainanalyze.com/p/designing-partitioning-you-dont-have-to-babysit/
Designing Partitioning You Don't Have to Babysit
Six months in, p_future holds 800M rows because the growth projection didnât survive the workload, and every ALTER to fix it needs a maintenance window nobody wants to schedule. The boundary management is two lines of DDL; the harder part is picking a partition key that doesnât leak into application code.
#databases
#postgresql
#mysql
#partitioning
#scaling
#architecture
about 1 month ago
https://sanyamserver.online/posts/cors/
CORS: What is it protecting?
is CORS a browser security measure or a server security measure?
about 1 month ago
https://blog.weineng.me/posts/slowest_add/
Data Access Patterns That Makes Your CPU Really Angry
Given an array of data, what is the slowest way to sum up the integers? Is it adding the numbers from left to right, adding them randomly, or doing something else? In this post, we are going to build a data access pattern from the ground up that sums numbers as slowly as possible by exploiting memory pitfalls.
about 1 month ago
https://www.youtube.com/watch?v=tadUeiNe5-g
How CPUs Interact with So Many Different Devices
In this video we learn the basics of I/O devices, and how the interact with the the CPU in general purpose systems.
#science & technology
about 1 month ago
https://blog.codingconfessions.com/p/what-makes-system-calls-expensive
What Makes System Calls Expensive
A look at how Linux handles system calls on x86-64, why crossing into the kernel has a cost, and why that cost shows up in performance profiles.
about 1 month ago
https://engineering.zalando.com/posts/2026/06/client-side-load-balancing.html
Client-Side Load Balancing at a Million Requests Per Second
How Zalando built an in-process client-side load balancer for a million requests per second of internal fan-out traffic, what we layered on top (N-ring fade-in, occupancy-based bounded load, and AZ-aware routing with a latency health factor), and how hardening that path cut cost and made the service resilient to the infrastructure underneath it.
#scalability
#sre
#kubernetes
#backend
about 1 month ago
https://www.ubicloud.com/blog/postgresql-and-the-oom-killer-why-we-use-strict-memory-overcommit
PostgreSQL and the OOM Killer: Why We Use Strict Memory Overcommit
Have you ever come into some awaful situation where you run kill on a postgres process that handle a connection and then suddenly the whole Postgres restart, even though you just kill a single process that handle one connection. This post explains that.
about 1 month ago
https://fergusfinn.com/blog/what-happens-when-you-run-a-gpu-kernel/
What happens when you run a CUDA kernel
about 1 month ago
https://spin.atomicobject.com/running-local-llms/
A Practical Guide to Running Local LLMs
Letâs be clear. Itâs going to be a long time before running a local LLM will produce the type of results that you can get from querying ChatGPT or Claude. However, self hosted is useful when privacy is critical or when response time is not important.
about 1 month ago
https://github.com/jamesob/local-llm
jamesob's guide to running SOTA LLMs locally
about 1 month ago
https://tech.coop.no/blog/platform-engineering/2026/06/25/automating-gcp-quota-monitoring-across-multiple-projects/
Automating GCP quota monitoring across multiple projects
about 1 month ago
https://peteris.rocks/blog/htop/
htop explain
about 1 month ago
https://github.com/klauspost/radsort
radsort
A Go implementation of Radsort â a stable LSD radix sort with O(ân) space overhead, from âParallel O(ân) Overhead LSD Radix Sortâ by Robert Clausecker and Florian Schintke
about 1 month ago
https://github.com/wneessen/go-mail/wiki
go-mail
Easy to use, yet comprehensive library for sending mails with Go.
about 1 month ago
https://github.com/sindresorhus/terminal-image
terminal
Display images in the terminal
about 1 month ago
https://github.com/bradautomates/claude-video
claude-video
Give Claude the ability to watch any video. /watch downloads, extracts frames, transcribes, hands it all to Claude.
about 1 month ago
https://wordgard.net/
wordgard
Open-source JavaScript library implementing an in-browser rich-text editor. I especially like the Collaborative Editing with their client/server example.
about 1 month ago
https://github.com/bitwire-it/ipblocklist
ipblocklist
IP lists full of bad IPs - Updated every 2H
about 1 month ago
https://upyo.org/
upyo
Send email from anywhere your code runs.
about 1 month ago
https://github.com/watzon/goshot
goshot
Create beautiful code screenshots with customizable styles
about 1 month ago
https://github.com/mozilla-ai/llamafile
llamafile
Distribute and run LLMs with a single file.
about 1 month ago
https://github.com/aristocratos/btop
btop
Resource monitor that shows usage and stats for processor, memory, disks, network and processes.
Similar to htop but better.
about 1 month ago
https://github.com/291-Group/LAN-Orangutan
LAN Orangutan
is a lightweight network scanner with persistent device labeling, multi-network support, and Tailscale integration. Built by 291 Group.â
about 1 month ago
https://github.com/prest/prest
prest
a production-ready API that delivers instant REST and Model Context Protocol (MCP) APIs on top of your existing or new Postgres databaseâCRUD, custom SQL routes, auth, ACL, and a read-only MCP endpointâwithout hand-writing a backend.
about 1 month ago