Ax.Fw.Storage
13.0.196
See the version list below for details.
dotnet add package Ax.Fw.Storage --version 13.0.196
NuGet\Install-Package Ax.Fw.Storage -Version 13.0.196
<PackageReference Include="Ax.Fw.Storage" Version="13.0.196" />
paket add Ax.Fw.Storage --version 13.0.196
#r "nuget: Ax.Fw.Storage, 13.0.196"
// Install Ax.Fw.Storage as a Cake Addin #addin nuget:?package=Ax.Fw.Storage&version=13.0.196 // Install Ax.Fw.Storage as a Cake Tool #tool nuget:?package=Ax.Fw.Storage&version=13.0.196
Ax.Fw.Storage
Simple document database; based on SQLite
Why?
I just wanted to create an instance of class and be able to write to database, read from database, enumerate elements in database by key without thinking about "this database's BSON don't support ImmutableDictionary, meh", "that database doesn't support numeric keys, meh", "ah, I can't search for values of integer column using unsigned integer variable, meh" and so on. Why not "key-value" storage? I also wanted to filter my objects by last changed
time. That's it. This document storage engine is not as fast as more "strongly-typed" databases (I think it's 1.1 - 1.5x slower in some scenarios), but it is reliable as any SQLite database.
Usage example:
// we need CancellationToken
var ct = default(CancellationToken);
// path to database file
var dbFile = "/home/user/data.db"
try
{
// create database or open existing
using var storage = new SqliteDocumentStorage(dbFile);
// create document; pair 'namespace - key' is unique; any json serializable data can be stored
var doc = await storage.WriteDocumentAsync(_namespace: "default", _key: "test-key", _data: "test-data-0", ct);
// retrieve data
var readDoc = await storage.ReadDocumentAsync(_namespace: "default", _key: "test-key", ct);
Assert.Equal("test-data-0", readDoc?.Data.ToObject<string>());
// there are also 'simple' documents;
// namespace of simple documents is automatically determined by data type or by `SimpleDocumentAttribute`
var simpleDoc = await storage.WriteSimpleDocumentAsync(_entryId: 123, _data: "test_data", ct);
var readSimpleDoc = await storage.ReadSimpleDocumentAsync<string>(_entryId: 123, ct);
Assert.Equal("test_data", readSimpleDoc?.Data);
// you also can attach in-memory cache to document storage
// cache makes read operations significantly faster
using var cachedStorage = storage.WithCache(_maxValuesCached: 1000, _cacheTtl: TimeSpan.FromSeconds(60));
// you also can attach retention rules to document storage
// documents older than certain age will be automatically deleted
using var storageWithRules = storage
.WithRetentionRules(TimeSpan.FromHours(1), TimeSpan.FromHours(1), TimeSpan.FromMinutes(10));
}
finally
{
new FileInfo(dbFile).TryDelete();
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. 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 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. |
-
net6.0
- Ax.Fw (>= 13.0.196)
- Microsoft.Data.Sqlite (>= 8.0.0)
- System.Data.SQLite.Core (>= 1.0.118)
-
net8.0
- Ax.Fw (>= 13.0.196)
- Microsoft.Data.Sqlite (>= 8.0.0)
- System.Data.SQLite.Core (>= 1.0.118)
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 |
---|---|---|
14.4.240 | 122 | 11/2/2024 |
14.4.239 | 141 | 10/18/2024 |
14.4.237 | 88 | 9/19/2024 |
14.4.236 | 141 | 8/11/2024 |
14.3.235 | 107 | 8/10/2024 |
14.3.234 | 67 | 8/5/2024 |
14.3.233 | 72 | 7/29/2024 |
14.3.232 | 89 | 7/23/2024 |
14.3.231 | 87 | 7/22/2024 |
14.3.230 | 102 | 7/17/2024 |
14.3.229 | 76 | 7/17/2024 |
14.3.228 | 87 | 7/11/2024 |
14.3.227 | 91 | 7/10/2024 |
14.3.226 | 117 | 7/3/2024 |
14.3.225 | 112 | 6/14/2024 |
14.3.224 | 81 | 6/7/2024 |
14.3.223 | 101 | 6/6/2024 |
14.3.222 | 109 | 5/17/2024 |
14.3.221 | 133 | 4/12/2024 |
14.2.219 | 103 | 4/11/2024 |
14.2.218 | 100 | 4/10/2024 |
14.2.217 | 194 | 3/29/2024 |
14.2.216 | 115 | 3/27/2024 |
14.2.215 | 111 | 3/22/2024 |
14.1.212 | 117 | 3/11/2024 |
14.1.211 | 103 | 3/11/2024 |
14.1.210 | 107 | 3/6/2024 |
14.1.208 | 113 | 3/6/2024 |
14.1.206 | 119 | 3/2/2024 |
14.1.205 | 120 | 3/1/2024 |
14.0.204 | 121 | 2/19/2024 |
14.0.203 | 106 | 2/16/2024 |
14.0.201 | 115 | 2/15/2024 |
13.0.200 | 129 | 2/10/2024 |
13.0.199 | 109 | 2/10/2024 |
13.0.198 | 106 | 2/10/2024 |
13.0.197 | 287 | 12/10/2023 |
13.0.196 | 123 | 12/10/2023 |
13.0.195 | 122 | 12/9/2023 |
13.0.194 | 105 | 12/6/2023 |
13.0.192 | 120 | 12/5/2023 |
13.0.191 | 147 | 11/26/2023 |
13.0.189 | 129 | 11/24/2023 |
13.0.186 | 125 | 11/23/2023 |
13.0.185 | 129 | 11/22/2023 |
13.0.182 | 127 | 11/18/2023 |
13.0.181 | 149 | 11/14/2023 |
13.0.180 | 139 | 11/12/2023 |
13.0.179 | 120 | 11/10/2023 |
12.1.178 | 149 | 10/25/2023 |
12.1.177 | 141 | 10/24/2023 |
12.1.176 | 139 | 10/21/2023 |
12.1.175 | 141 | 10/21/2023 |
12.1.173 | 134 | 10/16/2023 |
12.1.172 | 154 | 10/15/2023 |
12.1.171 | 137 | 10/15/2023 |
12.1.170 | 128 | 10/15/2023 |
12.1.168 | 154 | 10/15/2023 |
12.1.167 | 114 | 10/14/2023 |
12.1.166 | 173 | 9/7/2023 |
12.1.165 | 197 | 8/28/2023 |
12.1.164 | 222 | 8/15/2023 |
12.1.163 | 189 | 8/14/2023 |
12.1.162 | 164 | 8/14/2023 |
12.1.161 | 205 | 6/20/2023 |
12.1.160 | 204 | 6/10/2023 |
12.1.158 | 169 | 5/31/2023 |
12.1.157 | 167 | 5/22/2023 |
12.1.7 | 163 | 5/21/2023 |
12.1.0 | 161 | 5/19/2023 |
12.0.21 | 170 | 5/18/2023 |
12.0.20 | 150 | 5/18/2023 |
12.0.19 | 171 | 5/10/2023 |
12.0.18 | 153 | 5/4/2023 |
12.0.17 | 178 | 5/3/2023 |
12.0.16 | 196 | 4/30/2023 |
12.0.15 | 186 | 4/30/2023 |
12.0.13 | 192 | 4/27/2023 |
12.0.12 | 200 | 4/27/2023 |
12.0.10 | 262 | 4/15/2023 |
12.0.9 | 247 | 4/6/2023 |
12.0.8 | 249 | 3/27/2023 |
12.0.7 | 241 | 3/27/2023 |
12.0.3 | 238 | 3/22/2023 |
12.0.2 | 239 | 3/22/2023 |
12.0.1 | 272 | 3/1/2023 |
12.0.0 | 304 | 2/11/2023 |
11.1.10 | 288 | 2/11/2023 |
11.1.9 | 290 | 2/10/2023 |
11.1.8 | 289 | 2/6/2023 |
11.1.7 | 289 | 2/5/2023 |
11.1.6 | 301 | 2/4/2023 |
11.1.5 | 296 | 2/4/2023 |
11.1.4 | 334 | 12/30/2022 |
11.1.3 | 369 | 12/26/2022 |
11.1.2 | 314 | 12/26/2022 |
11.1.1 | 328 | 12/25/2022 |
11.0.0 | 321 | 12/24/2022 |
1.0.0 | 349 | 12/24/2022 |