idunno.Bluesky.AspNet.Authentication.SQLite 7.0.0

Prefix Reserved
There is a newer version of this package available.
See the version list below for details.
dotnet add package idunno.Bluesky.AspNet.Authentication.SQLite --version 7.0.0
                    
NuGet\Install-Package idunno.Bluesky.AspNet.Authentication.SQLite -Version 7.0.0
                    
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="idunno.Bluesky.AspNet.Authentication.SQLite" Version="7.0.0" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="idunno.Bluesky.AspNet.Authentication.SQLite" Version="7.0.0" />
                    
Directory.Packages.props
<PackageReference Include="idunno.Bluesky.AspNet.Authentication.SQLite" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add idunno.Bluesky.AspNet.Authentication.SQLite --version 7.0.0
                    
#r "nuget: idunno.Bluesky.AspNet.Authentication.SQLite, 7.0.0"
                    
#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.
#:package idunno.Bluesky.AspNet.Authentication.SQLite@7.0.0
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=idunno.Bluesky.AspNet.Authentication.SQLite&version=7.0.0
                    
Install as a Cake Addin
#tool nuget:?package=idunno.Bluesky.AspNet.Authentication.SQLite&version=7.0.0
                    
Install as a Cake Tool

idunno.Bluesky.AspNet.Authentication.SQLite

About

A SQLite implementation of the backing stores for the idunno.Bluesky.AspNet.Authentication library.

Version History

A full version history can be found on the project's GitHub repository.

How to Use

Create the required tables by running the schema.sql file included in the package, then configure the authentication options with stores that use your SQLite connection string.

string connectionString = builder.Configuration.GetConnectionString("BlueskyAuthentication")!;

builder.Services
    .AddAuthentication()
    .AddBluesky(options =>
    {
        options.IdentityStore = new SqliteIdentityStore(connectionString);
        options.CorrelationCache = new SqliteCorrelationStateCache(connectionString);
    });

The identity store uses a seven-day sliding expiration by default. Refresh locks expire after 90 seconds, and correlation state expires after 15 minutes. Alternate lifetimes can be supplied to the constructors.

Expired rows are deleted by the store which wrote them, at most once every five minutes per store instance, so the tables stay bounded without an operator scheduling anything. Pass expiredEntrySweepInterval to change how often that happens, or TimeSpan.Zero to turn it off and reclaim the rows yourself. Expiry is enforced on read either way, so an unswept row authenticates nobody.

Use a file-backed database for application storage. In-memory SQLite databases do not persist across the separate connections used for store operations.

The package also includes a PowerShell script that creates a new database and applies the schema. The database is created in the current directory unless -OutputDirectory is specified.

.\New-AuthenticationDatabase.ps1 -OutputDirectory C:\data

The script requires the sqlite3 command-line tool on PATH and creates idunno.Bluesky.AspNet.Authentication.db. It refuses to overwrite an existing database.

You can install the latest version of the SQLite command-line tool via winget

winget install -e --id SQLite.SQLite

Documentation

Documentation is available, including API references.

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  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.  net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
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
7.0.1 42 9/27/2026
7.0.0 55 9/25/2026