Re: [GNC-dev] Deprecation of XML file

2020-09-15 Thread Kevin Buckley
On Mon, 14 Sep 2020 at 14:18, Stefan Bluhm wrote: > > Is there a reason to keep supporting the XML file in future? More than "a reason", singular. Here are two that come to my mind, based on past usage: 1) It's a lot simpler to perform XSLT actions on an XML file than it is an SQLite file 2)

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Christopher Lam
Just my 2p here. I am a staunch XML user... despite its flaws and too many namespaces, it has simplicity in viewing/editing with any text editor. Save/Reload can be done safely with SQLite Rollback mechanism https://sqlite.org/wal.html -- with this facility I'd expect that datafile modification

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Mike Evans
> The *main* benefit of SQL storage is that you get immediate saves. I.e., > when you commit a transaction, it gets saved to storage immediately. So > -- no lost work. This is exactly why I *don't* use a database for storage. I often screw up entering data. I don't save until I'm happy I've

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Jim DeLaHunt
Stefan: On 2020-09-14 12:38, Stefan Bluhm wrote: Thank you all for the feedback. Let me please summarise your demands for XML and comment on that (I hope I didn't leave any comments out). Always keep in mind that in this case we are talking SQLite as a file type, just like XML. Not about the

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread David Carlson
; SQLite DB. > > Now we can decide what step 2 is and work on that with less risk/a solid > base. Maybe parallel SQL and QOF implementation? Or the bit by bit SQL > migration? Or full QOF replacement. > > > What are your thoughts on that approach? > > > Best wishes, >

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Stefan Bluhm
: "Stefan Bluhm" An: "gnucash-devel" Gesendet: Montag, 14. September 2020 08:11:09 Betreff: [GNC-dev] Deprecation of XML file Hello GnuCash Team, Is there a reason to keep supporting the XML file in future? Wouldn't it be easier to force save the data to SQlite to tackle t

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Stephen M. Butler
I for one use the XML back-end.  --Steve On 9/13/20 11:11 PM, Stefan Bluhm wrote: > Hello GnuCash Team, > > Is there a reason to keep supporting the XML file in future? Wouldn't it be > easier to force save the data to SQlite to tackle the move from QOF? > > The benefit of point in time save

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Derek Atkins
Hi, On Mon, September 14, 2020 11:54 am, jean laroche wrote: > I too like the ability to manipulate the xml file directly, so I'm > attached to it. > Can someone explain the benefits of SQL vs XML? > Is it faster? The *main* benefit of SQL storage is that you get immediate saves. I.e., when you

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread jean laroche
I too like the ability to manipulate the xml file directly, so I'm attached to it. Can someone explain the benefits of SQL vs XML? Is it faster? I know it allows simultaneous access by multiple users, but is that a realistic usage scenario for GC? Would it help implementing a real undo/redo

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Derek Atkins
HI, A long long time ago (in a galaxy not too far away)... The __plan__ was to not eliminate XML but relegate it to an import/export format, but to change the default "File" method to SQLite. The reasoning is that SQLite, unlike other SQL-based backends, provides the user with a single-file

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Chris Graves
If the backend were to be switched to SQL, perhaps there could be menu options providing the ability to import from XML and to export to XML. I believe the macOS and Windows builds include Sqlite. Chris ___ gnucash-devel mailing list

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Michael or Penny Novack
Is there a reason to keep supporting the XML file in future? Wouldn't it be easier to force save the data to SQlite to tackle the move from QOF? The benefit of point in time save (instead of transactional save) could be achieved by working from a copy instead. Probable issue would arise

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Frank H. Ellenberger
Stefan, just a few thoughts: Am 14.09.20 um 08:11 schrieb Stefan Bluhm: > Hello GnuCash Team, > > Is there a reason to keep supporting the XML file in future? I am happy with it since ~20 years. It can be easy analyzed by a simple grep or more advanced (XSLT, XPATH, …) commands. I can use

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Jim DeLaHunt
On 2020-09-13 23:11, Stefan Bluhm wrote: Is there a reason to keep supporting the XML file in future?… I will give you three of my reasons for being glad I can store my GnuCash data in XML form: 1. All the data is in one data file in a known location. If I want to back my bookkeeping up

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread Stefan Bluhm
be bundled with the GnuCash release then. Best wishes, Stefan Von: "David H" An: "Stefan Bluhm" CC: "gnucash-devel" Gesendet: Montag, 14. September 2020 09:10:30 Betreff: Re: [GNC-dev] Deprecation of XML file Yeah cos some of us users use the xml backend exc

Re: [GNC-dev] Deprecation of XML file

2020-09-14 Thread David H
Yeah cos some of us users use the xml backend exclusively and have no intention of jumping through hoops to install and maintain some version of sql :-). In my case I run GnuCash on Ubuntu, MacOS and Windows depending on where I am and how the mood takes me. So easy to sync 1 file on Dropbox.

[GNC-dev] Deprecation of XML file

2020-09-14 Thread Stefan Bluhm
Hello GnuCash Team, Is there a reason to keep supporting the XML file in future? Wouldn't it be easier to force save the data to SQlite to tackle the move from QOF? The benefit of point in time save (instead of transactional save) could be achieved by working from a copy instead. Probable