Started going really deep into SQLite. Couple hiccups like making sure when creating tables to use strict mode and enabling foreign keys that every one needs t

Started going really deep into SQLite. Couple hiccups like making sure when creating tables to use strict mode and enabling foreign keys that every one needs to read about. I exported about 8million rows from my Apple health records (about eight years for something’s like steps from before watch) and into a SQLite database from the xml dump using python (twice as fast a rust for some reason) in about 110 seconds. Dates are stored as Unix time stamps. Had ChatGPT generate some queries that showed my percent change in things like resting heart rate for each year using LAG and AVG return in less than a second. My job at work https://unsupervised.com/ https://unsupervised.com/ does a lot of KPI work so I’ve been interesting in learning how to to correlate data to show improvements to KPIs (in my case resting heart rate or lean body mass) Nextjs server components and https://github.com/kysely-org/kysely https://github.com/kysely-org/kysely also make working with SQLite a breeze.