Skip to content

Latest commit

 

History

History
8 lines (8 loc) · 1.65 KB

README.md

File metadata and controls

8 lines (8 loc) · 1.65 KB

Consistency

Sqlite-incremental-Backup

This is an utility library that incrementally backup SQLite3 Database. This approach was proposed by a StackOverflow User which I turned into code. Currently the library may be used in two languages NodeJs and Python (C support is Coming soon).

Background

SQLite3 is one of the most popular relational databases (and built-in Python) in this tech world. Many organizations use it at the production level because of its lightness, robustness, and portability. Using at the Production level also requires an efficient backup system in order to prevent data corruption, data loss, and whatnot. As SQLite3 is solely based on a single file, backing up requires the whole file to be copied on each backup (or, snapshot). It requires unnecessary space to save all the snapshots (for a slightly modified version). So, there is the solution, Incremental Backup System. In this system, the database is backed up only when the file content changes, therefore saving much space. I personally browsed over the internet to find any incremental backup system (even unofficial) but a Stackoverflow Thread. So, I wrote myself a lightweight utility/library/module to backup incrementally and save some space while processing a huge amount of database backup.

Documentation

NodeJs

Refer to Nodejs Documentation