Skip to content

This is an utility script that incrementally backup SQLite3 Database. This approach was proposed by a Stackoverflow User which I turned into code. Currently the script may be run in two language NodeJs and Python. I am willing to convert this as a module. Feel free to convert into any language and let me know

License

Notifications You must be signed in to change notification settings

nokibsarkar/sqlite3-incremental-backup

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

68 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

This is an utility script that incrementally backup SQLite3 Database. This approach was proposed by a Stackoverflow User which I turned into code. Currently the script may be run in two language NodeJs and Python. I am willing to convert this as a module. Feel free to convert into any language and let me know

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published