Lena flinched. “SQLite isn’t a relational database. It’s a clever file with SQL pretensions. We use ROW_NUMBER() , CTEs, and MERGE statements. SQLite will choke. We need the real engine.”
Priya wrote a test that spawned 50 concurrent threads, each running a UPDATE ... OUTPUT deleted.* statement inside a SERIALIZABLE transaction. On SQLite, it would have deadlocked instantly. On LocalDB, it ran perfectly—because it was SQL Server. mssqllocaldb
Three years later, Lena was a principal engineer. A new hire asked during onboarding: “Why do we use LocalDB for testing instead of a containerized SQL Server?” Lena flinched