public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>()

IoT / Desktop · Industrial IoT

O3 Edge: Industrial IoT Analytics

A desktop application for real-time industrial analytics and data ingestion from factory equipment.

// outcome

Reliable machine-to-system data ingestion

The challenge

Industrial machines spoke different protocols, making real-time analytics and integration difficult.

What I built

I helped design and maintain the O3 Edge desktop app for real-time analytics, integrating Kepware Server over OPC UA/DA, MQTT-based messaging, and rapid IoT workflow prototyping with Node-RED.

The result

Reliable machine-to-system communication and a lightweight in-house service that reduced infrastructure overhead while improving industrial insight.

£ cat stack.json

.NET
OPC UA/DA
Kepware
MQTT
Node-RED

Want something similar built?

let's talk