[GNC] Current status of SQL backend, including locking

[Derek Atkins]

Hi,

The SQL backend is stable, but is not multi-user.  GnuCash (still) does
not support multiple, concurrent users.  But if you want to store your
data in SQL format, you can.

-derek

On Fri, March 7, 2025 6:08 pm, Jeff Kletsky wrote:
> In reviewing the documentation after not using GnuCash for many years, I
> found that the FAQ on the use of a SQL backend was outdated, going back
> to 2.4, which I think was nearly 15 years ago. Before another of the
> newer members jumps in with a knee-jerk reaction, you can find that I
> contributed to the project back in the IHTFP days. While there have been
> changes to that page over the years, it looks like the last substantive
> ones mentioning SQL were back in 2011.
>
> Much of the core has been rewritten out of Scheme since then, there has
> been over a decade of work, the wiki shows use of SQL at
> https://wiki.gnucash.org/wiki/GnuCash_SQL_Examples, and there is a lock
> table described at https://wiki.gnucash.org/wiki/SQL. These all suggest
> that there have been meaningful changes in the SQL backend since
> "Multiple Computers, Users, ..." and "SQL Database" were updated in the
> FAQ. As a result, I would like to know what the current status of the
> SQL backend is, including robustness and sufficiency of locking is at
> this time.
>
> I would have searched the mailing list archives, but "Yes, you can
> search the mail list archives at
> http://news.gmane.org/gmane.comp.gnome.apps.gnucash.devel and
> http://news.gmane.org/gmane.comp.gnome.apps.gnucash.user (and
> http://news.gmane.org/gmane.comp.gnome.apps.gnucash.german if you speak
> German)." is also outdated. From what I can tell, news.gmane.org does
> not have active DNS. Is there a replacement index available?
>
> Thanks,
>
> Jeff
>
>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>


-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant