Re: [GNC] Simultaneous access
On 5/16/2024 2:17 PM, David G. Pickett via gnucash-user wrote: Yes, if gnucash was running as a remote service, it might be able to deal with multiple users. Imagine that gnucash becomes a web service and the user interface is a relatively simple web page. Even in this scenario, you would need to avoid processing too much in JavaScript and local files under the web browser, so the remote server has updated data at all times. But already gnucash often leaves a modified transaction not committed to the saved storage, even with auto save. When my cron job kills gnucash to update prices, it sometimes loses such transactions typed but not committed by leaving that line. It might be an improvement to remedy that! Gnucash can work with multiple SEQUENTIAL users (one at a time) Gnucash cannot work with multiple CONCURRENT users (more than one at a time). That requires running under the control of a DBM. This issue is really beyond almost all end users. The issues involved with concurrent processing, and the various solutions that can be employed, would usually be learned at the upper levels of Computer Science program. Look for a course with a name like "concurrent processing". Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Simultaneous access
Yes, if gnucash was running as a remote service, it might be able to deal with multiple users. Imagine that gnucash becomes a web service and the user interface is a relatively simple web page. Even in this scenario, you would need to avoid processing too much in JavaScript and local files under the web browser, so the remote server has updated data at all times. But already gnucash often leaves a modified transaction not committed to the saved storage, even with auto save. When my cron job kills gnucash to update prices, it sometimes loses such transactions typed but not committed by leaving that line. It might be an improvement to remedy that! If the data is in an RDBMS (not XML read into, and later written from, memory structures) and you allow two or more applications that ignore or miss the lock file, there is still stale data in the memory of each application not yet sent to the RDBMS. I am not sure how closely gnucash keeps the RDBMS in sync with memory. If the data was in memory mapped files, and the files were on a remote server, it is conceivable that multiple apps mapping the same files into their VM could learn to keep out of each other's hair, and could use a mutex in that memory mapped file space. However, I have seen memory mapped remote files not transmit changes to the local RAM until the file is refreshed, say by listing the directory! One solution is to run gnucash under a virtual desktop like VNC and XWindows on Linux. You can connect a window to the virtual desktop from any host, and continue working with the same gnucash session and application on the original server. I used to pick up work at home that was in process at work, or vice versa, but I had a VPN to put me on the work network from home. Security is a concern, but you can run VNC through an SSH tunnel. Some ISPs frown on you running any sort of TCP server. I wonder if anyone has come up with a UDP protocol to hide the presence of a service from the ISP? :D ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Simultaneous access
No. Using an SQL database just means you are deciding where you are going to save your data. The way the program works is that it loads your data file into memory and any changes you make are done in memory. Data is not saved anywhere until you specifically write it to wherever you store it. There's no multiple access, no simultaneous updating. If someone else loads the same datafile into memory, whatever changes either user makes, the file that becomes the permanent data file is the one written last. ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Simultaneous access
Hi, On Wed, May 15, 2024 7:14 pm, Chris Miller wrote: > The application gnucash does NOT support multiple simultaneous > access. > That would require a DBM (database manager) > >Apparently there are a variety of DBM "back-ends". If I configure >Postgress, for example, do I get simultaneous access? No. The DBM is just used as a storage system. GnuCash is not a DB App, which is what would be required to actually support simultaneous usage. It's on the roadmap to get there, but at the current rate I expect to see it somewhere in the 2030s. >Thanks for the help, >Chris. >Laboriously sent to you from my ... do you really care? > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Simultaneous access
The application gnucash does NOT support multiple simultaneous access. That would require a DBM (database manager) Apparently there are a variety of DBM "back-ends". If I configure Postgress, for example, do I get simultaneous access? Thanks for the help, Chris. Laboriously sent to you from my ... do you really care? ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Simultaneous access
On 5/15/2024 6:02 PM, Chris Miller wrote: Hi Folks, Can I store my GnuCash "books" on a server, or a NAS, and do my bookkeeping from any of my machines, meaning my windows desktop or my Linux development station? Can I do this simultaneously? The application gnucash supports multiple sequential access. If the directory containing the file that is the books is on this server, the "lock file" method of preventing multiple simultaneous access should still work. Do not override that! (the way you can if you are the only possible user) The application gnucash does NOT support multiple simultaneous access. That would require a DBM (database manager) Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Simultaneous access
Hi Chris > Can I store my GnuCash "books" on a server, or a NAS, and do > my bookkeeping from any of my machines, meaning my windows desktop or > my Linux development station? Yes - provided you have the GnuCash software (preferably the same version) installed on each of those client machines. > Can I do this simultaneously? No, GnuCash is designed for exclusive single user access only. Regards Geoff = On 16/05/2024 8:02 am, Chris Miller wrote: Hi Folks, Can I store my GnuCash "books" on a server, or a NAS, and do my bookkeeping from any of my machines, meaning my windows desktop or my Linux development station? Can I do this simultaneously? Thanks for the help, ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
[GNC] Simultaneous access
Hi Folks, Can I store my GnuCash "books" on a server, or a NAS, and do my bookkeeping from any of my machines, meaning my windows desktop or my Linux development station? Can I do this simultaneously? Thanks for the help, -- Chris. V:916.799.9461 F:916.974.0428 A: Because we read from top to bottom, left to right. Q: > Why should I start my reply below the quoted text? ___ gnucash-user mailing list gnucash-user@gnucash.org 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.