photo

Kelvin Floyd

shared this idea
3 years ago

Statistics

0
Comments
1
Views

Share

3
votes

Project Database extras

Can I suggest that the db for all layers has a default timestamp field and possibly even a 'trigger' for a modified field timestamp. I have tried to add a default timestamp field to the database (through sqliteadmin) but means the layer is dropped from locus gis. It is very useful and necessary for many gis projects to know when something was added or edited.

It would also be great to be able use as layers spatial views created in the database (created in another sql gui) such as buffers around a point etc.

And possibly even storing layer styles as qgis now does https://pvanb.wordpress.com/2014/05/15/saving-layer-styles-to-your-spatialite-database/.

Maybe enum choices also could be stored in the database to make them easier to add or edit.

Thanks, keep up the great work

Under Consideration
3 I like this idea 0

Leave Comment

photo