Change storage format of existing data

[David Carlson]

I am not a developer, just a user that knows enough to be very dangerous...

>From my perspective, the SQL back-ends have very little value beyond
exposing the data to some limited SQL queries.  The commonly known features
of most SQL databases like multi-user access and loading only the data
needed rather than the entire database are yet to be implemented.  The
developers warn that data should only be saved through the GnuCash front
end because relationships are not defined in the database but in the
GnuCash code.  Back-ups are not implemented at all, unlike the XML backups,
which still do not back up user configurations.

I agree with David T, however, that it is time to lay the cards on the
table so users can see the advantages, disadvantages and proceed with due
caution if that is what they want to do.  For myself, I am staying with XML
until the SQL structure is developed to the point of permitting multi-user
access, partial data loading and data writes via other front-ends.

David C

On Sun, Jan 29, 2017 at 9:50 AM, David T. via gnucash-user <
gnucash-user at gnucash.org> wrote:

> Rich,
>
> In addition to --enable-dbi, you need to install the libdbd libraries
> (libdbi-dbd-mysql, libdbi-dbd-postgresql and libdbi-dbd-sqlite), which John
> implied.
>
> David
>
> > On Jan 29, 2017, at 8:43 PM, Rich Shepard <rshepard at appl-ecosys.com>
> wrote:
> >
> > On Sat, 28 Jan 2017, John Ralls wrote:
> >
> >> apt-get install libdbd-sqlite3 libdbd-mysql libdbd-pgsql
> >
> > John,
> >
> >  Thanks for the above. Looking for a slackware solution led me to
> > <https://wiki.gnucash.org/wiki/Slackware#Requirements>, specifically to
> the
> > section "Slack 14.1 + GnuCash 2.6.X" where I learned that the SlackBuild
> > script requires --enable-dbi as a configuration option.
> >
> >  That option is not in the default script (neither is --disable-dbi), so
> I
> > added it, rebuilt, and reinstalled 2.6.15.
> >
> >  With my existing file there's still no postgres option displayed in the
> > Save as dialog.
> >
> >  Are data file format options available only when a file is created and
> not
> > retroactively?
> >
> > Regards,
> >
> > Rich
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>