Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
Yes. I did. Original Message From: Geert Janssens Sent: Wed Sep 23 16:10:11 EDT 2020 To: gnucash-user@gnucash.org Subject: Re: [GNC] Can't "Save As" to sqlite, is it a compile option? Op dinsdag 22 september 2020 10:13:37 CEST schreef Chris Green: > On Mon, Sep 21, 2020 at 01:12:38PM -0500, Adrien Monteleone wrote: > > I'm pretty sure that *is* documented on the Wiki build pages, or at least > > used to be. I once built on Ubuntu and found that option on the Wiki to > > get > > it working. > > Ah, but it's nothing to do with 'building' really. > > > I was lightly following some Wiki Build Instruction discussion on IRC > > recently and I think that very option (with needed dependency) was pointed > > out as not being quite obvious. > > > > Check out the Build on Linux pages (along with the sub-pages about > > dependencies) and read their Talk sections for more current info and state > > of the edits. > > As above, nothing to do with 'building' IMHO. It should be in the > basic 'installation' notes. Did someone already refer to https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html#basics-storage-comparison-tblsect[1] That's a section in the tutorial about storing your data. And the note on availability of the three sql backends mentions you may have to install libdbi and the appropriate dbd (sql) backends. Regards, Geert [1] https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html#basics-storage-comparison-tblsect ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
Op dinsdag 22 september 2020 10:13:37 CEST schreef Chris Green: > On Mon, Sep 21, 2020 at 01:12:38PM -0500, Adrien Monteleone wrote: > > I'm pretty sure that *is* documented on the Wiki build pages, or at least > > used to be. I once built on Ubuntu and found that option on the Wiki to > > get > > it working. > > Ah, but it's nothing to do with 'building' really. > > > I was lightly following some Wiki Build Instruction discussion on IRC > > recently and I think that very option (with needed dependency) was pointed > > out as not being quite obvious. > > > > Check out the Build on Linux pages (along with the sub-pages about > > dependencies) and read their Talk sections for more current info and state > > of the edits. > > As above, nothing to do with 'building' IMHO. It should be in the > basic 'installation' notes. Did someone already refer to https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html#basics-storage-comparison-tblsect[1] That's a section in the tutorial about storing your data. And the note on availability of the three sql backends mentions you may have to install libdbi and the appropriate dbd (sql) backends. Regards, Geert [1] https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html#basics-storage-comparison-tblsect ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
On Mon, Sep 21, 2020 at 01:12:38PM -0500, Adrien Monteleone wrote: > I'm pretty sure that *is* documented on the Wiki build pages, or at least > used to be. I once built on Ubuntu and found that option on the Wiki to get > it working. > Ah, but it's nothing to do with 'building' really. > I was lightly following some Wiki Build Instruction discussion on IRC > recently and I think that very option (with needed dependency) was pointed > out as not being quite obvious. > > Check out the Build on Linux pages (along with the sub-pages about > dependencies) and read their Talk sections for more current info and state > of the edits. > As above, nothing to do with 'building' IMHO. It should be in the basic 'installation' notes. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
Hi Chris, Am 21.09.20 um 15:59 schrieb Chris Green: > On Mon, Sep 21, 2020 at 07:25:54AM -0400, D. wrote: >> No need. https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html >> > OK, it's there, but I didn't find it very easily (could be me of > course). > > Is there any major disadvantage to making it a dependency on Linux as > well as on Windows and Mac? > It is definitly the wrong term. Modern package format have additinal fields like "recommends". Did you ever look for it? Regards Frank ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
SQLite3 is incredibly widely used so it's already on just about everything except Windows. libdbi and libdbd-sqlite are tiny, less than 100K for both. Regards, John Ralls > On Sep 21, 2020, at 11:15 AM, Adrien Monteleone > wrote: > > The disadvantage would be for those users who don't want or need it and like > to manage lean and clean systems. > > Without getting into any specific issues, the less code and packages to worry > about, the less 'general' chance for bugs, breakage, and vulnerabilities. > > And while for I'm sure many if not most users, bandwidth and drive space are > not issues, for some, it still is. > > Regards, > Adrien > > On 9/21/20 8:59 AM, Chris Green wrote: >> On Mon, Sep 21, 2020 at 07:25:54AM -0400, D. wrote: >>> No need. https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html >>> >> OK, it's there, but I didn't find it very easily (could be me of >> course). >> Is there any major disadvantage to making it a dependency on Linux as >> well as on Windows and Mac? > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
The disadvantage would be for those users who don't want or need it and like to manage lean and clean systems. Without getting into any specific issues, the less code and packages to worry about, the less 'general' chance for bugs, breakage, and vulnerabilities. And while for I'm sure many if not most users, bandwidth and drive space are not issues, for some, it still is. Regards, Adrien On 9/21/20 8:59 AM, Chris Green wrote: On Mon, Sep 21, 2020 at 07:25:54AM -0400, D. wrote: No need. https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html OK, it's there, but I didn't find it very easily (could be me of course). Is there any major disadvantage to making it a dependency on Linux as well as on Windows and Mac? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
I'm pretty sure that *is* documented on the Wiki build pages, or at least used to be. I once built on Ubuntu and found that option on the Wiki to get it working. I was lightly following some Wiki Build Instruction discussion on IRC recently and I think that very option (with needed dependency) was pointed out as not being quite obvious. Check out the Build on Linux pages (along with the sub-pages about dependencies) and read their Talk sections for more current info and state of the edits. Regards, Adrien On 9/21/20 2:47 AM, Chris Green wrote: On Sun, Sep 20, 2020 at 11:19:42PM -0500, Adrien Monteleone wrote: See my other reply about versions and database support. I've been using SQlite3 since the 2.6.x days. The build instructions on the wiki are very good. The most time will be spent reading and making sure you have the build environment and dependencies. If you get that right, the actual build is fairly quick and painless. It was all a bit of a non-event really, what I *actually* needed to do was add a library that GnuCash needs for sqlite to work. It (the library) doesn't get installed by default because it's not listed as a dependency. For information the library needed is called libdbd-sqlite3 in the Debian/Ubuntu Linux world. Where should/would this be documented? I'm happy to put things in motion to get it done if it isn't already. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
On Mon, September 21, 2020 9:59 am, Chris Green wrote: > On Mon, Sep 21, 2020 at 07:25:54AM -0400, D. wrote: >> No need. >> https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html >> > OK, it's there, but I didn't find it very easily (could be me of > course). > > Is there any major disadvantage to making it a dependency on Linux as > well as on Windows and Mac? No; just that it's up to every package maintainer to do it, and we do not have any control over that. You can petition with your package-maintainer-of-choice to add the dependency. > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
On Mon, Sep 21, 2020 at 07:25:54AM -0400, D. wrote: > No need. https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html > OK, it's there, but I didn't find it very easily (could be me of course). Is there any major disadvantage to making it a dependency on Linux as well as on Windows and Mac? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
No need. https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html Original Message From: Chris Green Sent: Mon Sep 21 03:47:20 EDT 2020 To: gnucash-user@gnucash.org Subject: Re: [GNC] Can't "Save As" to sqlite, is it a compile option? On Sun, Sep 20, 2020 at 11:19:42PM -0500, Adrien Monteleone wrote: > See my other reply about versions and database support. I've been using > SQlite3 since the 2.6.x days. > > The build instructions on the wiki are very good. The most time will be > spent reading and making sure you have the build environment and > dependencies. If you get that right, the actual build is fairly quick and > painless. > It was all a bit of a non-event really, what I *actually* needed to do was add a library that GnuCash needs for sqlite to work. It (the library) doesn't get installed by default because it's not listed as a dependency. For information the library needed is called libdbd-sqlite3 in the Debian/Ubuntu Linux world. Where should/would this be documented? I'm happy to put things in motion to get it done if it isn't already. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
On Sun, Sep 20, 2020 at 11:19:42PM -0500, Adrien Monteleone wrote: > See my other reply about versions and database support. I've been using > SQlite3 since the 2.6.x days. > > The build instructions on the wiki are very good. The most time will be > spent reading and making sure you have the build environment and > dependencies. If you get that right, the actual build is fairly quick and > painless. > It was all a bit of a non-event really, what I *actually* needed to do was add a library that GnuCash needs for sqlite to work. It (the library) doesn't get installed by default because it's not listed as a dependency. For information the library needed is called libdbd-sqlite3 in the Debian/Ubuntu Linux world. Where should/would this be documented? I'm happy to put things in motion to get it done if it isn't already. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
See my other reply about versions and database support. I've been using SQlite3 since the 2.6.x days. The build instructions on the wiki are very good. The most time will be spent reading and making sure you have the build environment and dependencies. If you get that right, the actual build is fairly quick and painless. Regards, Adrien On 9/13/20 9:44 AM, Chris Green wrote: On Sun, Sep 13, 2020 at 03:34:10PM +0100, Chris Green wrote: I am running GnuCash 3.8 Build ID: 3.8b+(2019-12-29) on [x]ubuntu 20.04. I have started keeping a small PCC accounts with this but decided I wanted to move to storing the data in sqlite rather than the default XML. It doesn't seem to be possible, if I click on SaveAs in the File menu the only Data Format I'm offered is XML. Is this because sqlite storage is a compile time option that hasn't been included in the Ubuntu build, or is there something else I need to do? Ah! I've just seen that sqlite is only supported from version 4.2 and I'm on version 3.8, so that explains it! Does anyone have any experience of getting GnuCash >4.2 working on [x]Ubuntu? Is it easy to compile/build? (I do have a fair amount of experience, I used to build my own Linux kernels etc.) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
Version 2.4, not 4.2, which is not out yet. Regards, Adrien On 9/13/20 9:57 AM, Chris Green wrote: On Sun, Sep 13, 2020 at 10:40:59AM -0400, Derek Atkins wrote: The SQL backend uses libdbi and that is a compile-time option. However you need runtime libraries to enable the various SQL backends to work. Most likely you don't have the appropriate SQLite database drivers installed. Search for libdbi-dbd-sqlite and similar. Thank you Derek, spot on! I needed to install libdbd-sqlite3 and now GnuCash offers to save in sqlite3. I was confused by a web site (not GnuCash) that said:- From version 4.2, Gnucash supports PostrgreSQL, MySQL and SQLite3. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
On Sun, Sep 13, 2020 at 10:40:59AM -0400, Derek Atkins wrote: > The SQL backend uses libdbi and that is a compile-time option. However you > need runtime libraries to enable the various SQL backends to work. > > Most likely you don't have the appropriate SQLite database drivers > installed. Search for libdbi-dbd-sqlite and similar. > Thank you Derek, spot on! I needed to install libdbd-sqlite3 and now GnuCash offers to save in sqlite3. I was confused by a web site (not GnuCash) that said:- From version 4.2, Gnucash supports PostrgreSQL, MySQL and SQLite3. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
On Sun, Sep 13, 2020 at 03:34:10PM +0100, Chris Green wrote: > I am running GnuCash 3.8 Build ID: 3.8b+(2019-12-29) on [x]ubuntu 20.04. > > I have started keeping a small PCC accounts with this but decided I > wanted to move to storing the data in sqlite rather than the default > XML. > > It doesn't seem to be possible, if I click on SaveAs in the File menu > the only Data Format I'm offered is XML. > > Is this because sqlite storage is a compile time option that hasn't > been included in the Ubuntu build, or is there something else I need > to do? > Ah! I've just seen that sqlite is only supported from version 4.2 and I'm on version 3.8, so that explains it! Does anyone have any experience of getting GnuCash >4.2 working on [x]Ubuntu? Is it easy to compile/build? (I do have a fair amount of experience, I used to build my own Linux kernels etc.) -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't "Save As" to sqlite, is it a compile option?
The SQL backend uses libdbi and that is a compile-time option. However you need runtime libraries to enable the various SQL backends to work. Most likely you don't have the appropriate SQLite database drivers installed. Search for libdbi-dbd-sqlite and similar. -derek On Sun, September 13, 2020 10:34 am, Chris Green wrote: > I am running GnuCash 3.8 Build ID: 3.8b+(2019-12-29) on [x]ubuntu 20.04. > > I have started keeping a small PCC accounts with this but decided I > wanted to move to storing the data in sqlite rather than the default > XML. > > It doesn't seem to be possible, if I click on SaveAs in the File menu > the only Data Format I'm offered is XML. > > Is this because sqlite storage is a compile time option that hasn't > been included in the Ubuntu build, or is there something else I need > to do? > > -- > Chris Green > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Can't "Save As" to sqlite, is it a compile option?
I am running GnuCash 3.8 Build ID: 3.8b+(2019-12-29) on [x]ubuntu 20.04. I have started keeping a small PCC accounts with this but decided I wanted to move to storing the data in sqlite rather than the default XML. It doesn't seem to be possible, if I click on SaveAs in the File menu the only Data Format I'm offered is XML. Is this because sqlite storage is a compile time option that hasn't been included in the Ubuntu build, or is there something else I need to do? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.