Releases: iphousehq/sql-prune
Releases · iphousehq/sql-prune
Targeting .net 8.0 and updated dependencies
System.CommandLine
Now leveraging System.CommandLine (and .net core)
- The syntax to run the tool has changed slightly.
- The source code now includes a lambda function (that could be deployed and triggered with a cloudwatch event on a schedule for example).
Updated dependencies
Updated all dependencies, including AWS. We now read AWS credential details from more places, including the Role and EC2 Instance has.
Handling of different backup file extensions
- New optional parameter -file-extensions.
- File extensions defaults to *.bak.
- Comma separated values can be used (e.g. -file-extensions .bak,.bak.7z to process .bak and .bak.7z files).
- Fixed bug preventing from restoring files with an extension different from *.bak.
Handling of different backup file extensions
- New optional parameter
-file-extensions. - File extensions defaults to
*.bak. - Comma separated values can be used (e.g.
-file-extensions *.bak,*.bak.7zto process.bakand.bak.7zfiles).
Recover backup for a given day
Can now recover the most recent back for a given day (without specifying the date and time).
Updated dependencies
No new features. Just updated our sugar dependency and added licensing and contributing info.
Faster downloads
- Using AWS SDK's TransferUtility class to download the .bak files from S3 a lot faster (multi threaded download).
- Using modularised version the AWS .NET SDK to reduce the footprint of the utility.
Database names with underscores no longer ignored
Fixes a bug that was making the tool ignore database names with underscores.
- The size summary at the end of the command now outputs the sizes in bytes as well as in human readable values (e.g. 15.6 MB).
S3 Support
Pruning .bak files in an S3 bucket is now possible.
- RTFM to see how to set your amazon credentials. Can still prune a local folder; if you only want to do that, ignore the amazon bits completely.
- Changed the pruning rules.
- Size of files and size summary (in bytes) are output by the program.