GnuCash PostgreSQL support

[Derek Atkins]

Tarlika Elisabeth Schmitz <gnucash5 at numerixtechnology.de> writes:

> On Mon, 30 Jan 2012 12:29:21 -0500
> Derek Atkins <warlord at MIT.EDU> wrote:
>
>>Tarlika Elisabeth Schmitz <gnucash5 at numerixtechnology.de> writes:
>>
>>> 1) speed (not too important) 
>>
>>Actually, the SQL backends are probably slower than XML.  This is
>>because GnuCash still loads all the data at the beginning.
>
> Start-up time is irrelevant to me as I only start the application once
> in the morning and GnuCash starts a damn sight faster than Firefox
> with 35 extensions! ;-)
>
> As data are all loaded at the beginning of the session, report
> generation and searches would neither be slower or faster with a SQL
> back-end?

Possibly, because the SQL backend does implement backend queries for
each lookup.  So it's doing extra processing that does not happen for
XML.

>>> 2) being able to extract my own reports via SQL
>>> 3)  I want to transpose Description and Notes
>>> of certain transactions
>>
>> this could be done by Python.
>
> I realize I could write a Python script to parse and modify the XML
> file. I just feel I'd be a little more proficient doing it in SQL as I
> have been dealing with Postgresql a lot recently.
>
> Thanks for your help, Derek.

-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
       warlord at MIT.EDU                        PGP key available