Akka.Persistence.Query.Sql 1.5.27

Prefix Reserved

There is a newer version of this package available.
See the version list below for details.

dotnet add package Akka.Persistence.Query.Sql --version 1.5.27

NuGet\Install-Package Akka.Persistence.Query.Sql -Version 1.5.27

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="Akka.Persistence.Query.Sql" Version="1.5.27" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add Akka.Persistence.Query.Sql --version 1.5.27

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Akka.Persistence.Query.Sql, 1.5.27"

#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 Akka.Persistence.Query.Sql as a Cake Addin
#addin nuget:?package=Akka.Persistence.Query.Sql&version=1.5.27

// Install Akka.Persistence.Query.Sql as a Cake Tool
#tool nuget:?package=Akka.Persistence.Query.Sql&version=1.5.27

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Akka.NET

Akka.NET logo

Akka.NET is a .NET port of the popular Akka project from the Scala / Java community. We are an idiomatic .NET implementation of the actor model built on top of the .NET Common Language Runtime.

Website: https://getakka.net/
Twitter 🐦: AkkaDotNet
Discussions 📣: Akka.NET GitHub Discussions
Chat 💬: Akka.NET on Discord
StackOverflow ✔️: Akka.NET on StackOverflow

Akka.NET is a .NET Foundation project.

.NET Foundation Logo

How is Akka.NET Used?

Akka.NET can be used in-process or inside large, distributed real-time systems; we support a wide variety of use cases.

Akka.NET can be used to solve the following types of problems:

Concurrency - Akka.NET actors only process messages one-at-a-time and they do so in first in, first out (FIFO) order; this means that any application state internal to an actor is automatically thread-safe without having to use locks or any other shared-memory synchronization mechanisms.
Stream Processing - Akka.NET actors and Akka.Streams make it easy to build streaming applications, used for processing incoming streams of data or incoming streams of live events such as UI or network events inside native applications.
Event-Driven Programming - actors make it easy to build event-driven applications, as actors' message-processing routines naturally express these types of designs.
Event Sourcing and CQRS - Akka.Persistence, used by actors to make their state re-entrant and recoverable across restarts or migrations between nodes, natively supports event sourcing. Akka.Persistence.Query can be used to compute CQRS-style projections and materialized views from Akka.Persistence data.
Location Transparency - Akka.Remote makes it simple for actors in remote processes to transparently communicate with each other.
Highly Available, Fault-Tolerant Distributed Systems - Akka.Cluster, Akka.Cluster.Sharding, and other tools built on top of Akka.Cluster make it possible to build highly available and fault-tolerant distributed systems by leveraging peer-to-peer programming models with topology-aware message routing and distribution.
Low Latency, High Throughput - Akka.NET aims to be low latency and high throughput, processing 10s millions of messages per second in-memory and hundreds of thousands of messages per second over remote connections.

Where Can I Learn Akka.NET?

You can start by taking the Akka.NET Bootcamp, but there are many other great learning resources for Akka.NET Online.

Build Status

Stage	Status
Build
NuGet Pack
.NET Framework Unit Tests
.NET 7 Unit Tests (Windows)
.NET 7 Unit Tests (Linux)
.NET 7 MultiNode Tests (Windows)
.NET 7 MultiNode Tests (Linux)
Docs

Install Akka.NET via NuGet

If you want to include Akka.NET in your project, you can install it directly from NuGet

To install Akka.NET Distributed Actor Framework, run the following command in the Package Manager Console

PM> Install-Package Akka.Hosting

Akka.Hosting includes the base Akka NuGet package and also provides an easy interface to integrate Akka.NET with the most-used parts of the Microsoft.Extensions ecosystem: Configuration, Logging, Hosting, and DependencyInjection. We encourage developers to adopt it.

And if you need F# support:

PM> Install-Package Akka.FSharp

Akka.NET Project Templates

To create your own Akka.NET projects using our templates (Akka.Templates), install them via the dotnet CLI:

dotnet new install "Akka.Templates::*"

This will make our templates available via dotnet new on the CLI and as new project templates inside any .NET IDE such as Visual Studio or JetBrains Rider. You can view the full list of templates included in our package here: https://github.com/akkadotnet/akkadotnet-templates#available-templates

Builds

Please see Building Akka.NET.

To access nightly Akka.NET builds, please see the instructions here.

Support

If you need help getting started with Akka.NET, there's a number of great community resources online:

