[GNC-dev] [GNC] ofxtools - a Python OFX library

Sébastien de Menten sdementen at gmail.com
Fri May 31 12:34:21 EDT 2019

Hello Christopher

I am the dev of piecash. Regarding the second resolution of datetime, I
think I got it by reverse engineering the SQL database format for gnucash
books (you can check by introspecting the DB or the XML). Why do you need
this very high resolution? I think most of the datetime elements in gnucash
are in fact days represented as datetime with some convention for time
(12:00 UTC or more complex logic).

On Fri, May 31, 2019, 15:19 Christopher Singley <csingley at gmail.com> wrote:

> Is it a good experience keeping GnuCash books in a SQL backend? There's
> much better Python tooling if you can make the interface at SQL.
> Looks like there's piecash, a SQLAlchemy frontend for GnuCash. This
> looks promising.  It's got good docs, too.
> Is the piecash documentation correct that the GnuCash datetime type is
> limited to resolution of seconds rather than microseconds?  That would
> be unfortunate.
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel

More information about the gnucash-devel mailing list