On 12/12/2017 00:41, Charles Sliger wrote:
On Mon, 2017-12-11 at 16:01 -0800, John Ralls wrote:
On Dec 11, 2017, at 2:27 PM, Charles Sliger <c...@bctonline.com> wrote:
I'm starting to migrate from QuickBooks to GnuCash.
I'm working my way through the integration issues with
Gnucash - Python - Postgresql
How would the GnuCash team prefer that I document this for the benefit
of others?
I've got about 30 years of unix/database/network systems engineering
under my belt and without that to draw on I don't think I would be able
to work my way through this as the documentation seems rather sparse and
fractured.
I'll have to document it for my own purposes anyway so let me know if
there's interest.
Chaz,
Can you outline what you propose to document? Integration with QuickBooks
doesn’t really make sense to me and SQL servers have plenty of documentation
themselves as well as hundreds of books and websites teaching how to administer
them. Repeating any of that in our documentation would be pointless.
Regards,
John Ralls
John,
What I will be documenting is the actual nuts and bolts process for
using GnuCash, Python, and Postgresql together. Integration is probably
too strong a word right now but I see these three as being very
complementary. While it might be true that all of the information is
out there somewhere, I have had to make a number of educated guesses in
the process of just getting GnuCash and Postgresql working together.
This was after purchasing and reading all three books on GnuCash and
spending a good deal of time with on-line research. Most people are not
going to have the time to become dba's in order to reap the benefits of
an RDBMS such as Postgresql. I find they can benefit from having the
documentation for something like this pulled together in a single
narrative. Given that the average PC today can easily handle running a
combination like this, it seems natural to leverage the capabilities of
a database like Postgresql.
Soooo... I just thought I'd ask if there was a place put this kind of
information and a process for getting it there.
In addition to what others have said, I add the following:
of the available sql stores postgres (much as I love it) is the least
used in this community, what that means in practical terms is that any
sql you end up doing has to work on sqlite too to be of interest or use
to the best of my knowledge no one has got gnc and python working
consistently on windows; given that we're changing versions I suggest
that as a newcomer you don't even start on that until you can get gnc to
build consistently. <-- not a joke, gnc + win + python is challenging
and if you do get it to work, it breaks the moment anyone changes anything
not all bad news if you want to play gnc and python, though.
Sebastien has done good work if you look at
https://piecash.readthedocs.io/en/latest/
but also understand that you must not write to gnc unless you really,
really know what you are doing.
Have fun
--
Wm
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
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.