SQlite Cleaner is a program made to be run 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 Rust, it is compatible with all platforms and can be run on any server or application. Check in the releases to download the program.
- Reduce storage of the database
- Optimise all tables except system tables
- Simple and efficient way to keep your sqlite 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/SqliteCleaner.git- Build the program:
cargo build --release- Execute the program:
You may need to give the program the right to execute on linux and macOS:
chmod +x target/release/SqliteCleaner./target/release/SqliteCleaner "path/to/your_database.db".\target\release\SqliteCleaner.exe "path/to/your_database.db"- 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