Financier App > Bug Reports

Cannot load budgets due to memory limits

<< < (2/2)

asromzek:
@jat255, I was going to see if you were comfortable with sending me a copy of your budget to do that exact kind of test, and completely forgot (it's been a busy week). It looks like you came to the same conclusion I did. If @Alex can help you out, the process requires signing out and clearing data in all of the browsers/apps where you have your budget loaded, he creates a new database under the hood, and then you import a fresh backup.

I have not deleted/imported my budget since I bloated my last database, and have tried to be as efficient as possible when making changes. For example, If I need to change the flag color and the cleared status on a transaction, I will go into full edit mode so both changes are saved in a single update, instead of two separate revisions for the transaction.

jat255:
Yeah, I think I'm actually going to continue to self-host the backend, since I've never been super comfortable with all this info on someone else's server, unencrypted. I trust Alex, but I'd rather have all of this stay on my own servers behind my VPN. As a benefit, I'm understanding how things work a little better under the hood, so maybe I'll find some time to do some playing around. I saw there was at one point an outstanding PR for searching and copy/paste from https://gitlab.com/palidanx/financier/-/commit/763fddcaab73489a1527c75afb55195d04c1b809 that I will try to implement on my fork.

asromzek:
Talking about this stuff is starting to get the creative juices flowing again. I have been kicking around the idea of building a new budget app similar to YNAB4/Financier, using some of the newer C# technologies that have come out over the last few years. I work with that stuff at my job every day, so I would be very comfortable building something from scratch.

I have gone back and forth on whether it would be a simple, standalone desktop app, or a full blown web app (desktop & mobile) with full syncing capability. If I implement syncing, do I build it so it's self hosted for myself, and available for gurus to self host themselves, or set up a subscription service so anyone can sign up and pay for the syncing capability like Financier? If I didn't have to worry about hosting and securing data for other people, that would certainly keep things simple on my end. But if I build something new and useful, making it available and fully functional for everyone instead of just technology enthusiasts also sounds really attractive to me.

CouchDB provides really nice out-of-the-box syncing capability, but it also has some drawbacks when pushing the limits as we have encountered. It also makes it a little difficult to implement some features like scheduled transactions. I actually sat down and sketched out a plan for building a syncing algorithm a couple months ago that would solve some of those issues, but never got around to writing any code to test it out. I'm probably going to pull that sketch out again to see if I can put it into practice.

Financier has worked great for the last few years and I hate to reinvent the wheel, but it might be fun to build something new that solves some of the underlying issues and makes it possible to implement some of the features that have been requested like scheduled transactions, file import, search, etc.

Alex:
@jat255 sounds like you might've got a solution.

Just curious - oftentimes the huge syncs is do to importing, deletting, importing, deleting budgets. The budget data isn't ever actually "deleted" in CouchDB due to the way CouchDB's sync mechanism works.

If you'd like, I can remove all data on your Financier account after you export your budget data you want to keep to JSON. Then, once you log out (very important!) from ALL devices, you can re-import, and it should work great.

Alternatively, you can always create a brand new financier account - (hello+blah@gmail.com) and import budget data to that.

Should sync much faster.

Navigation

[0] Message Index

[*] Previous page

Go to full version