sql version

[Derek Atkins]

On Fri, December 24, 2010 1:48 pm, Michelle Knight wrote:

> Gnucash itself is relatively easy to install and just use as it is. Add on
> top
> of it the necessity to load, configure and run an SQL engine and some
> sections
> of the user base might have difficulty.

There's very little need for users to "load, configure, and run" SQLite. 
It's just a user library.  As far as the end user is concerned, it's just
a data file.  Indeed, under the covers there's really no way for the user
to differentiate the XML vs. SQLite format, except that the file contents
are in a different format.

> At the moment, backing up Gnucash is a mater of copying the files. If
> Gnucash
> does go SQL, then it will need to add tools to make it easier for those
> who
> aren't familiar with handling databases and SQL engines.

With SQLite the backups are exactly the same; you just copy the data file.
 Just make sure GnuCash isn't running.

> Heck, it might be wise for Gnucash to come with its own SQL engine fork.

Um.  No.

We will if we have to, but I doubt SQLite is going anywhere anytime soon. 
I think Gnome will go away sooner than SQLite.

You have to have some dependencies.  With an application as large as
GnuCash you HAVE to use other toolkits.  Even Firefox and OpenOffice use
other tools and libraries.  And like them, we distribute those tools and
libraries with the installers on Windows and Mac.  But I do not think we
need to include a copy of SQLite in our sources.

> Michelle.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek