Somewhat terse, but I like it. David C
On Thu, Aug 16, 2018 at 3:00 PM, David T. via gnucash-user < [email protected]> wrote: > I’ve attempted to incorporate the suggestions that others have made for > the section on file storage formats, and I attach the resulting version 2 > for further consideration. Keep in mind that this is not meant to be an > encyclopedic coverage of the topic; it’s meant to outline the choices. I > expect further detail to reside on the wiki, or be placed in other places > in the documentation. > > Cheers, > David > > P.S. The table layout doesn’t come through, but will be in the final > version… > > > ———————————— > > 2.5 Storing your financial data > 2.5.1 Overview > GnuCash offers several formats for storing your financial data. The > default file storage format is XML, while SQL storage is available in > SQLite, MySQL, and PostgreSQL formats. Users can choose a file format from > the File→Save and File→Save As dialogs. > The XML storage format is a text file that is compressed with gzip, which > is a preference that is set at Edit→Preferences→General→Use file > compression. SQL storage is available via the DBI back end; use of MySQL > and PostgreSQL requires installation of those DBMS packages as well as > additional DBI drivers. > Note: users can change the format at any time by using File→Save As. This > will create a copy of the data file in the selected format. > > Storage Comparison > Each storage format has benefits and shortcomings that the user should > consider for their needs and abilities. See the Storage Comparison Table > below for further details. > The XML format is the most stable and established, and for this reason, it > is recommended for most users. SQL storage was added for the 2.4 release > and has become an increasingly popular choice for users, but can require > experience with DBMS applications. > Note: Use of a SQL back end for storage implies to many that GnuCash has > fully implemented DBMS features, including multi-user and incremental data > manipulation. However, GnuCash does not currently implement these > features, although it is a long term goal of the development team. > > Storage Comparison Table > > > XML > SQLite > MySQL > PostgreSQL > Installation > Default > libdbi - 1 > libdbi > libdbi > File extension > gnucash > gnucash > N/A - 2 > N/A - 2 > Additional software > None > None > MySQL > PostgreSQL > Additional expertise > None > None > DBMS > DBMS > Compression > Y > N > N > N > Save on command > Y > N > N > N > Save on commit > N > Y > Y > Y > Uses log files > Y > N > N > N > Multi-user > N > N > N > N > > 1 - SQLite relies on libdbi, but is available by default on Mac OS and > Windows. Linux users may need to manually install libdbi drivers for SQLite. > 2 - MySQL and PostgreSQL place data in their own storage. > _______________________________________________ > gnucash-user mailing list > [email protected] > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > 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 [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
