Vacuuming
Nobody has claimed this yet.
Assessment
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Newbie friendliness
- 68/100
Research direction
Start at mergin/utils.py line 99 and read the linked GDAL GeoPackage and SQLite VACUUM guidance. Check how the current logic decides whether vacuuming is worthwhile, including GeoPackages without a -wal sidecar. Done means the decision covers that case without unnecessary vacuuming; validate with the project's existing tests.
Written by the indexing model from the issue text.
Description
https://github.com/MerginMaps/python-api-client/blob/master/mergin/utils.py#L99
Vacuuming could be useful even for gpkgs without the -wal sidecar
Vacuuming takes some time, so we should check that it is worth it.
Sources
https://gdal.org/en/stable/drivers/vector/gpkg.html
When dropping a table, or removing records from tables, the space they occupied is not immediately released and kept in the pool of file pages that SQLite may reuse later. If you need to shrink the file to its minimum size, you need to issue an explicit "VACUUM" SQL request.
https://sqlite.org/lang_vacuum.html
When content is deleted from an SQLite database, the content is not usually erased, but rather the space used to hold the content is marked as being available for reuse.
- Dominant language
- Python
- Stars
- 23
- Forks
- 12
- Avg merge
- 2d 13h
- Merged PRs (30d)
- 7
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from MerginMaps/python-api-client
-
Difficulty 5/5 Over a week Newbie friendliness 30/100
MerginMaps/python-api-client#270 ·
-
enhancement
Difficulty 5/5 Over a week Newbie friendliness 25/100
MerginMaps/python-api-client#257 · 3 comments ·
-
enhancement
Difficulty 4/5 3-5 days Newbie friendliness 25/100
MerginMaps/python-api-client#254 · 1 comment ·
-
enhancement
Difficulty 5/5 Over a week Newbie friendliness 25/100
MerginMaps/python-api-client#245 ·
-
enhancement
Difficulty 4/5 3-5 days Newbie friendliness 35/100
MerginMaps/python-api-client#242 · 1 comment ·
All issues in MerginMaps/python-api-client
Similar issues
-
documentation help wanted
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
simonw/sqlite-utils#872 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100