ZeroUI.Historian.Sqlite
1.10.1
dotnet add package ZeroUI.Historian.Sqlite --version 1.10.1
NuGet\Install-Package ZeroUI.Historian.Sqlite -Version 1.10.1
<PackageReference Include="ZeroUI.Historian.Sqlite" Version="1.10.1" />
<PackageVersion Include="ZeroUI.Historian.Sqlite" Version="1.10.1" />
<PackageReference Include="ZeroUI.Historian.Sqlite" />
paket add ZeroUI.Historian.Sqlite --version 1.10.1
#r "nuget: ZeroUI.Historian.Sqlite, 1.10.1"
#:package ZeroUI.Historian.Sqlite@1.10.1
#addin nuget:?package=ZeroUI.Historian.Sqlite&version=1.10.1
#tool nuget:?package=ZeroUI.Historian.Sqlite&version=1.10.1
ZeroUI β‘
Ultra-High-Performance, Zero-Allocation Industrial UI & Runtime Ecosystem for .NET (WinForms, WPF, .NET 8/9 & Edge)
πΈ Interactive Live Showcase
| β‘ 1,000,000 Rows Smooth Virtual Scroll (Zero-Alloc) | π¨ Creative & Media Editors Suite |
|---|---|
| π Excel-Style Column Distinct Filter Header (v1.8.1) | π SCADA Closed-Loop Workcell |
|---|---|
β‘ Performance Benchmarks: ZeroUI Grid vs Native Controls
Headless and interactive stress-test verified on .NET 8.0 (x64, Intel Core i7 / 144Hz):
| Metric | Standard DataGridView / WPF DataGrid | ZeroUI (GridControl / ZeroGridControl) |
Real-World Advantage |
|---|---|---|---|
| 100K Rows Viewport Compute | ~7,400 FPS (0.135 ms) | 24,716 FPS (0.040 ms) | 3.3x Higher Throughput |
| Hot Render Path GC Allocations | Thousands of temporary cell objects | 0 B (Zero-Alloc) | 100% Zero GC Pauses |
| 1,000,000 Rows Continuous Scrolling | Frequent frame drops & stutter | Rock-solid 144 FPS | Silky-smooth UX |
| 10,000,000 Rows Capacity | Crash / OutOfMemoryException | 179 MB RAM (7 ms setup) | Limitless Scale |
| 1,000,000 Rows Instant Filter | > 850 ms (UI locks) | 34 ms | 25x Faster |
| Streaming CSV Export (100K rows) | ~1,200 ms | 145 ms (688,000 rows/sec) | 8x Faster |
π Executive Summary
ZeroUI is an enterprise-grade industrial automation UI suite and runtime engine. Engineered to overcome the severe handle leaks, garbage collection pauses, and screen flicker common in standard desktop controls, ZeroUI renders millions of rows and real-time telemetry at 60 FPS with zero managed memory allocations.
Core Architectural Pillars
- Strictly Zero Allocation (
Zero-Alloc): Hot render loops generate 0 bytes of GC churn usingSpan<T>,ArrayPool<T>, and unmanaged DIBSection memory buffers. - Single-HWND Architecture: Composite controls maintain 1 Win32 window handle, completely eliminating OS handle exhaustion crashes (10,000 handle limit) and window flicker.
- Win32 Memory DC DIBSection Engine: Offscreen unmanaged double buffering with zero-copy
BitBltpresentation (100% resilient across RDP and virtual machines). - Enterprise Dual-Runtime Support: Full native compatibility with .NET Framework 4.6.2 as well as modern .NET 8.0 / 9.0.
- Unified Theme Engine: Instant reactive switching between Obsidian Dark Mode (
#12151C) and Clean Light Mode across all controls. - Interactive Guided Tour & Onboarding Engine (v1.10.0): Native spotlight aperture cutout masking (
Region.Exclude/CombinedGeometry.Exclude), semi-transparent glass backdrop dimming, collision-free adaptive popovers, and full keyboard navigation across WinForms and WPF (ZTour). - Specialized Creative & Forensic Inspection Media Suite (v1.10.0): High-performance vector defect tagging with direct bitmap burning (
ZAnnotationCanvas), optical precision metrology caliper (ZMeasurementRuler), dynamic screen-capture security stamps (ZWatermarkOverlay), GPU-accelerated video playback (ZVideoPlayer), symmetrical audio waveform scrubbers (ZAudioWaveform), and document straightening/binarization (ZDocumentDeskew). - Specialized Analytics & Business Charts Suite (v1.9.0): Clean Architecture with 100% platform-neutral mathematical engines in
ZeroUI.Core.Analyticsand lightweight hardware rendering layers for WinForms and WPF (HistogramChart,ScatterChart,SunburstChart,LollipopChart,TreemapChart,SankeyChart,BulletChart,ParetoChart). - Creative & Media Controls Suite (v1.8.0 / v1.9.1): Direct-rendered, high-performance visual editors for digital imaging, raw photography, inspection, and video grading cleanly segregated in
ZeroUI.Wpf.MediaandZeroUI.WinForms.Media(ZImageViewer,ZPictureEdit,ZCurveEditor,ZColorWheel,ZCompareViewer,ZHistogramScope,ZCropBox,ZMiniMapNavigator,ZMaskGizmoOverlay,ZHistoryTimeline,ZFilmstripScroller,ZDominantPalette,ZExifTelemetryCard,ZBatchTaskQueue,ZThumbnailGrid,ZTokenPatternEditor). - High-Performance Interactive Media Subsystem (v1.9.1): Dedicated hardware-accelerated image canvases (
ZeroUI.WinForms.Media&ZeroUI.Wpf.Media) offering sub-pixel pan, continuous anchored zoom, forensic pixel grid ($\ge 800%$), interactive MiniMap overview navigator, floating magnifier loupe, and real-time telemetry color probe HUD (ZImageViewer/ImageViewerControl). - Centralized 60 FPS Clock (
ZeroAnimationClock): Single global ticker with synchronized ISA-18.2 blinking phases, eliminating timer scatter.
π Technical Documentation & Guides
In-depth technical specifications and architectural documentation are modularized within the docs/ directory:
| Document | Description |
|---|---|
| π Verified Benchmarks | Frame budgets, 10M rows virtualization, GC allocations, and telemetry throughput. |
| ποΈ Controls Catalog | Full reference for 60+ controls (GridControl, PivotGrid, SCADA, Charts, Media Viewers, and Creative Editors). |
| π¬ Visual Controls Guide & Tour | Architectural guide, in-process live video recordings, and feature tour across all subsystems. |
| π¨ Theming & Styling | Obsidian Dark / Clean Light themes, High-DPI Per-Monitor V2, and single-HWND architecture. |
| ποΈ System Architecture | Multi-tier pipeline coordination, lock-free TripleBuffer, decoupled runtime, and renderers. |
| π Control Ecosystem Audit | Feature gap analysis, composite control standards, and cross-platform shared logic. |
| πΊοΈ Development Roadmap | Release milestones, feature requests, and future capabilities. |
π·οΈ Canonical Z* Control Naming Standard & Collision Prevention
To prevent ambiguous reference collisions (CS0104) with native WinForms and WPF controls (such as System.Windows.Forms.Panel, GroupBox, Button, Label, TextBox), ZeroUI establishes a clean architectural separation:
- Foundational Engine & Infrastructure: Prefixed with
Zero(ZeroTheme,ZeroDpi,ZeroFontCache,ZeroIcons,ZeroAnimationClock,ZeroLocalizer). - Canonical UI Controls Suite: Standard controls adopt the
Zprefix (ZPanel,ZGroupBox,ZMenuBar,ZButton,ZLabel,ZCheckBox,ZRadioButton,ZTextBox,ZProgressBar,ZTabControl,ZSplitContainer,ZGrid,ZChart,ZImageViewer).- Zero Collisions (
CS0104): Guarantees zero naming conflicts when developers import bothSystem.Windows.Formsand ZeroUI namespaces. - Instant IDE Discovery: Simply typing
Zin the IDE immediately surfaces the complete ZeroUI component palette. - Full Theme Synchronization: All
Z*controls automatically inheritZeroThemedark/light modes, rounded corner styles, and High-DPI scaling. - 5-Release Deprecation Wrappers: Previous class names (
PanelControl,GroupControl,MenuBarControl,SimpleButton,TextEdit, and legacyZero*shims) are retained as backward-compatibility wrappers with[Obsolete]warnings and will be maintained across 5 minor release cycles before pruning.
- Zero Collisions (
π¦ Package Matrix
| Package | Targets | Primary Capabilities | Dependencies |
|---|---|---|---|
ZeroUI.Core |
netstandard2.0, net462, net8.0 |
High-frequency telemetry triple-buffer, TagEngine v2, PackML state machine, OEE metrics, validation engine, industrial state models, statistical chart engines (HistogramEngine, ScatterPlotEngine, SunburstLayoutEngine, LollipopEngine, TreemapEngine, SankeyLayoutEngine, BulletBenchmarkEngine, ParetoEngine) |
Zero 3rd-party dependencies (Pure BCL) |
ZeroUI.Historian.Sqlite |
netstandard2.0, net462, net8.0 |
High-throughput SQLite WAL time-series telemetry storage engine (>100k records/s), rolling partitions, store & forward disk cache | Microsoft.Data.Sqlite |
ZeroUI.WinForms |
net462, net8.0-windows |
10M+ rows virtual grid (GridControl), interactive onboarding engine (ZTour), 40+ SCADA/HMI controls, 15+ specialized charts, Obsidian dark theme, DIBSection unmanaged double-buffering |
ZeroUI.Core |
ZeroUI.WinForms.Media |
net462, net8.0-windows |
Enterprise interactive image canvas and studio controls (ZImageViewer, ZPictureEdit) with sub-pixel pan/zoom, forensic pixel grid, MiniMap navigator, HUD color probe, Lightbox preview, and Direct2D / GDI+ pipelines |
ZeroUI.Core, ZeroGraphics |
ZeroUI.Wpf |
net462, net8.0-windows |
Zero-alloc WPF virtual grid (GridControl), interactive onboarding engine (ZTour), industrial styling, 15+ specialized charts, and D3D11 shared texture bridge |
ZeroUI.Core |
ZeroUI.Wpf.Media |
net462, net8.0-windows |
High-performance interactive imaging & forensic inspection suite (ZImageViewer, ZPictureEdit, ZAnnotationCanvas, ZMeasurementRuler, ZWatermarkOverlay, ZVideoPlayer, ZAudioWaveform, ZDocumentDeskew, ZCompareViewer, ZCropBox, ZHistogramScope, ZCurveEditor, ZColorWheel, ZThumbnailGrid, ZDominantPalette, ZHistoryTimeline, ZFilmstripScroller, ZMaskGizmoOverlay, ZBatchTaskQueue, ZTokenPatternEditor, ZExifTelemetryCard, ZMiniMapNavigator) |
ZeroUI.Core, ZeroGraphics |
β‘ Quick Start: 1,000,000 Rows Virtual Grid (WinForms)
using System.Windows.Forms;
using ZeroUI.WinForms.DataGrid;
// Instantiate high-performance virtual grid (ZeroGridControl legacy alias also supported)
var grid = new GridControl
{
Dock = DockStyle.Fill,
RowDensity = GridRowDensity.Normal,
AllowUserSorting = true
};
this.Controls.Add(grid);
// Define strongly-typed columns
grid.Columns.Add(new GridColumn("Id", "ID", 100));
grid.Columns.Add(new GridColumn("Timestamp", "Timestamp", 180));
grid.Columns.Add(new GridColumn("Temperature", "Temp (Β°C)", 140));
// Bind 1,000,000 rows procedurally with 0 bytes GC allocation
grid.SetProceduralDataSource(rowCount: 1000000, (rowIndex, colIndex) =>
{
return colIndex switch
{
0 => (object)rowIndex,
1 => DateTime.UtcNow.AddSeconds(rowIndex).ToString("yyyy-MM-dd HH:mm:ss"),
_ => (25.0 + (rowIndex % 100) * 0.1).ToString("F1")
};
});
π Explore Full Control Catalog & Code Samples
π§ͺ Testing & Quality Assurance
# Run comprehensive automated test suites (720 tests, 100% pass across Core & Desktop UI)
dotnet test ZeroUI.slnx
# Launch interactive demonstration suites via quick launcher
./run-demo.bat
# or directly via PowerShell:
pwsh -File scripts/run-demo.ps1 -Target Both
π Release History
| Version | Release Date | Key Milestones & Highlights |
|---|---|---|
v1.10.0 |
2026-09-25 | Interactive Guided Tour Engine & Canonical Z Naming Standardization*:<br/>β’ Cross-Platform Interactive Onboarding Engine: Native ZTour for WinForms and WPF with spotlight cutout aperture masking (Region.Exclude / CombinedGeometry.Exclude), semi-transparent glass dimming backdrop, and collision-free adaptive popover positioning (TopMost = true).<br/>β’ Specialized Creative & Forensic Inspection Media Suite (ZeroUI.Wpf.Media): ZAnnotationCanvas (vector defect tagging & bitmap burning), ZMeasurementRuler (optical calipers & angle gauge $\theta^\circ$), ZWatermarkOverlay (dynamic security stamps & matrix tiling), ZVideoPlayer (GPU SMPTE playback & frame stepping), ZAudioWaveform (symmetrical wave scrubber & range selection), ZDocumentDeskew (keystone deskew & Otsu binarization).<br/>β’ Standardized canonical Z* naming prefix across all catalog documentation and showcase controls with 100% backward compatibility via [Obsolete] aliases.<br/>β’ Published lightweight single-file demo executables (.NET 8 framework-dependent): WinformDemo (~4.5 MB) and WpfDemo (~3.9 MB).<br/>β’ 720 automated tests passed (100%). |
v1.9.0 |
2026-09-23 | Advanced Statistical, Relational & Hierarchical Charts Suite:<br/>β’ Clean Architecture decoupling: 100% calculation engines in ZeroUI.Core.Analytics with thin WinForms GDI+ and WPF DrawingContext/StreamGeometry rendering.<br/>β’ 8 New High-Performance Analytics Controls: HistogramChart (Sturges & Gaussian Fit), ScatterChart (OLS Linear Regression & Bubble Area), SunburstChart (Multi-Tier 360Β° Radial Partitions), LollipopChart (High-Density Comparison), TreemapChart (Squarified Layout), SankeyChart (BΓ©zier Process Flows), BulletChart (Stephen Few KPI Benchmarks), ParetoChart (Juran 80/20 Defect Analysis).<br/>β’ Standardized control identifiers with zero "Zero" prefix across Core, WinForms, and WPF.<br/>β’ Interactive showcase sub-tabs integrated into WinformDemo and WpfDemo.<br/>β’ Interactive launcher scripts added (run-demo.bat, scripts/run-demo.ps1).<br/>β’ 655 automated tests passed (100%). |
v1.8.6 |
2026-09-22 | Zero-Dependency Core & Cross-Platform Control Parity Standard:<br/>β’ Decoupled SQLite telemetry historian into dedicated ZeroUI.Historian.Sqlite package, achieving 100% zero third-party dependencies in ZeroUI.Core.<br/>β’ Established automated cross-platform parity reflection test suite (ControlParityInspectionTests).<br/>β’ Standardized platform-neutral industrial state machines (SevenSegmentState in ZeroUI.Core.Industrial) achieving 100% parity across WinForms and WPF.<br/>β’ 607 automated tests passed (100%). |
v1.8.5 |
2026-09-20 | Industrial Control Normalization & Prefix Removal:<br/>β’ Standardized primary control names to clean enterprise identifiers (GridControl, ChartControl, SevenSegment, LinearGauge, ValidationProvider) per .project-rule.md.<br/>β’ Full backward compatibility preserved via [Obsolete] shims. |
v1.8.0 |
2026-09-15 | Creative & Media Controls Suite:<br/>β’ Direct-rendered, high-performance visual editors for digital imaging and video grading (CurveEditor, ColorWheelEdit, CompareViewerControl, HistogramScopeControl, CropBoxControl, MiniMapNavigator, MaskGizmoOverlay, FacetedFilterBar, HistoryTimelineControl, FilmstripScrollerControl, DominantPaletteControl, ExifTelemetryCard, NumericSliderEdit, BatchTaskQueueControl, ThumbnailGridControl, TokenPatternEditor).<br/>β’ Zero-allocation graphics primitives for curves, color scopes, and canvas gizmos.<br/>β’ 529 automated tests passed (100%). |
v1.7.0 |
2026-09-12 | WPF Modernization & High-DPI Per-Monitor V2:<br/>β’ Zero-alloc WPF virtual grid adapter.<br/>β’ High-DPI Per-Monitor V2 dynamic scaling engine.<br/>β’ Win32 Memory DC unmanaged DIBSection double buffering with zero-copy BitBlt presentation. |
v1.0.0 |
2026-09-08 | Initial Industrial Release:<br/>β’ 10M+ rows procedural virtual data grid with zero GC allocations.<br/>β’ 40+ industrial SCADA/HMI controls with Single-HWND architecture.<br/>β’ Unified theme engine: Obsidian Dark (#12151C) and Clean Light modes.<br/>β’ Centralized 60 FPS ISA-18.2 synchronized animation clock (ZeroAnimationClock). |
π Part of the ZeroPlatform Ecosystem
ZeroUI is the user interface and SCADA visualization pillar of the ZeroPlatform suite β unifying 12 sovereign subsystems including ZeroGraphics, ZeroPipeline, ZeroTensor, ZeroComm, and ZeroStorage.
ποΈ Ecosystem Architectural Alignment
ZeroUI is a sovereign member of Tier 5 (Presentation & Orchestration) within the ZeroPlatform industrial automation ecosystem.
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β Tier 5: Presentation & Orchestration (ZeroUI) β
ββββββββββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββ
β consumes
ββββββββββββββββΌβββββββββββββββ
βΌ βΌ βΌ
βββββββββββββββββββββ ββββββββββββββββ βββββββββββββββββββββ
β Tier 0: Primitivesβ β Tier 1: Data β β Tier 4: Graphics β
β (ZeroPrimitives) β β (ZeroData) β β (ZeroGraphics) β
βββββββββββββββββββββ ββββββββββββββββ βββββββββββββββββββββ
- Upstream Ingestion: Consumes Tier 0 foundational primitives (
ZeroPrimitives.Core 1.3.0), Tier 1 high-speed columnar data buffers (ZeroData.Core 1.3.0), and Tier 4 GPU/2D rendering infrastructure (ZeroGraphics.* 1.5.0). - Strict DAG Conformance: Zero references to orchestrators or applications.
- Packaging & CI/CD: Standardized under
Company = ZeroPlatform,Authors = Phong VΓ΅,<ZeroTier>5</ZeroTier>.
π License & Author
Released under the permissive MIT License.
Architected and developed by Phong VΓ΅.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. 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 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. |
| .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 is compatible. 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. |
-
.NETFramework 4.6.2
- Microsoft.Data.Sqlite (>= 8.0.8)
- ZeroUI.Core (>= 1.10.1)
-
.NETStandard 2.0
- Microsoft.Data.Sqlite (>= 8.0.8)
- ZeroUI.Core (>= 1.10.1)
-
net8.0
- Microsoft.Data.Sqlite (>= 8.0.8)
- ZeroUI.Core (>= 1.10.1)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.