Subscribe to the Akka.NET project feed on Twitter: https://twitter.com/AkkaDotNet (@AkkaDotNet)
Join the Akka.NET Discord: https://discord.gg/GSCfPwhbWP
Ask Akka.NET questions on Stack Overflow: http://stackoverflow.com/questions/tagged/akka.net

If you and your company are interested in getting professional Akka.NET support, you can contact Petabridge for dedicated Akka.NET support.

Product	Compatible and additional computed target framework versions.
.NET	net5.0 was computed. net5.0-windows was computed. 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 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	netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed.
.NET Standard	netstandard2.0 is compatible. netstandard2.1 was computed.
.NET Framework	net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed.
MonoAndroid	monoandroid was computed.
MonoMac	monomac was computed.
MonoTouch	monotouch was computed.
Tizen	tizen40 was computed. 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)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

.NETStandard 2.0
- Akka.Persistence (>= 1.5.27)
- Akka.Persistence.Query (>= 1.5.27)
- Akka.Persistence.Sql.Common (>= 1.5.27)
net6.0
- Akka.Persistence (>= 1.5.27)
- Akka.Persistence.Query (>= 1.5.27)
- Akka.Persistence.Sql.Common (>= 1.5.27)

NuGet packages (8)

Showing the top 5 NuGet packages that depend on Akka.Persistence.Query.Sql:

Package	Downloads
wyvern.entity Package Description	165.2K
Akka.Persistence.Sql.TestKit Akka.NET TestKit for SQL-based ADO.NET Persistence middleware	106.4K
Akka.Persistence.PostgreSql.Hosting Akka.Persistence.PostgreSql Microsoft.Extensions.Hosting support.	51.3K
Akka.Persistence.SqlServer.Hosting Akka.Persistence.SqlServer Microsoft.Extensions.Hosting support.	38.0K
FAkka.Shared Package Description	7.3K

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on Akka.Persistence.Query.Sql:

Repository	Stars
axzxs2001/Asp.NetCoreExperiment 原来所有项目都移动到OleVersion目录下进行保留。新的案例装以.net 5.0为主，一部分对以前案例进行升级，一部分将以前的工作经验总结出来，以供大家参考！	353

