the sqlite song db format is quite handy for searching, but cumbersome when comparing two dbs on a per song basis.
Our scenario: We'd like to have an online song repository. Several contributors can add or delete songs, fix typos and upload the modifications to this repository. In return they should be able to update their lokal working copy of the song db. This would be easy to implement, if the songs were stored in plain text files (with rsync, unison or even svn or alike). It seems, however, rather tricky to manage that with the openlp db format, since the db scheme doesn't keep track of the modification dates of the songs.
Any ideas? Thanks, Thomas