# praeclarum/sqlite-net

Simple, powerful, cross-platform SQLite client and ORM for .NET

Repository: https://github.com/praeclarum/sqlite-net
Canonical: https://ross.abutalabs.com/products/sqlite-net
Language: C#
License: MIT
License Family: permissive
Last push: 2026-07-13T16:23:53+00:00

## Health v2 (maintenance only)
Score: 64/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 92, release rhythm 8, longevity 100
- inputs: {"age_days": 5608, "days_push": 51, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 4460, forks 1421 (observed 2026-08-28T04:08:50.688902+00:00)

## What it is
A minimal, single-file SQLite client and ORM for .NET, .NET Core, and Mono that provides strongly typed CRUD operations and queries via a thin reflection-driven layer. Distributed as NuGet packages (sqlite-net-pcl, sqlite-net-static, sqlite-net-base) and usable across Xamarin, UWP, and all .NET platforms.

## Use cases
- store data in sqlite from a .net app
- lightweight orm for c# sqlite database
- local database for xamarin mobile app
- crud operations with strongly typed results in .net
- add sqlite persistence to existing project without changing classes
- async sqlite access in .net core

## When to choose
- you want a tiny, fast sqlite wrapper that integrates into any .NET project with minimal setup
- you need simple typed CRUD and parameterized queries without a heavyweight ORM
- you target multiple .NET platforms including Xamarin, UWP, and Mono
- you prefer a single-file library you can drop into your source tree

## When to avoid
- you need advanced ORM features like migrations, complex relations, or LINQ query translation
- you use a database other than SQLite
- you require a full-featured data access framework with change tracking

## Facets
- artifact type: library
- maturity: stable
- function: orm, database-driver, database
- domain: databases, mobile-development, cross-platform, developer-tools
- platform: dotnet, cross-platform
- tags: sqlite, c-sharp, nuget, xamarin, crud, single-file-library, async, reflection-based-orm, mobile, desktop, ios, android

## Member repositories
- praeclarum/sqlite-net (main) score 64

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:50.688902+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:20:42.657250+00:00, confidence not recorded.
  - readme: https://github.com/praeclarum/sqlite-net (fetched 2026-08-28T04:08:50.688902+00:00, sha b97efe4d4b58)
- Data as of 2026-08-30T08:39:29.467469+00:00.
