Skip to content
CAI
Software that uses CAICheck a score

daz10000/fss

57.9

Adequate · 15 November 2026

3.6k

lines of production code

F#

primary language

5

measurements over time

CAI band scale
CAI trend line
CAI lens gauges

What this system is

Features

Initial release of fss\_postgres for typed SQL on PostgreSQL

Adds the fss\_postgres library, enabling users to execute typed SQL queries and inserts against PostgreSQL databases using the Npgsql driver. The new module provides a DynamicSqlConnection that maps query results directly to F\# records (handling NULLs as options) and supports transactions, primary key detection, and schema introspection. It also includes a registerDataSource function to allow configuration of NpgsqlDataSource features like enum mapping before connection creation.

_src/fss\postgres · high confidence

Introduction of F\# SQLite ORM wrapper

A new standalone SQLite database wrapper module has been added to the Fss library, providing an F\# ORM interface for SQLite databases. This component allows users to interact with SQLite using dynamic SQL connections and transactions, leveraging Microsoft.Data.Sqlite for modern .NET compatibility. The implementation includes schema retrieval and column detail mapping specific to SQLite, enabling database operations without requiring other Fss dependencies.

_src/fss\sqlite · high confidence

Introduction of legacy F\# web server and database wrappers

This change introduces the \fss\ package, a small F\# HTTP server featuring regex routing and a Jinja2-style templating engine, along with database wrapper packages for MySQL, PostgreSQL, and SQLite. The server includes session management via cookies and a configurable error handler, but is explicitly marked as legacy with maintenance fixes only; users are advised to use ASP.NET Core (Giraffe, Falco) for new projects. The documentation highlights security limitations, noting that templates do not HTML-escape output and the server lacks TLS support.

src/fss · high confidence

New DuckDB integration for F\# record mapping

Added a new \fss\_duckdb\ module that enables querying DuckDB tables, CSV, Parquet, and JSON files directly into F\# records, as well as inserting records without manual mapping code. This in-process library supports typed SQL queries, automatic column-to-field matching (with NULLs mapped to options), generated key retrieval, and transaction management via the \DynamicSqlConnection\ and \DynamicSqlTransaction\ types.

_src/fss\duckdb · high confidence

New sample applications and scripts for F\# data and web libraries

Added a collection of sample projects demonstrating the core APIs and usage patterns for the F\# data and web libraries. DuckDbQuickStart and DuckDbAnalytics showcase the DuckDB connector with features like record mapping, parameterized queries, transactions, and in-place CSV/Parquet analytics. PostgresQuickStart demonstrates schema management and serial keys with Npgsql. SqliteTodo and SqliteToDuckDb illustrate SQLite interactions and cross-engine ETL. LegacyWebServer provides a reference for the legacy HTTP server and Jinja2-style templates, including proper HTML escaping. A new F\# script sample shows how to query CSV files using the published NuGet package.

samples · high confidence

Behavioural changes

fss 2.1.0: .NET 10 port, DuckDB support, and major bug fixes

The fss library has been upgraded to target .NET 10 and now includes a primary DuckDB dialect alongside existing PostgreSQL and SQLite support. This release introduces parameterized queries, automatic type conversion, and schema-qualified table names for inserts. It also fixes several critical bugs, including connection pool leaks, incorrect metadata queries for DuckDB and SQLite, and race conditions in the keep-alive thread. The legacy web server package is retained for maintenance but marked as such, and the MySQL dialect is retired. Build tooling has been simplified by removing Paket and FAKE in favor of standard .NET CLI and NuGet Central Package Management.

(repo-wide) · high confidence

Test coverage

Added unit tests for JSON parsing, template engine, connection pooling, and database providers

The test suite now includes comprehensive unit tests for core library components. JSON parsing is verified for integers, floats, and exponential notation. The template engine is tested for nested loops, conditional logic, and variable extraction. Connection pooling behavior is validated, including thread safety, double-release error handling, and disposal on construction failure. Database integration tests cover DuckDB (in-memory and file-based, including pooled connections), MySQL, PostgreSQL (including enum mapping), and SQLite, exercising insert, query, nullable types, and schema operations.

tests · high confidence

Dependencies

Adopts Central Package Management and updates database driver versions

The project now uses NuGet Central Package Management via Directory.Packages.props to manage dependency versions in one place. This change updates the versions of key database drivers: Npgsql to 10.0.3, Microsoft.Data.Sqlite to 10.0.13, DuckDB.NET.Data.Full to 1.5.6.1, and MySql.Data to 26.7.0. It also sets FSharp.Core to 8.0.403 and updates test dependencies (NUnit to 5.0.0, Microsoft.NET.Test.Sdk to 18.11.0).

(dependencies) · high confidence

Written by cca.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

How this codebase got here

Score

  • CAI 62 → 58 (-4.5)
  • Rubric changed (rubric-2026.10.5 → rubric-2026.11.4) — scores are not directly comparable.

Lenses

  • Code Health 72 → 66 (-6.7)
  • Architecture 100 → 100 (+0.0)
  • Maturity 56 → 60 (+3.2)
  • Readiness 67 → 71 (+3.9)
  • Security 61 → 49 (-12.9)

Resolved (4)

  • IL efficiency: 20 authored method(s) exceed the IL budget (src/fss/template.fs)
  • Off-boarding risk: anonymized user #1
  • Outdated: FSharp.Core
  • Outdated: MySql.Data

New (6)

  • Low coverage: src/fss/cookie.fs (src/fss/cookie.fs)
  • Low coverage: src/fss/fss.fs (src/fss/fss.fs)
  • Low coverage: src/fss/multipart.fs (src/fss/multipart.fs)
  • Off-boarding risk: anonymized user #1
  • Outdated: FSharp.Core (Directory.Packages.props)
  • Outdated: Microsoft.NET.Test.Sdk

Changes since last survey

  • 4 commits — 4 feature/other, 0 fixes

By area

  • (repo) — 2 commits
  • (root) — 2 commits

Notable commits

  • change: Bump Microsoft.Data.Sqlite from 10.0.13 to 10.0.14
  • change: Bump MySql.Data from 26.7.0 to 26.10.0
  • change: Merge pull request #20 from daz10000/dependabot/nuget/drivers-d85968326b
  • change: Merge pull request #21 from daz10000/dependabot/nuget/MySql.Data-26.10.0

Written by cca.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

Survey your own repository

daz10000/fss was measured the same way every project in this corpus was: the same rubric, at a pinned commit, with the result published in full. Point a surveyor at a repository you know and see whether you agree with it.

About this page

  • The score is its most recent published measurement, taken on 15 November 2026 at a pinned commit. It is not a live figure and does not change until the project is measured again.
  • Measured at commit 82c9715cb1d1806eafdeceffd111dc012c97b6b4 — the exact code this score is about.
  • Scored under rubric-2026.11.4 — the same rubric and the same method as every other entry in this index.
  • Measured by Canine Code Analyzer (cca.canine.dev) using cca measure-2026.11.65+preprod-3c33c1882dc1.