“What’s that?”
“Then we wait ten minutes per build,” Marcus shrugged.
Her lead, Marcus, had a tired solution: “Just use SQLite for tests.” mssqllocaldb
She wrote a connection string that looked like heaven: Server=(localdb)\CodeCraftBuild;Integrated Security=true;Database=WidgetMetrics_Test;
The pipe name appeared. She connected SSMS to it while a failing test was paused on a breakpoint. Inside the database, an open transaction held locks. She could see them. She could kill them. She could rewrite the query right there. “What’s that
That night, Lena dreamed in deadlocks.
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.” Inside the database, an open transaction held locks
Lena paused. “Containers are great. But LocalDB is lighter. It starts in milliseconds. It doesn’t require pulling images. It’s already on every Windows developer’s machine, installed by Visual Studio. And it has one superpower containers don’t.”
