· software
EF Core Change Tracking: The Bug Factory You Accidentally Built
Most production EF Core problems do not start with broken code They start with code that works. Queries return data. Updates succeed. Performance looks accepta...
-
- · software
Migração de dados entre serviços: estratégias, riscos e trade-offs
Contexto Recentemente precisei migrar dezenas de milhares de registros de auditoria entre dois serviços durante uma task! Era minha primeira vez fazendo uma mig...
- · software
From System Transactions to User Transactions in SQLite
User Transactions: Escaping Autocommit By default, SQLite runs in autocommit mode. Every non‑SELECT statement is wrapped in its own transaction: !Autocommit tr...
- · software
Database Transaction Leak
Introduction We often talk about memory leaks, but there is another silent performance killer in backend development: Database Transaction Leaks. I recently sp...
- · software
How To Solve LeetCode 1193
Problem Description The table Transactions has the following columns: - id primary key - country - state enumeration: 'approved' or 'declined' - amount - trans...
- · software
Journals Beyond the Basics in SQLite
Introduction Hello, I’m Maneshwar. I’m currently building FreeDevTools online – a free, open‑source hub that gathers all developer tools, cheat codes, and TL;D...
- · software
Understanding Database Models: DDIA Chapter 2
Overview This chapter from Designing Data‑Intensive Applications explores different database models and strategies for structuring application data. Understand...
- · software
How To Solve LeetCode 586
Problem Overview The task is to identify the customer number that has placed the largest quantity of orders. The Orders table contains two identifier columns:...
- · software
Database Transactions
Transactions are fundamental to how SQL databases work.Trillions of transactions execute every single day, across the thousands of applications that rely on SQL...
- · software
The second-highest salary: Why the simplest SQL query is often the smartest
When interviewing for backend or data roles, you’ll often see the classic problem: “Find the second highest salary from the Employee table. If there is no secon...
- · software
🐌 “My Spring Boot API Became Slow… Until I Learned Pagination & Sorting”
!Cover image for 🐌 “My Spring Boot API Became Slow… Until I Learned Pagination & Sorting”https://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gr...
- · software
Learning through building: SurrealDB University's newest tutorial
Introduction Today we're pleased to announce a new addition to SurrealDB University, the best place to learn SurrealDB and its query language. This new tutoria...