[GNC] Current status of SQL backend, including locking

[Jeff Kletsky]

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