Can we take a snapshot of SQLite with this library?

[tisonkun]

Just like RocksDB and take snapshot. I'd like to combine SQLite with consensus system so a collaborative snapshot is significant.

Otherwise, SQLite is continuously change the data file and during a crash and recover, data can be inconsistent.

Ref code snippet -

    @Override
    public long takeSnapshot() {
        final var latestIndex = getLastAppliedTermIndex();
        final var directory = storage.getSnapshotDirectory(latestIndex);
        if (db != null) {
            try (final var checkpoint = Checkpoint.create(db)) {  // <- this line
                final var path = directory.getAbsolutePath();
                checkpoint.createCheckpoint(path);
                log.info("successfully create snapshot for index: {}, path: {}", latestIndex, directory);
                return latestIndex.getIndex();
            } catch (RocksDBException e) {
                log.warn("cannot take snapshot for index: {}", latestIndex, e);
            }
        }
        return RaftLog.INVALID_LOG_INDEX;
    }