techrail/chamber
techrail/chamber
7
0
Fork 0
Code Issues 5 Pull requests Projects 1 Releases 5 Packages Wiki Activity Actions

Run VACUUM command/query for compaction of chamberfile #28

New issue
Closed
opened 2025-07-15 10:32:31 +00:00 by vaibhav · 0 comments
vaibhav commented 2025-07-15 10:32:31 +00:00
Owner
Copy link

The original idea I had was that I would run VACUUM command after every delete. But I have learnt that doing so usually means that the entire database gets rewritten. Which means that on a SSD, it would cause a lot of wear and tear and on HDDs it would take a lot of time. On any other media SD cards, Network Mounted paths etc, it would probably cause both.

Hence, I have moved the functionality to an admin page within the Web UI.

There is a pending issue for the CLI that was created: #38

The original idea I had was that I would run VACUUM command after every delete. But I have learnt that doing so usually means that the entire database gets rewritten. Which means that on a SSD, it would cause a lot of wear and tear and on HDDs it would take a lot of time. On any other media SD cards, Network Mounted paths etc, it would probably cause both. Hence, I have moved the functionality to an admin page within the Web UI. There is a pending issue for the CLI that was created: #38
vaibhav added this to the Future project 2025-07-15 10:32:32 +00:00
vaibhav modified the project from Future to Alpha 0.2.0 2025-07-18 11:14:10 +00:00
vaibhav changed title from Run VACUUM command/query after deletion to Run VACUUM command/query for compaction of chamberfile 2025-08-06 06:29:14 +00:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
bugfix/return-nil-error-open-db
106-version-bump
104-update-terms
102-fix-install-script
100-url-sync
92-deletion-msg
90-telemetry-and-nudges
94-toc-pp-webui
91-windows-launch-script
93-show-busy-when-busy
88-upgradability
55-new-ui
85-better-transaction-isolation
81-default-port
82-update-builds
78-coming-soon
copy-out-cli-bug
48-session-management
better-begintransaction
35-settings-store
73-lib-upgrade
34-randomness-fix-windows
delete-virtual-bin-file
69-readme-improvements
dockerfile-introduced
beta-1-pre-release
feature/22-file-creation-time-chamber
fix-env-render-bug
59-logo-and-cleanup
46-new-ui
chamberfile-compaction-cli
52-version-fix
install-script-linux-mac
43-http-handlers-refactor
password-hint-CLI
verify-absolute-path
alpha-2-pre-release
32-web-server
1-encryption-and-kdf
25-cli-help-fix
10-buildscript
17-package-name
21-ls-command
4-recursion
8-set-a-license
2-chamberpath-switch
3-setting-pragma-directives
v1.0.1
v1.0.0
v0.4.0
v0.3.0
v0.2.0
v0.1.0
Labels
Clear labels   
bug
Something is not working

  
duplicate
This issue or pull request already exists

  
enhancement
New feature

  
help wanted
Need some help

  
invalid
Something is wrong

  
question
More information is needed

  
wontfix
This won't be fixed

No labels
bug
duplicate
enhancement
help wanted
invalid
question
wontfix
Milestone
Clear milestone
No items
No milestone
Release Alpha 0.2
Projects
Clear projects
No items
No project
Alpha 0.2.0
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
techrail/chamber#28
No description provided.