Thanks Richard, I first saw a reference from the mailing list back in May 2014. I've been reading the list since April 2010.
I'm not much of a C programmer, but I will let you know. I'm working on adding "comments" or tags to accompany the filenames. For example, the file "/mnt/KCYPictures/Pictures/Amys_tablet/Camera/20130727_204615.jpg" is a picture of my daughter with he grandmother. So, if I wanted to see files related to my daughter or her grandmother or both together, a simple SQL query would help. I was also interested in the concept of adding and removing files incrementally, without having to read in an entire archive and the rewriting the entire archive. The application which precedes the archive function is where I take a Linux LS listing and convert it into an SQLite database. I also add "comments" and MD5SUMs of the files. I then compare the current LS SQLite database with a previous one. I generate new MD5SUMs for new and modified files, and carry forward comments and MD5SUMs for the unchanged files. The MD5SUMs tell me when a file has a different name, different date or has moved folders. I will then add the new and overwrite the modified files in the SQLAR archive. regs, Kev On 3/29/16, Kevin <kyouren at gmail.com> wrote: > Richard, > > Just a note of thanks for the SQLAR tool. I'm glad you find it useful. Really is it just a proof-of-concept. If you are a C programmer and would like to try to enhance it, write to me and I'll get you check-in privileges on the respository. So where did you hear about SQLAR? -- D. Richard Hipp drh at sqlite.org
