SonnetDB 是由 IoTSharp 团队开源、基于 C#/.NET 构建的高性能嵌入式多模型数据库(以时序数据为核心),支持关系表、KV、JSON 文档、向量检索及全文搜索,专为 IoT、工业边缘计算和 AI 场景设计,可进程内嵌入运行也可作为独立服务部署。
using SonnetDB.Engine;
using SonnetDB.Sql.Execution;
using var db = Tsdb.Open(new TsdbOptions
{
RootDirectory = "./demo-data",
});
SqlExecutor.Execute(db, """
CREATE MEASUREMENT cpu (
host TAG,
usage FIELD FLOAT
)
""");
SqlExecutor.Execute(db, """
INSERT INTO cpu (time, host, usage)
VALUES
(1713676800000, 'server-01', 0.71),
(1713676860000, 'server-01', 0.73)
""");
var result = (SelectExecutionResult)SqlExecutor.Execute(
db,
"SELECT time, host, usage FROM cpu WHERE host = 'server-01'")!;
foreach (var row in result.Rows)
{
Console.WriteLine($"{row[0]} {row[1]} {row[2]}");
}
插入1亿条数据,时间大概30秒不到
using SonnetDB.Engine;
using SonnetDB.Model;
using SonnetDB.Sql.Execution;
using System.Diagnostics;
using var db = Tsdb.Open(new TsdbOptions
{
RootDirectory = "./demo-data",
});
SqlExecutor.Execute(db, "CREATE MEASUREMENT cpu (host TAG, usage FIELD FLOAT)");
var sw= Stopwatch.StartNew();
List<Point> points = [];
Random random = new Random();
for (long i = 0; i < 1000 * 1000 * 100; i++)
{
Point.Create(
"cpu",
i,
new Dictionary<string, string> { ["host"] = "server-01" },
new Dictionary<string, FieldValue> { ["usage"] = FieldValue.FromDouble(random.Next()) });
}
db.WriteMany(points);
Console.WriteLine(sw.Elapsed.ToString());
查询数据
using SonnetDB; // 引入命名空间
// 1. 创建或打开一个数据库实例(基于文件)
// 嵌入式设计,直接指定文件路径即可
var db = new SonnetDB("my_data.db");
// 2. 写入一条遥测数据
db.Write(new Telemetry
{
DeviceId = "sensor-001",
Timestamp = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds(),
Value = 23.5
});
// 3. 使用 LINQ 进行原生查询
var startTime = DateTimeOffset.UtcNow.AddHours(-1).ToUnixTimeMilliseconds();
var endTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
var results = db.Query<Telemetry>()
.Where(t => t.DeviceId == "sensor-001")
.Where(t => t.Timestamp >= startTime && t.Timestamp <= endTime)
.ToList();
// 4. 使用 LINQ 进行聚合查询,获取每日平均温度
var dailyAvg = db.Query<Telemetry>()
.Where(t => t.DeviceId == "sensor-001" && t.Timestamp >= startTime && t.Timestamp <= endTime)
.GroupBy(t => t.Timestamp.Date)
.Select(g => new { Date = g.Key, Avg = g.Average(x => x.Value) })
.ToList();
使用 Span 实现零拷贝读取
SonnetDB 使用 100% 托管代码,通过 Span 等现代 C# 特性实现内存安全且高效的数据访问。
// SonnetDB 内部运用 Span<T> 进行高效的二进制数据解析
public readonly struct DataPoint
{
public long Timestamp { get; }
public double Value { get; }
public DataPoint(ReadOnlySpan<byte> buffer)
{
// 安全地解析二进制数据,避免了 unsafe 代码
Timestamp = BinaryPrimitives.ReadInt64LittleEndian(buffer.Slice(0, 8));
Value = BitConverter.ToDouble(buffer.Slice(8, 8));
}
}
在 IoTSharp 生态中集成
如果你是 IoTSharp 用户,SonnetDB 能无缝替代 InfluxDB 等数据库,作为平台的时序存储层。它的高性能和嵌入式特性非常适合边缘计算场景,可在工业边缘网关上本地缓存数据,实现离线数据不丢失。
// 在设备端直接嵌入 SonnetDB,实现轻量级本地存储
var db = new SonnetDB("edge_gateway.db");
// 采集传感器数据并写入
foreach(var sensorData in edgeGateway.GetSensorData())
{
db.Write(sensorData);
}