How to Choose Between SQL and NoSQL Databases: Practical Guide https://sudonull.com/how-to-choose-between-sql-and-nosql-databases-practical-guide
Learn how to choose between SQL and NoSQL databases for a project with this practical guide. Compare ACID, scalability, use cases, and make the right database decision.
Data Types for Passport and Identifiers in SQL: Storage Errors https://sudonull.com/data-types-for-passport-and-identifiers-in-sql-storage-errors
Learn why passport and other identifiers should be stored as strings, not numbers in SQL. Avoid loss of leading zeros and data errors. Read the guide for developers.
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.
How to Design a Scalable Web Application Architecture https://sudonull.com/how-to-design-a-scalable-web-application-architecture
Learn how to design a scalable web application architecture with practical strategies for statelessness, database sharding, caching, and observability. Expert guide with actionable steps.
How to Design a Scalable System Architecture: Step-by-Step Guide https://sudonull.com/how-to-design-a-scalable-system-architecture-step-by-step-guide
Learn how to design a scalable system architecture with a step-by-step framework. Master scaling principles, microservices, and database strategies for resilient systems.