On 22 February 2018 at 18:36, Fran_3 via gnucash-user < gnucash-user@gnucash.org> wrote:
> Scott, > Thanks for your comments. As I mentioned to Adrien, I don't think I'm > going to charge off and start developing my own gnuCash queries using any > tool. We are going to just use it out of the box and develop work-arrounds > where necessary > In that case I don't think there is any point doing anything other than sticking to the default XML format. Colin > We are still learn the application but so far really like it. > Thanks again for the help. > Fran3 > > On Thursday, February 22, 2018, 10:31:02 AM EST, Derek Atkins < > warl...@mit.edu> wrote: > > Hi, > > Fran_3 via gnucash-user <gnucash-user@gnucash.org> writes: > > > Re: Converting to MySQL... > > When I develop in MySQL on Windows I install IIS localhost server and > MySQL... but that is not practical on other office computers. > > 1 - I'm not familiar with sqLite but a quick Google makes me think it is > a way to run MySQL on a local PC without running server software like > IIS... right? > > 2 - Or is sqLite a desktop version of MySQL that requires no server? > > 3 - Also, it looks like PieCash is a collection of Python programs... > right? > > 4 - And if so then you simply have to have the Python interrupter > installed on your machine and then run the appropriate PieCash program > after editing in the name and path to the gnuCash file... right? > > Thanks again Adrien. > > Fran3 > > SQLite is not MySQL. And MySQL is not IIS. > > SQLite is a software library than implements a SQL-based DB within a > local file. So from a USER'S perspective, you get a single file (just > like you get a single file with the current XML backend). However > internally the data is stored and accessed like a SQL datastore. > > Down the road, I expect SQLite to become the "default" storage > mechanism, because you get all the benefits of SQL (save-on-commit, etc) > without the drawbacks of requiring a DBA or running server that you need > to configure. > > For #3/#4, yes, PieCash is a python library that re-implements a bunch of > gnucash functionality. Note that it does NOT use the GnuCash API, so > it's quite possible that using PieCash could destroy your data. YMMV. > You are safe using it for read-only purposes. > > The GnuCash developers always say that the only supported means to > manipulate your GnuCash data is via the GnuCash API. > > > 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, SB '93 MIT EE, SM '95 MIT Media Laboratory > Member, MIT Student Information Processing Board (SIPB) > URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH > warl...@mit.edu PGP key available > > _______________________________________________ > 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.
