dbback 0.1.0

A CLI tool to manage database snapshots

Dbback

CLI Tool for clean and easy way of managing databases

The goal of this project is to ensure we can revert the problems made by an intern at a DB level like Truncate table.

The tech stack is using python as a programming language and using Click as a framework while using rich library for styling table for clean views

For ease there are mainly 3 commands being add, delete and list for all groups in the Tool which are explained below

Groups

1. Connection

The First group for estabilishing connections to the DB for esnsuring we can track the tables. This is the first step to later track and maintain the tables. Details required are

1. Project Name for ID
2. DB type currently MySQL
3. Host and Port for Connections
4. Username and Password
5. DB Name

The commands possible are

1. add
2. delete
3. list

2. Table

For adding tables to the connections that we have established already. Here we simply establish a table for storing snapshots and is a necessary step as well.The commands possible are

1. add
2. delete
3. list

3. Snapshot

Finally having created a connection and listed tables, we can take snapshots and store them for later use.

1. add
2. list
3. restore

A unique ID is given to each snapshot during its addition and can be visible when listed , this ID is used to restore and taken as an input.

Additional Informations

A folder is created in local C drive for storing the metadata for each user and also the snapshots taken. In further versions , we can remove the local usage and go for a cloud based approach.

Scope for Improvement

Following can be implemented in further versions

1. More Database Options
2. Ability to use snapshots remotely
3. Cloud based storage of Snapshots