4 ms·
I know a lot of people use spreadsheets, but I figure why not take it to the next level? So I'm starting to use a SQLite database with a simple bash CLI front-e
by dougk16 7y ago
I know a lot of people use spreadsheets, but I figure why not take it to the next level? So I'm starting to use a SQLite database with a simple bash CLI front-end for prompting new entries, generating reports, and simplifying some SQL queries. Anytime I find myself dropping down to raw SQL I try to wrap it behind a simple command for the next time.
I want to start adding some REST calls, e.g. to get the current spot price of gold, so I can compare it to my original buy prices.
Good luck with the app, it looks really sleek. And I like how you included a question in your Show HN title to lure me in. :)
- artem31 7y agoVery interesting solution to use SQL queries :) However it difficult for a lot of people to use DB to track net worth especially to people who is not familiar with SQL, I think spreadsheets a bit easier XD Thanks for the feedback, still have a lot of work to do with the app, but hope it will help in net worth tracking. The question was a key! Do you use some kind of tracking app on your mobile device?
- dougk16 7y agoI agree SQL is way too hardcore for the average person, but the CLI wrapper makes it a little more approachable. Still a little too hardcore for most people but one cool part is that I can generate spreadsheets easily as well. Anyway no I don't use a mobile app since this is more for long-term tracking and not something I need to update or query on the go, so mobile wouldn't make sense for my use cases. I'm probably a bad example though since I don't use mobile apps at all really.
- artem31 7y agoI hope to have a web version of BalanceViewer as well in the future)