DBMS Cleaner is a program made to be run on the backend of a server or an application to clean the database. It will reduce the storage of the database and optimise all tables except system tables. It is a simple and efficient way to keep your database clean and optimised without having to do it manually. It is a great way to keep your database running in the best conditions possible. Using Go language, it is compatible with all platforms and can be run on any server or application.
- Reduce storage of the database
- Optimise all tables except system tables
- Simple and efficient way to keep your database clean
- Compatible with all platforms
- Maintain your database in the best conditions possible
- Don't require any dump or backup
- Don't modify your files configuration
- Easily run on any server or application
- Easy to use
To run the program :
- Clone the repository:
git clone https://github.com/Maxime-Cllt/GoSqlCleaner.git- Import the libraries:
go mod tidy- Compile the program:
go build -o GoSqlCleaner- Run the program with the following your database information:
You need to create a file named config.json in the same directory as the program with the following content:
{
"driver": "mysql|mariadb|postgres",
"host": "localhost",
"port": "3306",
"username": "root",
"password": "password",
"database": "testdb"
}Replace the values with your database information. This information are only used to connect to the database and perform the cleaning.
- Then run the program with the following command:
Change the permission of the file:
chmod +x GoSqlCleanerExecute the program:
./GoSqlCleanerExecute the program:
GoSqlCleaner.exe- Time complexity: O(n) where n is the number of tables in the database
- Don't clean triggers, stored procedures, functions, and views
- May not reduce much storage but don't cost much time to run and can be run frequently
- Require some privileges to connect to the database and to perform the cleaning