blog.csdn

Java个人日记系统：从H2到SQLite的本地持久化实战

文章浏览阅读26次。本地数据持久化是Java桌面应用与单机工具开发的基础能力，涉及嵌入式数据库选型、事务控制、时区处理与SQL优化等核心原理。SQLite凭借零配置、文件即数据库、WAL并发安全等特性，成为个人笔记类应用的理想本地存储方案；而H2则在快速原型验证阶段提供内存级敏捷迭代能力 ...
blog.csdn

WinForms+SQLite管道缺陷管理系统实战项目

文章浏览阅读13次。WinForms 是 .NET 桌面应用开发的基础框架，SQLite 则是轻量级嵌入式数据库的典型代表。二者结合可构建零依赖、免安装、高兼容的本地化数据管理工具。其核心原理在于利用 SQLite 的文件型数据库特性与 WinForms 的事件驱动 UI 模型，通过直写 SQL 和 ObservableCollection 绑定实现高效数据 ...

Comparing time-series data in SQLite using UNIX seconds and ISO strings revealed another issue

The difference in processing speed and capacity found in today's actual measurements Range searches on 10 million time-series ...

Extracting week numbers from dates matches across 10 systems, but converting back from week ...

Week numbers like "the 41st week of 2026" appear in sales aggregation units, log rounding units, and even in sprint names.
HackerNoon

The Fastest C# Code in a Benchmark Lost the Real-World API Test

A reproducible .NET 10 investigation of List vs HashSet lookups, setup costs, allocations, JIT assembly, CPU caches, and ...