[GRASS-dev] [GRASS GIS] #3697: sqlite db: automatically enable vacuum

[GRASS GIS]

#3697: sqlite db: automatically enable vacuum
--------------------------+---------------------------
  Reporter:  mlennert     |      Owner:  grass-dev@…
      Type:  enhancement  |     Status:  new
  Priority:  normal       |  Milestone:  7.8.0
 Component:  Database     |    Version:  unspecified
Resolution:               |   Keywords:  sqlite vacuum
       CPU:  Unspecified  |   Platform:  Unspecified
--------------------------+---------------------------

Comment (by mmetz):

 Replying to [comment:4 mlennert]:
 > Replying to [comment:1 mmetz]:
 > > I would prefer to VACUUM the sqlite db when the GRASS session is
 terminating, i.e. in lib/init/grass.py. This would not slow down standard
 db operations and leaves the db in a clean state.

 Added benefit: already existing databases are also cleaned, while with
 PRAGMA auto_vacuum=1 only newly created databases would be cleaned.

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/3697#comment:6>
GRASS GIS <https://grass.osgeo.org>