SqliteCache 8.0.0

Full Changelog: 7.0.2...8.0.0

SqliteCache 7.0.2

Full Changelog: 7.0.1...7.0.2

SqliteCache 7.0.1

Full Changelog: 7.0.0...7.0.1

SqliteCache 7.0.0

Full Changelog: 7.0.0-preview1...7.0.0

SqliteCache 7.0.0-preview1

What's New

• SqliteCache v7.0.0 will be the first release without a direct dependency on SQLitePCLRaw.bundle_green, meaning it can be used more easily in cross-platform projects or projects with native targets or targeting mobile devices. This may be a breaking change depending on how you are using SqliteCache.
  • The majority of users are installing SqliteCache in the context of an ASP.NET Core project - there are no changes required here since the ASP.NET Core code automatically pulls in SQLitePCLRaw.bundle_green as a dependency and calls SQLitePCL.Batteries_V2.Init().
  • If you are targeting desktop Windows/Linux/macOS you can do the same and install SQLitePCLRaw.bundle_green via nuget, then make a call to SQLitePCL.Batteries_V2.Init() before calling or using SqliteCache.
  • If you are targeting a mobile platform or using a platform-provided native SQLite library (such as on iOS, UWP, Android, etc) you will need to install the correct SQLitePCLRaw.provider.xxx nuget library that matches your target platform, then make a call to SQLitePCL.raw.SetProvider(new SQLitePCL.Sqlite3Provider_xxx()) before calling or using SqliteCache. More info is available on the SQLitePCL.raw site.
• The Microsoft infrastructure dependencies providing the abstract caching class this project is implemented against and DI support have been upgraded to version 7.0. These should be backwards compatible with the v6 sources but the dependency is coded such that it's required to upgrade your copy of these packages (should happen automatically via nuget). You do not need to upgrade to .NET 7.0
• A .NET 7.0 build of this library has been generated and uploaded to nuget so .NET 7 users can get .NET 7 throughout their stack.

SqliteCache 6.1.0

What's Changed

• New methods to clear the cache (SqliteCache.Clear() and SqliteCache.ClearAsync()) by @Msurrow in #15
• Now compatible with SQLite builds compiled with SQLITE_DSQ=0 (double-quoting vs single-quoting issue, #12)
• SQLitePCLRaw updated

New Contributors

• @AntonyCorbett made their first contribution in #7
• @Msurrow made their first contribution in #15

Full Changelog: 6.0.1...6.1.0

6.0.1: SqliteCache v6.0

• WAL mode and normal synchronization pragmas are set at startup, dramatically improving performance
• ILogger constructor parameter is now optional
• A separate SqliteConnection is used for each SqlCommand instance, fixing threading issues under UWP
• Makes it possible to inject SqliteCache directly (rather than only as IDistributedCache)
• Adds IAsyncDisposable implementation for .NET Core 3.1 and above
• Adds a bulk insert option to insert many key-value pairs quickly (credit to first-time contributor Elias Baumgartner aka @Rap22tor)
• Fixes an issue w/ incorrect handling of user-specified non-UTC expiration dates (credit to first-time contributor Ravindu Liyanapathirana, aka @ravindUwU)

Version 6.0.1 corrects issues with the wrong git patches being included in 6.0.0

Download on Nuget: https://www.nuget.org/packages/NeoSmart.Caching.Sqlite/

Or install manually:

Install-Package NeoSmart.Caching.Sqlite -Version 6.0.1

SQLiteCache 5.0.2

• WAL mode and normal synchronization pragmas are set at startup, dramatically improving performance
• ILogger constructor parameter is now optional
• A separate SqliteConnection is used for each SqlCommand instance, fixing threading issues under UWP
• Makes it possible to inject SqliteCache directly (rather than only as IDistributedCache)
• Adds IAsyncDisposable implementation for .NET Core 3.1 and above
• Adds a bulk insert option to insert many key-value pairs quickly (credit to first-time contributor Elias Baumgartner aka @Rap22tor)
• Fixes an issue w/ incorrect handling of user-specified non-UTC expiration dates (credit to first-time contributor Ravindu Liyanapathirana, aka @ravindUwU)

Version 5.0.2 corrects issues with the wrong git patches being included in 5.0.0/5.0.1

Download on Nuget: https://www.nuget.org/packages/NeoSmart.Caching.Sqlite/

Or install manually:

Install-Package NeoSmart.Caching.Sqlite -Version 5.0.2

NeoSmart.Caching.SQLite 5.0-preview3

• WAL mode and normal synchronization pragmas are set at startup,
  dramatically improving performance
• ILogger constructor parameter is now optional
• A separate SqliteConnection is used for each SqlCommand instance,
  fixing threading issues under UWP
• Make it possible to inject SqliteCache directly (rather than only as
  IDistributedCache)
• Add IAsyncDisposable implementation for .NET Core 3.1 and above
• Add a bulk insert option to insert many key-value pairs quickly
  (credit to first-time contributor Elias Baumgartner aka @Rap22tor)

Full Changelog: 3.1.1...5.0-preview3

Available on nuget as NeoSmart.Caching.SQLite 5.0-preview3