Database Architecture for Parsing Tariffs on PostgreSQL https://sudonull.com/database-architecture-for-parsing-tariffs-on-postgresql
Study the star schema for storing internet and TV tariffs: fact tables, dimensions, historicity triggers, indexes. Full SQL code for middle/senior developers. Implement provider monitoring without data loss.
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.