Version	Downloads	Last updated
1.5.31	530	11/11/2024
1.5.30	3,825	10/3/2024
1.5.29	262	10/1/2024
1.5.28	1,671	9/4/2024
1.5.28-beta1	123	8/23/2024
1.5.27.1	3,356	7/26/2024
1.5.27	108	7/25/2024
1.5.27-beta2	134	7/3/2024
1.5.27-beta1	121	7/3/2024
1.5.26	1,698	6/27/2024
1.5.25	531	6/14/2024
1.5.24	516	6/7/2024
1.5.23	173	6/6/2024
1.5.22	343	6/3/2024
1.5.21	2,230	5/28/2024
1.5.20	14,325	4/29/2024
1.5.19	483	4/15/2024
1.5.18	2,028	3/12/2024
1.5.17.1	634	3/2/2024
1.5.17	204	2/29/2024
1.5.16	6,258	1/29/2024
1.5.15	11,301	1/10/2024
1.5.14	4,091	11/3/2023
1.5.13	35,872	9/18/2023
1.5.13-beta1	228	8/25/2023
1.5.12	10,137	8/2/2023
1.5.11	439	7/27/2023
1.5.10	2,952	7/25/2023
1.5.9	678	7/17/2023
1.5.8	2,553	6/15/2023
1.5.7	1,137	5/17/2023
1.5.6	524	5/8/2023
1.5.5	432	5/4/2023
1.5.4	10,656	4/25/2023
1.5.3	776	4/20/2023
1.5.2	1,751	4/6/2023
1.5.1	2,044	3/15/2023
1.5.0	2,428	3/2/2023
1.5.0-beta6	469	3/1/2023
1.5.0-beta5	231	3/1/2023
1.5.0-beta4	354	2/28/2023
1.5.0-beta3	385	2/27/2023
1.5.0-beta2	277	2/23/2023
1.5.0-beta1	327	2/20/2023
1.5.0-alpha4	464	2/1/2023
1.5.0-alpha3	336	11/15/2022
1.5.0-alpha2	330	10/17/2022
1.5.0-alpha1	304	8/22/2022
1.4.51	385	6/28/2023
1.4.50	571	3/15/2023
1.4.49	5,452	1/27/2023
1.4.49-beta1	261	1/11/2023
1.4.48	17,049	1/5/2023
1.4.47	1,478	12/9/2022
1.4.46	4,445	11/15/2022
1.4.45	11,440	10/19/2022
1.4.44	868	10/17/2022
1.4.43	5,260	9/27/2022
1.4.42	1,407	9/23/2022
1.4.41	5,295	8/31/2022
1.4.40	18,266	7/22/2022
1.4.39	8,530	6/1/2022
1.4.38	2,460	5/6/2022
1.4.37	1,461	4/14/2022
1.4.36	8,411	4/5/2022
1.4.35	8,427	3/18/2022
1.4.34	5,950	3/7/2022
1.4.33	6,232	2/14/2022
1.4.32	3,098	1/18/2022
1.4.31	10,603	12/21/2021
1.4.30	727	12/20/2021
1.4.29	868	12/13/2021
1.4.28	4,792	11/10/2021
1.4.27	1,488	10/11/2021
1.4.26	1,703	9/28/2021
1.4.25	3,168	9/8/2021
1.4.24	2,069	8/17/2021
1.4.23	1,247	8/10/2021
1.4.22	1,387	8/5/2021
1.4.21	2,574	6/16/2021
1.4.21-beta1	576	6/4/2021
1.4.20	4,471	5/12/2021
1.4.19	2,081	4/28/2021
1.4.18	4,921	3/23/2021
1.4.17	1,481	3/10/2021
1.4.16	4,725	1/22/2021
1.4.15	1,253	1/20/2021
1.4.14	2,201	12/30/2020
1.4.13	1,320	12/16/2020
1.4.12	2,436	11/16/2020
1.4.11	1,698	11/5/2020
1.4.10	4,785	8/20/2020
1.4.9	12,426	7/21/2020
1.4.8	5,373	6/17/2020
1.4.7	2,801	5/27/2020
1.4.6	2,038	5/12/2020
1.4.5	2,043	4/29/2020
1.4.4	2,087	3/31/2020
1.4.3	1,913	3/18/2020
1.4.2	1,271	3/13/2020
1.4.1	1,183	3/11/2020
1.4.1-rc3	731	3/10/2020
1.4.1-rc2	693	3/10/2020
1.4.1-rc1	834	2/28/2020
1.4.0-beta4	858	1/28/2020
1.4.0-beta3	1,113	10/30/2019
1.4.0-beta2	762	9/23/2019
1.4.0-beta1	755	7/19/2019
1.3.19	145	5/2/2024
1.3.18	7,229	3/9/2020
1.3.17	2,988	12/20/2019
1.3.16	8,742	11/14/2019
1.3.15	5,236	9/23/2019
1.3.14	5,876	7/30/2019
1.3.13	16,020	4/30/2019
1.3.12	14,632	3/14/2019
1.3.11	7,793	12/18/2018
1.3.10	72,332	11/2/2018
1.3.9	7,026	8/23/2018
1.3.8	3,812	6/5/2018
1.3.7	2,417	5/15/2018
1.3.6	2,394	4/17/2018
1.3.5	4,899	2/22/2018
1.3.4	2,662	2/1/2018
1.3.3	2,053	1/19/2018
1.3.2	6,334	10/21/2017
1.3.1	6,259	9/5/2017
1.3.0	3,526	8/11/2017
1.2.3.43-beta	1,929	7/10/2017
1.2.3.41-beta	1,102	7/10/2017
1.2.2.40-beta	1,532	6/28/2017
1.2.2.39-beta	1,082	6/28/2017
1.2.1.38-beta	1,337	6/23/2017
1.2.1.37-beta	1,070	6/23/2017
1.2.0.36-beta	2,728	4/13/2017
1.2.0.35-beta	1,103	4/13/2017
1.2.0.34-beta	1,085	4/12/2017
1.2.0.33-beta	1,114	4/12/2017
1.1.3.32-beta	4,483	1/23/2017
1.1.3.31-beta	1,153	1/23/2017
1.1.2.30-beta	1,832	9/22/2016
1.1.2.29-beta	1,422	9/22/2016
1.1.1.28-beta	1,237	7/16/2016
1.1.1.27-beta	1,179	7/16/2016
1.1.0.26-beta	1,166	7/7/2016

