QuestDB.Change.Tracker.Api
1.2.2.1
dotnet add package QuestDB.Change.Tracker.Api --version 1.2.2.1
NuGet\Install-Package QuestDB.Change.Tracker.Api -Version 1.2.2.1
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="QuestDB.Change.Tracker.Api" Version="1.2.2.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="QuestDB.Change.Tracker.Api" Version="1.2.2.1" />
<PackageReference Include="QuestDB.Change.Tracker.Api" />
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 QuestDB.Change.Tracker.Api --version 1.2.2.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: QuestDB.Change.Tracker.Api, 1.2.2.1"
#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 QuestDB.Change.Tracker.Api@1.2.2.1
#: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=QuestDB.Change.Tracker.Api&version=1.2.2.1
#tool nuget:?package=QuestDB.Change.Tracker.Api&version=1.2.2.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
QuestDB.Change.Tracker.Api
1. Requirements
- V2 format of the QuestDB table.
To achive this, please add to the server.conf:
cairo.default.sequencer.part.txn.count=50000
It has to be a value greater than 1, otherwise the change tracking will not work.
In case of any issues please follow:
https://community.questdb.com/t/null-for-mintimestamp-maxtimestamp-and-rowcount/994
2. Usage
It is meant as a detector running i.e. as a background service. Example of the execution:
// given
var connectionFactory = new NpgsqlConnectionFactory(
host: "127.0.0.1",
port: 8812,
username: "admin",
password: "quest",
database: "qdb"
);
var tracker = new TrackChangesEngine(connectionFactory);
tracker.OnChange += async (args) =>
{
// then
// inform via hub etc...
// save to DB etc...
};
// when
var cts = new CancellationTokenSource();
await Task.Run(() =>
tracker.TrackAsync(
tableName: "123",
columns: "TM5_10",
rowThreshold: 1,
checkIntervalInSeconds: 1,
timestampColumn: "timestamp",
trackingTable: "trackingTable",
trackingId: Guid.NewGuid().ToString(),
ct: cts.Token
)
);
Co-author
- GitHub Copilot
| Product | Versions 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 was computed. 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 was computed. 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.
-
net8.0
- Npgsql (>= 8.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.