3 ms·
- personal finances - get statement exports to sqlite db and I have dashboards to manage expenses/finances, retirement account data in sqlite and charts for act
by asdvasewe 4y ago
- personal finances - get statement exports to sqlite db and I have dashboards to manage expenses/finances, retirement account data in sqlite and charts for actual and projections
- my car - I collect data in sqlite db - amortization schedule/actuals for the loan, fuel/maintenance expenses etc. Dashboards on top of it with metrics such as $ spent, miles, cost of finance, cost of ownership (per mile) etc.
- workouts - I used enodomondo but they shut down and I had a data dump, I currently use garmin. So I get all the data to sqlite and drive a dash with overall work out stats over years across platforms.
- samstave 4y agoThanks! Can you share screens of your car dashboard, this sounds like a marketable simple one-page web-app that people would sign up for an use... But then you'll get millions of users and you'll have to learn postgress and a range of other meta-metrics to track your uptime and availability 9s to your constituent users....
- asdvasewe 4y agoRight now I just have a raspi hosting superset and sqlite for me and I use it locally, its not out in the open. However, based on my experience, the metrics and dashboard for the car are not very hard to do, the biggest factor imo is the discipline of data collection, get receipts and insert data to the db for each refuel, maintenance, parts, registrations, insurance etc. If you miss collecting data, the data/insights aren't as useful anymore. Maybe scanning receipts and ocr is the next step, that's on my roadmap, when I find time that is :)