On 13 Nov 2009, at 4:03pm, Robert Rawlins - Think Blue wrote: > What tasks would you recommend running on a SQLite database and on what sort > of regularity? I know that's a bit of a 'how longs a piece of string' type > question but I'm just trying to understand if a SQLite database requires the > same sort of attention as others or whether it's simple and robust nature > means it can be left alone.
Keep cumulative backups of your database files the same as you'd do for any files. Do a PRAGMA integrity_check every few months. That's it. For more details see <http://www.sqlite.org/pragma.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
