I’ve grown fond of SQLite during my time as a developer advocate. The file-based database with native drivers for every operating system allows me to ship self-contained data-driven sample apps to developers worldwide. Developers can clone a demo and run it immediately without the need for additional dependencies like a database server, Docker container, or remote hosting environment. It’s excellent, and I’m sure my readers appreciate it.
Typically, when writing demos, I need to seed an SQLite instance with enough data to make my point. In my previous post, I needed to show the performance impact of paging deep into a large dataset using EF Core. When writing the previous post, I learned the fastest way to seed an SQLite database using EF Core and work around EF Core with SQL.