· 17 min read
Fisher on SQLite, Part 1: The document store
Fisher is the Marten and Polecat programming model on SQLite, running inside your own process with no database server at all. A tour of the document side: identity, sessions, LINQ including joins and paging, expression indexes against generated columns, patching, optimistic concurrency, and the single-writer constraint everything else follows from.
fisher sqlite dotnet critter-stack