Tag: sqlite
Replace SQLite with Bolt
Use Bolt for IO internal storage and general data persistence.
Use CGO, libc, and pure SQLite
Since Envoy will always depend on libc, it seems reasonable for IO to also.
Glauber Costa - Forking SQLite and Building a Distributed Database with Turso
Glauber Costa explains how Turso forks SQLite into libSQL to create a distributed database, drawing from his Linux kernel development experience.
Jess Martin - DXOS
Jess Martin explains DXOS, a framework for local-first multiplayer apps where users own their data and carry identity across applications.
Running Scheduled Data Collection with Synology and Docker
Running scheduled Python data collection jobs on a Synology NAS using Docker containers and the built-in cron-style task scheduler.
Instead Of MAX Use LAST_VALUE For Time-Based Data
Why MAX returns the wrong number for end-of-period values in time-series SQLite data, and how LAST_VALUE with a window frame gives correct results.
Script to Remove Core Data's SQLite Database File During Development Cycles
During development of applications that uses Core Data on the iPhone, I find myself often wanting to delete the SQLite database file. This is