Hi Suseno,
I have an app I have written that gives me a web-style interface for
gnucash;
> https://github.com/lorimark/gnucashew-dev
This app uses SQL back-end exclusively, and so runs on sqlite or postgres.
I can tell you from my experience that running multiple users ~can~ be
problemmatic, and/also, in the scenario you are describing (putting a
transaction in on-line and seeing it at home) you ~can~ be successful.
When running my web-app on the gnucash sqlite file, I ~can~ leave the
local gnucash open and running, but I usually shut it down. I can put
transaction in via the web app, and when opening the desktop gnucash
app, all my transactions are there.
I ran in to an issue one day when it seemed I was missing information,
but upon a little deeper examination, it appeared as though the sqlite
indexes got corrupted. It was a very easy fix.
Since this is a sqlite setup, there is certainly a 'collision' issue
when running apps like this. If you're going to be running with
postgres you'll likely not have the indexes issue I had with sqlite, but
there are other simple multi-user issues - just the fact of having
multiple people accessing the database simultaneously.
But, as I said, in the scenario you've described, in my experience, I
have _not had_ issues running multiple apps simultaneously.
~mark petryk
~w:http://www.lorimarksolutions.com
~q:i don't know where it's going to go,
...and i don't know what to wear when it gets there.
On 6/18/26 05:41, Suseno Dermawan wrote:
Hi,
in context:
I've been using gnucash about 5 years + and been using XML and later on
using SQLlite.
But now i am using postgresql.
The question is:
Since the db is hosted online. Can i use a different apps (mobile apps) to
update the db (use case i.e., scanning receipt and auto input to gnucash
db) and and then when i reach home, i can review the transaction?
Is there a risk to this kind of use case?
Thanks
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
