Akka.Persistence.Query.Sql
1.5.27
Prefix Reserved
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
<PackageReference Include="Akka.Persistence.Query.Sql" Version="1.5.27" />
paket add Akka.Persistence.Query.Sql --version 1.5.27
#r "nuget: Akka.Persistence.Query.Sql, 1.5.27"
// 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
Akka.NET
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.
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
lock
s 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.
- Petabridge's Akka.NET Videos on YouTube
- ".NET Conf - When and How to Use the Actor Model An Introduction to Akka.NET Actors"
- Reactive Applications with Akka.NET
- Akka.NET Succinctly
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 | Versions 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. |
-
.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 |
|
Akka.Persistence.Sql.TestKit
Akka.NET TestKit for SQL-based ADO.NET Persistence middleware |
|
Akka.Persistence.PostgreSql.Hosting
Akka.Persistence.PostgreSql Microsoft.Extensions.Hosting support. |
|
Akka.Persistence.SqlServer.Hosting
Akka.Persistence.SqlServer Microsoft.Extensions.Hosting support. |
|
FAkka.Shared
Package Description |
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为主,一部分对以前案例进行升级,一部分将以前的工作经验总结出来,以供大家参考!
|
Version | Downloads | Last updated |
---|---|---|
1.5.28-beta1 | 80 | 8/23/2024 |
1.5.27.1 | 1,354 | 7/26/2024 |
1.5.27 | 74 | 7/25/2024 |
1.5.27-beta2 | 97 | 7/3/2024 |
1.5.27-beta1 | 87 | 7/3/2024 |
1.5.26 | 1,135 | 6/27/2024 |
1.5.25 | 495 | 6/14/2024 |
1.5.24 | 450 | 6/7/2024 |
1.5.23 | 139 | 6/6/2024 |
1.5.22 | 291 | 6/3/2024 |
1.5.21 | 1,901 | 5/28/2024 |
1.5.20 | 6,313 | 4/29/2024 |
1.5.19 | 442 | 4/15/2024 |
1.5.18 | 1,997 | 3/12/2024 |
1.5.17.1 | 582 | 3/2/2024 |
1.5.17 | 163 | 2/29/2024 |
1.5.16 | 5,103 | 1/29/2024 |
1.5.15 | 8,613 | 1/10/2024 |
1.5.14 | 3,413 | 11/3/2023 |
1.5.13 | 30,208 | 9/18/2023 |
1.5.13-beta1 | 196 | 8/25/2023 |
1.5.12 | 8,981 | 8/2/2023 |
1.5.11 | 406 | 7/27/2023 |
1.5.10 | 2,608 | 7/25/2023 |
1.5.9 | 646 | 7/17/2023 |
1.5.8 | 2,121 | 6/15/2023 |
1.5.7 | 1,107 | 5/17/2023 |
1.5.6 | 492 | 5/8/2023 |
1.5.5 | 388 | 5/4/2023 |
1.5.4 | 10,572 | 4/25/2023 |
1.5.3 | 721 | 4/20/2023 |
1.5.2 | 1,681 | 4/6/2023 |
1.5.1 | 1,954 | 3/15/2023 |
1.5.0 | 2,300 | 3/2/2023 |
1.5.0-beta6 | 417 | 3/1/2023 |
1.5.0-beta5 | 201 | 3/1/2023 |
1.5.0-beta4 | 299 | 2/28/2023 |
1.5.0-beta3 | 313 | 2/27/2023 |
1.5.0-beta2 | 242 | 2/23/2023 |
1.5.0-beta1 | 293 | 2/20/2023 |
1.5.0-alpha4 | 404 | 2/1/2023 |
1.5.0-alpha3 | 306 | 11/15/2022 |
1.5.0-alpha2 | 296 | 10/17/2022 |
1.5.0-alpha1 | 269 | 8/22/2022 |
1.4.51 | 336 | 6/28/2023 |
1.4.50 | 535 | 3/15/2023 |
1.4.49 | 5,242 | 1/27/2023 |
1.4.49-beta1 | 230 | 1/11/2023 |
1.4.48 | 14,845 | 1/5/2023 |
1.4.47 | 1,438 | 12/9/2022 |
1.4.46 | 4,390 | 11/15/2022 |
1.4.45 | 11,214 | 10/19/2022 |
1.4.44 | 842 | 10/17/2022 |
1.4.43 | 4,710 | 9/27/2022 |
1.4.42 | 1,376 | 9/23/2022 |
1.4.41 | 5,240 | 8/31/2022 |
1.4.40 | 17,134 | 7/22/2022 |
1.4.39 | 8,363 | 6/1/2022 |
1.4.38 | 2,419 | 5/6/2022 |
1.4.37 | 1,431 | 4/14/2022 |
1.4.36 | 8,263 | 4/5/2022 |
1.4.35 | 8,210 | 3/18/2022 |
1.4.34 | 5,901 | 3/7/2022 |
1.4.33 | 6,201 | 2/14/2022 |
1.4.32 | 3,018 | 1/18/2022 |
1.4.31 | 10,542 | 12/21/2021 |
1.4.30 | 698 | 12/20/2021 |
1.4.29 | 829 | 12/13/2021 |
1.4.28 | 4,741 | 11/10/2021 |
1.4.27 | 1,441 | 10/11/2021 |
1.4.26 | 1,673 | 9/28/2021 |
1.4.25 | 3,136 | 9/8/2021 |
1.4.24 | 2,035 | 8/17/2021 |
1.4.23 | 1,204 | 8/10/2021 |
1.4.22 | 1,357 | 8/5/2021 |
1.4.21 | 2,491 | 6/16/2021 |
1.4.21-beta1 | 546 | 6/4/2021 |
1.4.20 | 4,434 | 5/12/2021 |
1.4.19 | 2,029 | 4/28/2021 |
1.4.18 | 4,878 | 3/23/2021 |
1.4.17 | 1,453 | 3/10/2021 |
1.4.16 | 4,697 | 1/22/2021 |
1.4.15 | 1,220 | 1/20/2021 |
1.4.14 | 2,163 | 12/30/2020 |
1.4.13 | 1,294 | 12/16/2020 |
1.4.12 | 2,404 | 11/16/2020 |
1.4.11 | 1,670 | 11/5/2020 |
1.4.10 | 4,756 | 8/20/2020 |
1.4.9 | 12,262 | 7/21/2020 |
1.4.8 | 5,317 | 6/17/2020 |
1.4.7 | 2,762 | 5/27/2020 |
1.4.6 | 1,990 | 5/12/2020 |
1.4.5 | 1,994 | 4/29/2020 |
1.4.4 | 2,046 | 3/31/2020 |
1.4.3 | 1,868 | 3/18/2020 |
1.4.2 | 1,243 | 3/13/2020 |
1.4.1 | 1,144 | 3/11/2020 |
1.4.1-rc3 | 700 | 3/10/2020 |
1.4.1-rc2 | 646 | 3/10/2020 |
1.4.1-rc1 | 779 | 2/28/2020 |
1.4.0-beta4 | 817 | 1/28/2020 |
1.4.0-beta3 | 1,084 | 10/30/2019 |
1.4.0-beta2 | 734 | 9/23/2019 |
1.4.0-beta1 | 728 | 7/19/2019 |
1.3.19 | 101 | 5/2/2024 |
1.3.18 | 7,173 | 3/9/2020 |
1.3.17 | 2,939 | 12/20/2019 |
1.3.16 | 8,681 | 11/14/2019 |
1.3.15 | 5,188 | 9/23/2019 |
1.3.14 | 5,764 | 7/30/2019 |
1.3.13 | 15,454 | 4/30/2019 |
1.3.12 | 14,267 | 3/14/2019 |
1.3.11 | 7,739 | 12/18/2018 |
1.3.10 | 70,948 | 11/2/2018 |
1.3.9 | 6,965 | 8/23/2018 |
1.3.8 | 3,726 | 6/5/2018 |
1.3.7 | 2,362 | 5/15/2018 |
1.3.6 | 2,337 | 4/17/2018 |
1.3.5 | 4,840 | 2/22/2018 |
1.3.4 | 2,605 | 2/1/2018 |
1.3.3 | 1,994 | 1/19/2018 |
1.3.2 | 6,282 | 10/21/2017 |
1.3.1 | 6,225 | 9/5/2017 |
1.3.0 | 3,488 | 8/11/2017 |
1.2.3.43-beta | 1,877 | 7/10/2017 |
1.2.3.41-beta | 1,070 | 7/10/2017 |
1.2.2.40-beta | 1,486 | 6/28/2017 |
1.2.2.39-beta | 1,062 | 6/28/2017 |
1.2.1.38-beta | 1,299 | 6/23/2017 |
1.2.1.37-beta | 1,035 | 6/23/2017 |
1.2.0.36-beta | 2,681 | 4/13/2017 |
1.2.0.35-beta | 1,067 | 4/13/2017 |
1.2.0.34-beta | 1,050 | 4/12/2017 |
1.2.0.33-beta | 1,079 | 4/12/2017 |
1.1.3.32-beta | 4,452 | 1/23/2017 |
1.1.3.31-beta | 1,110 | 1/23/2017 |
1.1.2.30-beta | 1,770 | 9/22/2016 |
1.1.2.29-beta | 1,383 | 9/22/2016 |
1.1.1.28-beta | 1,195 | 7/16/2016 |
1.1.1.27-beta | 1,150 | 7/16/2016 |
1.1.0.26-beta | 1,134 | 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 |