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.
DBSC in Chrome 146: TPM session protection https://sudonull.com/dbsc-in-chrome-146-tpm-session-protection
Learn how Device Bound Session Credentials binds cookies to TPM, making stolen tokens useless. Technical details, backend implementation, and comparison with App-Bound Encryption. For developers.
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.