I am trying to create a temporary spatial data from a PostGIS database that a user can do the editing on. Currently, I have a service that returns GeoJSON from the PostGIS database. But I don't think it's possible to edit GeoJSON using QGIS. What is the reason?
Secondly, what would be the best format to do the editing then to convert it back to GeoJSON. I have shapefile and Spatialite in mind. The downside of shapefile is that I can only use one table per one shapefile. If for example I have a line and a polygon table, I would need two shapefiles for each. I am not sure what advantage Spatialite offers over shapefile? Is it possible to edit Spatialite data on QGIS? How comparable is Spatialite to Esri Personal Geodatabase?