Akka.NET v1.5.27 is a significant release that includes new features, mission-critical bug fixes, and some performance improvements.
Major Akka.Cluster.Sharding and Akka.Cluster.Tools.Singleton Bug Fixes**
In _all prior versions_ of Akka.NET, there are two high impact distributed systems bugs:
1. [Akka.Cluster.Tools.Singleton: singleton moves earlier than expected - as soon as new node joins](https://github.com/akkadotnet/akka.net/issues/7196)
2. [Akka.Cluster.Sharding: duplicate shards / entities](https://github.com/akkadotnet/akka.net/issues/6973)
As we discovered during the course of our pains-taking bug investigation, these were, in fact, the same issue:
1. The `ClusterSingletonManager` is supposed to _always_ belong on the oldest node of a given role type, but an original design error from the time Akka.Cluster.Tools was first introduced to Akka.NET meant that nodes were always sorted in _descending_ order of `UpNumber`. This is backwards: nodes should always be sorted in _ascending_ order of `UpNumber` - this means that the oldest possible node is always at the front of the "who is oldest?" list held by the `ClusterSingletonManager`. This explains why the singleton could appear to move early during deployments and restarts.
2. The `ClusterSingletonManager` was suspectible to a race condition where if nodes were shutdown and restarted with the same address in under 20 seconds, the default "down removal margin" used by the `ClusterSingletonManager` to tolerate dirty exits, it would be possible after _multiple_ successive, fast, restarts for multiple instances of the singleton to be alive at the same time (for a short period.)
Both of these varieties of problem, duplicate singletons, is what lead to duplicate shards.
As a result we've made the following fixes:
[Akka.Cluster.Tools: deprecate ClustersSingletonManagerSettings.ConsiderAppVersion](https://github.com/akkadotnet/akka.net/pull/7302) - `AppVersion` is no longer considered for singleton placement as it could easily result in split brains.
[Akka.Cluster.Tools: fix mutability and oldest state bugs with `ClusterSingletonManager`](https://github.com/akkadotnet/akka.net/pull/7298) - resolves the issue with rapid rolling restarts creating duplicates. We've tested this fix in our test lab across thousands of coordinator restarts and haven't been able to reproduce the issue since (we could easily do it before.)
[Akka.Cluster.Tools.Singleton / Akka.Cluster.Sharding: fix duplicate shards caused by incorrect `ClusterSingletonManager` `HandOver`](https://github.com/akkadotnet/akka.net/pull/7297) - we fixed the member age problem here, which could cause a second singleton to start at inappropriate times.
Akka.Discovery and `ClusterClient` Discovery Support**
In Akka.NET v1.5.27 we've added support for using Akka.Cluster.Tools.ClusterClient alongside with [Akka.Discovery plugins](https://getakka.net/articles/discovery/index.html) to automatically discover the initial contacts you need for `ClusterClientReceptionist` instances in your environment.
You can read the documentation for how this works here: https://getakka.net/articles/clustering/cluster-client.html#contact-auto-discovery-using-akkadiscovery
Related PRs and issues:
[Akka.Discovery: Add multi-config support to config-based discovery](https://github.com/akkadotnet/akka.net/issues/7271)
[Cluster.Tools: Fix missing VerboseLogging in ClusterClientSettings.Copy method](https://github.com/akkadotnet/akka.net/issues/7272)
[Cluster.Tools: Improve ClusterClientDiscovery to avoid thundering herd problem](https://github.com/akkadotnet/akka.net/issues/7270)
[Cluster.Tools: Change ClusterClientDiscovery to use the new Akka.Management "/cluster-client/receptionist" endpoint](https://github.com/akkadotnet/akka.net/issues/7274)
Other Bug Fixes and Improvements**
[Akka.Cluster: improve gossip serialization performance](https://github.com/akkadotnet/akka.net/pull/7281)
[Akka.Streams: Fix `ActorMaterializerImpl` `null` `LogSource`](https://github.com/akkadotnet/akka.net/pull/7300)
[Akka.Streams: `AlsoTo` may not be failing graph when its sink throws exception](https://github.com/akkadotnet/akka.net/issues/7269)
[Akka.DistributedData: if `lmdb.dir` is null or empty, log a warning and set to default](https://github.com/akkadotnet/akka.net/pull/7292)
To [see the full set of changes in Akka.NET v1.5.27, click here](https://github.com/akkadotnet/akka.net/milestone/109).
| COMMITS | LOC+ | LOC- | AUTHOR |
| --- | --- | --- | --- |
| 15 | 835 | 1001 | Aaron Stannard |
| 12 | 1123 | 207 | Gregorius Soedharmo |