mirror of
https://github.com/actualbudget/actual.git
synced 2026-07-16 07:04:23 -05:00
[GH-ISSUE #511] [Bug] Multiple budgets #41843
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#41843
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @rich-howell on GitHub (Jan 22, 2023).
Original GitHub issue: https://github.com/actualbudget/actual/issues/511
Discussed in https://github.com/actualbudget/actual/discussions/252
Originally posted by TradedManatee September 23, 2022
I've got two sets of accounts/budgets. One for my personal expenses and one for joint expenses with my partner.
I've tried creating two files on the same instance; however whichever file I open I am presented with all the accounts in both files, which is counter-intuitive to me.
I could spin up a second instance/server on a different port, but this would double the workload on the server.
Would be good to isolate files from each other.
@rich-howell commented on GitHub (Jan 28, 2023):
Hey @TradedManatee,
I think this was resolved when we switched over to simple sync. Are you able to confirm that it is no longer an issue with the latest release?
Cheers
Rich
@j-f1 commented on GitHub (Jan 28, 2023):
This issue can still occur if you're not accessing the budget over HTTPS because I believe the
SharedArrayBufferfeature requires a secure context (or localhost) plus the other required headers. The client should really be handling this better or provide a clear error message.@TechwizEE commented on GitHub (Jan 28, 2023):
I'm able to replicate this issue when HTTPS is not used in 22.12.9. Concur on
SharedArrayBuffernot being enabled by the browser (debug console errors state COOP header is being ignored) . Related: #436, https://github.com/jlongster/absurd-sql/issues/14#issuecomment-902116794, https://github.com/actualbudget/actual-server/issues/15@MatissJanis commented on GitHub (Jan 28, 2023):
Would upgrading sqlite solve the problem?If not: any ideas how we could get rid ofSharedArrayBufferand use something else that would be supported in both http & https?@TechwizEE commented on GitHub (Jan 28, 2023):
Very good questions. I don't have an immediate answer. My reading so far shows James'
absurd-sqlis backing sql.absurd-sqlhas documentation specifically notingSharedArrayBufferlimitations.Looking through
actual/packages/loot-core/package.jsonI see"@jlongster/sql.js": "^1.6.7"and"absurd-sql": "0.0.53"are dependencies. The blog post above notes a mode called "fallback" that is supposed to enable absurd-sql to still run, with DB writes being "assumed" to be successful.The top-level readme for
absurd-sqlalso mentions Fallback mode.@TechwizEE commented on GitHub (Jan 28, 2023):
Thoughts:
absurd-sqlthat addresses this functionality (http vs https)SharedArrayBufferis being used, see if it can be swapped outI may see about looking into this. Welcome any thoughts, ideas, contributions, code, expertise.
It is impressive reading through what James did with
absurd-sql. Performance is amazing.@TechwizEE commented on GitHub (Jan 28, 2023):
Just ran 22.12.9 again (
git checkout v22.12.9,yarn starton Ubuntu Server 22.04.1) tested the following in Firefox (v109.0) on Windows 10:Fallback mode unable to write file changes@TechwizEE commented on GitHub (Jan 29, 2023):
Would be curious to get @jlongster input:
localhostwith HTTP?@TechwizEE commented on GitHub (Jan 31, 2023):
One idea is to try removingabsurd-sqland run plain SqlLite and see if this resolves the HTTP vs HTTPS issue.Why try removingabsurd-sql? Because the debug console messageFallback mode unable to write file changesis located inabsurd-sql.Thoughts? Other ideas?
@shall0pass commented on GitHub (Jan 31, 2023):
You might find this interesting at 1:10:00. It provides some history of why things were done the way they were.
https://changelog.com/podcast/495
@TechwizEE commented on GitHub (Jan 31, 2023):
Awesome, will check out the podcast
@TechwizEE commented on GitHub (Feb 1, 2023):
Thank you for the link and time reference. Enjoyed listening. I was not aware of how core
absurd-sqlis to Actual.@shall0pass commented on GitHub (Feb 1, 2023):
👍 I was impressed with the solution, given the technical challenges.
@j-f1 commented on GitHub (Feb 1, 2023):
Something I don’t understand about this is why absurd-sql falls over so badly in a single-tab environment. It seems like
SharedArrayBufferwould be about syncing between multiple open tabs, but the issues encountered here are easy to reproduce with only a single tab open.@shall0pass commented on GitHub (Feb 1, 2023):
Is it possible to have Actual serve https instead of http? I found this package on npmjs that sounds like it might do that? If Actual served https by default, the fallback option would never be used, right?
@j-f1 commented on GitHub (Feb 1, 2023):
Working on that! It isn’t an issue for local servers since
localhostis treated as a secure context (even if HTTPS is not used), so tools likemkcertwould work less well. I think I’m going to implement it by making people provide their own HTTPS certificates, but I’m open to other ideas!@shall0pass commented on GitHub (Feb 1, 2023):
I guess I was thinking more from the perspective of a docker container serving the https, where you wouldn't automatically need nginx.
@j-f1 commented on GitHub (Feb 3, 2023):
Closing this out since #600 adds a warning when this happens. If you’ve followed the steps it suggests and are still seeing this issue, please open a new bug report!