DB migrations in legacy without ORM: structure and practice https://sudonull.com/db-migrations-in-legacy-without-orm-structure-and-practice
Setting up DDL/DML migrations for legacy systems: Git structure, version tables, deploy to dev/prod. Change control without Liquibase/Flyway. Instructions for middle/senior dev.
Uniform DB Sharding: Data Distribution and Search Strategies https://sudonull.com/uniform-db-sharding-data-distribution-and-search-strategies
Explore uniform sharding methods for horizontal scaling of databases. Learn about ID generation, paging, and query optimization in distributed systems.
Designing OLTP DB on Rust: principles https://sudonull.com/designing-oltp-db-on-rust-principles
Learn the principles of creating an OLTP database from scratch: restrictive by default, contract-first, Rust traits, hybrid async/sync. Real trade-offs for middle/senior dev. Study the architecture.
sa-tests-db: data flows in static analysis https://sudonull.com/sa-tests-db-data-flows-in-static-analysis
Learn how data flow analysis and interprocedural approach allow the static analyzer to pass Russian National Standard R 71207-2024 on sa-tests-db. Details on data-flow, control-flow, and hybrid scheme for C, Java, Python.
eBPF rootkit in Linux: DB leak via contractor https://sudonull.com/ebpf-rootkit-in-linux-db-leak-via-contractor
Breakdown of a real eBPF rootkit case: symptoms, detection with bpftool, attack chain via contractor. Protection measures for Linux servers: 2FA, bpf() audit, Falco. Learn how to prevent PII exfiltration.