Coming soon: KMyMoney 1.0

Posted Aug 28, 2009 16:43 UTC (Fri) by jordanb (guest, #45668)
In reply to: Coming soon: KMyMoney 1.0 by astrophoenix
Parent article: Coming soon: KMyMoney 1.0

One thing to keep in mind about sqlite is that the 'database' is just a file on the file system, and you can use the 'sqlite3' tool to open up and poke around in any sqlite file.

Actually if you're trying to manipulate the data 'out of band', or make an external tool that acts on a program's data, then sqlite is a dream format since it gives you a very powerful structured data manipulation interface (the SQL language).

If you want to keep the data in version control, you can do a data dump from the database file into a text file and then check *that* into VCS:

echo ".dump" | sqlite3 grampsdb > my_gramps.sql

You can also do that, of course, and use your regex masher on that sql file, and then import it back into the database. ;)

Coming soon: KMyMoney 1.0

Posted Aug 28, 2009 16:48 UTC (Fri) by dlang (guest, #313) [Link]

one advantage to manipulating things in SQL rather than in a flat file is that you don't have to worry as much about the structural elements (field seperators, allowed characters, field lengths, etc) as the app can (and should) have this data managed by the database engine.