Pending snapshot and increment

[edxu96]

By default, SQLite operates in auto-commit mode. It means that for each command, SQLite starts, processes, and commits the transaction automatically.

• [x] read SQLite Transaction, sqlitetutorial
• [ ] recover the pending snapshot with pending_snapshot
• [ ] able to begin the transaction based on different sets of snapshot(s)