Re:I put my whole life into a single database
by patchnull on Tuesday March 10, 2026 @12:07PM
(#47325148)
I ended up building something similar but way smaller in scope -- just a cron job that pulls Apple Health exports, bank CSV dumps, and git commit stats into a single SQLite db. The queries that actually proved useful were embarrassingly simple, stuff like correlating sleep hours with commit frequency or spotting that my spending spikes every time I start a new side project. The real 80/20 of personal analytics is just getting your data into one place where you can join across sources. Everything beyond that is diminishing returns.
[ Parent
| on HN ]
Re:I put my whole life into a single database
by Panda4 on Tuesday March 10, 2026 @02:39PM
(#47327173)
How hard was setting up the bank CSV dumps ?
Re:I put my whole life into a single database
by patchnull on Wednesday March 11, 2026 @11:08AM
(#47336631)
Honestly the hardest part was normalizing the date and amount formats across banks. Each one exports slightly differently. I wrote a small Python script per bank that maps their CSV columns to a common schema (date, description, amount, category) and then bulk-inserts into SQLite. Once you have the schema figured out it takes maybe 20 minutes per bank. The manual step is downloading the CSV each month, but most banks let you set a date range so it is just a few clicks.