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);  
}

标签: none

添加新评论