Change SQL Server to SQLite

[alexeyzimarev]

All excercises and the demo require SQL Server, which is problematic for people running macOS and Linux. I would suggest using SQLite since it will run everywhere.

[mauroservienti]

Originally it was all based on SQLite, we had so many threading issues that we decided to switch to something more reliable. Now that SQL Server is available for Linux and can be run in a container the issues seems less relevant. Thoughts?

[alexeyzimarev]

Hmm, we usually run integrated tests with SQLite and I don't remember threading issues to come up. May be these are already fixed? SQL Server container alone is several gigabytes. May be using a database abstraction and allow people using something like PostgreSQL?

[adamralph]

It's the first time this has been suggested, but I can sympathise with the reasoning. I suggest that we poll for opinion on the prerequisites in some of the upcoming workshops we have and then revisit this.

[alexeyzimarev]

I with great certainty can predict that this will be a demand very soon, as the .NET Core will spread and people will use more of containerised environments. PgSQL container is like 100Mb and SQL Server is a few gigabytes.

[mauroservienti]

As soon as the upcoming support for PostgreSQL in SQL Persistence is out, transitioning everything to PostgreSQL and containers is a feasible step.