Tiffany, You might experiment with some smallish databases. The order of records may well change significantly from dump to dump, making the apparent differences and the actual differences between any two dumps appear much larger than they really are.
Good luck! On Fri, Aug 10, 2018 at 12:49 PM Tiffany A. Timbers via discuss <[email protected]> wrote: > > Thanks all for your input - very helpful! Dav - happy for you to questions > the general strategy. As I said, I know very little about this. In my case > its a smallish, simple SQLite database with ~ 8 tables. So > dumping/transaction logs/etc might work well and easily. But if there's a > better and different strategy for checkpointing SQLite databases, I'd love to > learn. > > Thanks! > Tiffany > The Carpentries / discuss / see discussions + participants + delivery options > Permalink ------------------------------------------ The Carpentries: discuss Permalink: https://carpentries.topicbox.com/groups/discuss/Ta7250f4266e508c5-Mb0ae3c22005b6cfbf5866889 Delivery options: https://carpentries.topicbox.com/groups/discuss/subscription
