Postgres on Windows

Sat Jul 4 21:41:03 EDT 2009

Phil Longstaff wrote:
> If you remove libdbdmysql.dll from the gnucash install, it would 
> probably not try to load libmysql.dll, and so that error would go away. 
> Or, you can just ignore the error.

For now, ignoring works for me.  I'll try to remove it next time I 
build.  What's your plan for the final release?

(I think my Postgres install is typical, and it wasn't in my PATH.  I 
also notice that the c:\soft\pgsql\lib folder has a copy of libpq.dll, 
though it wasn't being found here.  Unless your last two commits covered 
off that issue (I'll find out when I rebuild) there may still be an 
issue picking up the DLL properly.)

>  > Busily testing... I've got 5341 transactions of QIF data to import and
>  > sort out so that should let me kick a few of the tires. :)
>  >
>  > Anything in particular I might be able to help test out? I expect to be
>  > using this for production purposes (with careful backups and monitoring)
>  > in the near future.
> 
> 
> Do you know how to use logging? I'm not sure where it goes on windows, 
> but you should have a .gnucash directory somewhere (under Documents and 
> Settings\user)? 

I don't know how to use anything yet. ;-)  But that is the correct 
location for the .gnucash folder (it's under c:\users\<user>\.gnucash on 
Vista).  What I can't find is a log.conf file (anywhere under there, or 
under c:\soft).  I'm still reading over even basic Gnucash documentation 
so I'll stumble over that at some point soon I'm sure.

 > If you add "gnc.backend.dbi=debug" to the log.conf file
> (or add --log gnc.backend.dbi=debug" to the command line, all SQL 
> statements will be logged into your gnucash.trace file (on windows, 
> gnucash.trace.XXXXXX is put into Documents and Settings\user\Local 
> Settings\Temp, XXXXXX is a 6-char item).
> 
> I've done some basic testing with all dbs, but have really only used 
> sqlite3. I don't know how queries will perform on the other dbs. What 
> indexes will be needed?

So far the only thing that isn't nearly instantaneous is bringing up the 
General Ledger then changing Filter By to Show All.

Also, attempting to generate a Net Worth Barchart resulted in many 
minutes of the app "Not Responding", followed by an empty chart. 
(Exporting that produced a bogus .html file with a tiny bit of binary 
data stuff into the <body>.)  I doubt that was database-related delay.

>  From what I know, all of the basic data entry works. I haven't tested 
> the business reports which large amounts of data. Recently, I rewrote 
> the basic split query based on feedback from a postgresql user. If you 
> find adding a specific index helps performance, let me know. At this 
> point, gnucash is *NOT* a db app using foreign keys, so there are no 
> foreign key defs.

I read your other post making that last point, and understand what you 
mean.  I've written other PG-connected apps that work similarly.

I'll keep folks posted on what I manage to learn/find/test.

-- 
Peter Hansen, P.Eng.
Engenuity Corporation
416-617-1499