An example project using F# and SQLite, that involves:

• defining and running DB in F# using fluentmigrator
• setup of SqlProvider with SQLite (involving copying the files to right place)
• using SqlProvider to work with the data
• running on top of dotnet core v3.0 using Linux containers

The simplest way to get the reproducible setup is to use Linux containers. This instructions prefer Buildah and Podman over docker, as they don't need any additional daemon to be running on the system. Corresponding docker commands should still work though.

To build the sample application image, run:

buildah bud -t inecas/fsharp-sqlite .

This will download the dotnet core v3 SDK image and will prepare the setup for running the application.

podman run --rm -ti --name inecas-fsharp-sqlite inecas/fsharp-sqlite
dotnet run -p src/FSharpSqlite.Use
# outputs: John's id is 1