[GNC] Question about gnucash

[John Ralls]

> On May 30, 2022, at 3:27 AM, stephen.lohning at oxnee.com wrote:
> 
> Dear gnucash-user,
> 
> 
> 
> I have a question is there any documentation about installing and creating
> report via Scheme. I assume that it is interpretive language so that once it
> is installed in in the correct directory it will be visibly to use.
> 
> 
> 
> I have tried to connect it to PostgreSQL but I have not had any success, I
> know that my PostgreSQL is working correctly as I use for Django
> development, I tried the sqlite3 that seems to work but I don't know where
> the db file is created as I have a sqlite browser 
> 

For custom reports, https://wiki.gnucash.org/wiki/Custom_Reports is a good starting point.

For pgsql if you're a Linux user you may need to install libdbd-pgsql; note that that's what Debian calls it, other distros may have slightly different names.

The SQLite3 file is created wherever you told GnuCash to create it in the File>New or File>Save As dialogs.

Regards,
John Ralls