<div dir="ltr"><div dir="ltr"><span style="font-family:verdana,sans-serif">Oh, as for the database back-ends to GnuCash, note that this is still officially experimental, with no guarantee of data integrity (the GnuCash site says "data loss can occur"). Other than that, I concur with your comments re the database back-ends.<br></span><div style="font-size:small;color:rgb(0,0,0)" class="gmail_default"><span style="font-family:verdana,sans-serif"> </span></div><span style="font-family:verdana,sans-serif"><font size="2">Hartmut W Sager - Tel +1-204-339-8331<br></font><br></span></div><div class="gmail_extra"><span style="font-family:verdana,sans-serif">
</span><br><div class="gmail_quote">On 13 March 2017 at 21:47, Hartmut W Sager <span dir="ltr"><<a href="mailto:hwsager@marityme.net" target="_blank">hwsager@marityme.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)">> Usable compared to hand-rolled FoxPro?<br> <br></div><div style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)">I had to read that a few times to conclude that it's a (FoxPro) compliment. :)<br></div><div style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)"> <br></div><div style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)">Thanks hugely for the further info and links. That "backward compatible extensions via KVP's" is a ridiculously compromised architecture, and has me seriously considering not pursuing GnuCash any further. Since GnuCash updates are always available for free (and include a boatload of bug fixes every time), there is not the slightest reason to maintain this backward compatibility, just forward compatibility (old file can be loaded into next newer GnuCash version, but not saved backward).<br> <br></div><div style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)">I have also been considering several other "roll my own" options for the last few years, notably MySQL/MariaDB/PHP. Being a heavy-duty algorithmic programmer, I am very intolerant of inadequate software, and "roll my own" often becomes my best choice.<br></div><div style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)"> <br></div><div style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)">If you're wondering why I have to leave FoxPro, it's because Microsoft is letting it disintegrate, despite it still being officially a currently supported product. In fact, as I rudely discovered a year ago, it wouldn't even install on Windows 10 without a special patch being run first. I.e., Microsoft didn't even test the installability (let alone proper operation) on Windows 10 of a currently supported product of their own!<br></div><div style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)"> <br></div><div style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)">GnuCash is visually very well done, though, I must say! And it is quite feature-laden.<br></div><div style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)"> <br></div><div class="gmail_extra"><div><div class="gmail-m_-8406313886907049300gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><font size="2"><span style="font-family:verdana,sans-serif">Hartmut W Sager - Tel <a href="tel:%28204%29%20339-8331" value="+12043398331" target="_blank">+1-204-339-8331</a><br></span></font><br></div></div></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On 13 March 2017 at 19:03, Glen Ditchfield <span dir="ltr"><<a href="mailto:GJDitchfield@acm.org" target="_blank">GJDitchfield@acm.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Monday, March 13, 2017 6:27:53 PM CDT Hartmut W Sager wrote:<br>
> Oooh, thanks, this is valuable! I will experiment further with what you<br>
> did. And I presume that this is within the specs or design intentions of<br>
> GnuCash, so that it should remain usable in further GnuCash versions?<br>
<br>
Usable compared to hand-rolled FoxPro?<br>
<br>
But, yeah, I'd go with it. "It's been the (unfortunate) practice through most<br>
of Gnucash 2's development to use KVP to add or extend new variables to<br>
Gnucash because doing so allows older versions of Gnucash to open the data<br>
file." (<a href="http://gnucash.1415818.n4.nabble.com/what-is-the-table-slots-good-for-td4658122.html" rel="noreferrer" target="_blank">http://gnucash.1415818.n4.nab<wbr>ble.com/what-is-the-table-slot<wbr>s-good-for-td4658122.html</a>)<br>
<br>
Keep in mind that GnuCash has database back-ends, too. I wouldn't trust the<br>
front end to handle anything unless all the back ends support it. There's<br>
some weak documentation at <a href="https://wiki.gnucash.org/wiki/GnuCash_XML_format" rel="noreferrer" target="_blank">https://wiki.gnucash.org/wiki/<wbr>GnuCash_XML_format</a><br>
and <a href="https://wiki.gnucash.org/wiki/SQL" rel="noreferrer" target="_blank">https://wiki.gnucash.org/wiki/<wbr>SQL</a>.<br>
<br>
______________________________<wbr>_________________<br>
Roundtable mailing list<br>
<a href="mailto:Roundtable@muug.ca" target="_blank">Roundtable@muug.ca</a><br>
<a href="https://muug.ca/mailman/listinfo/roundtable" rel="noreferrer" target="_blank">https://muug.ca/mailman/listin<wbr>fo/roundtable</a><br>
</blockquote></div><br></div></div>
</blockquote></div><br></div></div>