#document-database

2 posts

September 15, 2026 · 8 min read

Search in Polecat, Part 1: Full text search on an index it owns

Polecat 5.29 added keyword search to the Critter Stack's SQL Server store, and it does not use SQL Server's full-text engine to do it. The inverted index Polecat maintains itself, the LINQ operators over it, and BM25 ranking derived from the token rows.

polecat sql-server dotnet critter-stack

August 28, 2026 · 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