In QGIS I can import data tables (CSV in particular) which have no inherent geometry (and no lat/lon columns) into QGIS. There doesn't seem to be any obvious way to manipulate that data (edit/save).
(Obviously this data has a reference column which links to data which does have geometry).
It's documented that (at QGIS 2.6) it's not possible to edit/save CSV files:
- Is there no editmode for CSV files?
- How do I delete multiple data points from a .csv file through QGIS?
- Why can't I edit attribute table imported through 'text as layer'
I am aware that I could edit data in another application, repeatedly returning to this, saving as CSV and importing into QGIS, but this seems very clumsy and inefficient. I'd like to remain within QGIS.
I'm guessing that there are many workarounds for this which are simple for those experienced with using databases, but on other GIS software it's a trivial task to work with a geometry-free table.
How do I set-up a spatialite database for this purpose?