Setting up gnucash to use postgesql back end - close but no cigar ...

[Maf. King]

On Mon 9 March 15 05:28:33 YeOldHinnerk wrote:
> Hi,
> 
> now, this answer made me curious, for a couple of reasons:
> 
> 1. At least the german GnuCash wiki FAQ does say that SQLite is intended for
> home users:
> http://wiki.gnucash.org/wiki/De/FAQ#F:_Gibt_es_eine_Datenbank-Anbindung.3F
> 

Hi,

SQLite is a file format - no external server is needed.  AFAIK, gnucash with 
SQLite or XML file storage results in the same logs and backups of the file.

MySQL or Postgres are external servers and backups are not automatic, nor are 
these data store methods tested as completely as the file store back ends.


> 2. I have several applications on my NAS (and in the past for testing
> purposes also on my laptop), which use some SQL database like mysql.
> Usually, there is hardly any admin work involved. I think the suggestion of
> having to hire a professional database admin is far over the top. For many
> purposes, the use of a DB in the background is quite simple. So should I
> take this as a hint, that the integration of a DB in gnucash is not very far
> yet and requires manual steps, which could be automated?

Yeah, I think John's scenario seemed a bit "worst case" IMHO.  Point taken 
that this is financial data we're talking about, so more important to keep a 
properly secured and administered DB than the usual home LAMP stack for 
storing Catz and so on, but even so , a full-time DBA?

0.02,
Maf.