Jinaga.Store.SQLite 0.8.4

There is a newer version of this package available.
See the version list below for details.
dotnet add package Jinaga.Store.SQLite --version 0.8.4
NuGet\Install-Package Jinaga.Store.SQLite -Version 0.8.4
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Jinaga.Store.SQLite" Version="0.8.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Jinaga.Store.SQLite --version 0.8.4
#r "nuget: Jinaga.Store.SQLite, 0.8.4"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Jinaga.Store.SQLite as a Cake Addin
#addin nuget:?package=Jinaga.Store.SQLite&version=0.8.4

// Install Jinaga.Store.SQLite as a Cake Tool
#tool nuget:?package=Jinaga.Store.SQLite&version=0.8.4


Resilient, reliable data transfer for .NET.

What it Does

In Jinaga, you define a data model in terms of immutable facts. A fact represents an entity, a change to an entity, or a decision that a user or service has made.

In Jinaga.NET, facts are C# records.:

record Company(string identifier) {}

record Employee(Company company, int employeeNumber) {}

When a user or service makes a decision, you will add a fact to the system. This will store it in the local database. It will also update the local UI. And it will publish it so that others can learn about the decision.

var contoso = await j.Fact(new Company("Contoso"));
var jane = await j.Fact(new Employee(contoso, 1));
var bob = await j.Fact(new Employee(contoso, 2));

To query facts, write a specification. Start at a know fact and find all related facts that match that specification.

var employeesOfCompany = Given<Company>.Match((company, facts) =>
    from employee in facts.OfType<Employee>()
    where employee.company == company
    select employee

var contosoEmployees = await j.Query(contoso, employeesOfCompany);

A query returns results at a point in time. If you want to keep a user interface up-to-date, you will need to set up an event-based watch.

var observer = j.Watch(contoso, employeesOfCompany, employee =>
    var component = AddEmployeeComponent(employee);
    return () =>

Finally, if you want to be notified in real time of new information, just subscribe.

var subscription = j.Subscribe(contoso, employeesOfCompany);

The client will open a persistent connection with the server. The server will notify the client the moment a new employee is hired. Because the client already set up a watch, the new employee will appear on the UI.

Running a Replicator

A Jinaga front end connects to a device called a Replicator. The Jinaga Replicator is a single machine in a network. It stores and shares facts. To get started, create a Replicator of your very own using Docker.

docker pull jinaga/jinaga-replicator
docker create --name my-replicator -p8080:8080 jinaga/jinaga-replicator
docker start my-replicator

This creates and starts a new container called my-replicator. The container is listening at port 8080 for commands. Configure Jinaga to use the replicator:

var j = JinagaClient.Create(options =>
    options.HttpEndpoint = new Uri("http://localhost:8080/jinaga");


Jinaga.NET is co-evolving with Jinaga.JS. Each of these projects has a front end and a back end. Either front end is intended to work with either back end. And the back ends are intended to interconnect to form a decision substrate.

Jinaga Roadmap


The primary APIs for Jinaga are:

  • j.Fact - Add and publish a fact
  • j.Query - Project the facts matching a specification
  • j.Watch - Continually update a projection
  • j.Subscribe - Receive continuous updates from peers

The Subscribe API is not fully implemented in Jinaga.JS, and not implemented yet in Jinaga.NET. The JS version uses polling rather than the intended mechanism of Web Sockets or HTTP/2 Server Push.


Jinaga.NET currently has only memory storage, which is packaged with the core library. The next storage solutions to implement are SQLite to support Xamarin mobile apps and PostgreSQL to support Docker deployment. After that, the MS SQL Server implementation will support enterprise solutions that need to keep the journal transactionally consistent with the projection.


Authorization rules -- which limit the users who can create facts -- are implemented in Jinaga.JS, but not yet in Jinaga.NET. Distribution rules -- which limit the specifications that a user can query -- are not yet implemented in either.


This repository uses Nerdbank.GitVersioning to manage version numbers. To release a new version of the Jinaga.NET library, create a new tag in the format 1.2.3. Then create a new release based on that tag. The release will be published to NuGet.

To accomplish this from the command line, use a combination of git and gh commands.

$VERSION = "1.2.3"
git checkout main
git pull
git tag $VERSION
git push --tags
gh release create $VERSION --generate-notes --verify-tag
Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.1 is compatible. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
0.11.1 82 2/19/2024
0.11.0 63 2/16/2024
0.10.1 67 2/15/2024
0.10.0 82 2/11/2024
0.9.7 66 2/10/2024
0.9.6 64 2/8/2024
0.9.5 68 2/2/2024
0.9.4 59 2/1/2024
0.9.3 72 1/31/2024
0.9.2 78 1/24/2024
0.9.1 73 1/20/2024
0.9.0 59 1/19/2024
0.8.4 203 11/17/2023
0.8.3 111 11/11/2023
0.8.2 109 11/2/2023
0.8.1 88 11/1/2023
0.8.0 87 10/23/2023