Is is OK to snapshot the sqlite files on, say, the last day of the month, and keep it forever? That is, what's the file locking approach used by Indigo/SQL Logger plugin? If not, would a simple script that shuts down the plugin, copies the file, and restarts do the trick?
The goal is to have much longer archives, but not expand the active operating SQLLogger file, or deal with the hassle of a real sql server.
thanks!