3 ms·
SQLite is an underrated interface for this kind of stuff. Do you support things like nested categories (Expenses:Food:Groceries) and budgets? If so, do you kee
by gen220 7y ago
SQLite is an underrated interface for this kind of stuff.
Do you support things like nested categories (Expenses:Food:Groceries) and budgets? If so, do you keep them in your data model, or do you construct them in the queries?
Also, just curious, have you considered using gnu Ledger? If so, what prompted you to choose SQLite over it?
- decasteve 7y agoNo nested categories. Mostly it’s centred around having the correct amounts for tax returns. Some categories like groceries and eating out I have but I haven’t really used it for budgeting—just curiosity. I tag everything as business or personal. I have a Tax/HST column to make that easier. Every month I get all of my various accounts exported as csv and then import into sqlite with a single command. It was just something I was tinkering with at first and then it became something I used. I have considered gnu Ledger but my own personal tool does what I need and it was fun to do. So I haven’t felt the need to.