Saving data from Ext.data.Store to Postgres database not via WFS-T
Technique of spatial data editing via web browser described in this tutorial is extreamly easy: http://workshops.opengeo.org/geoext/wfs/index.html#geoext-wfs
Ext, GeoExt, OpenLayers Geoserver and WFS-T do all dirty job, and you do not have to code anything server side. All UPDATE, INSERT & DELETE queries to database are done by via WFS-T.
Is there something like this for non-spatial data? What will handle store-to-database communication as good as WFS-T? Abovementioned solution is also good for non-spatial data but I would like to avoid using geoserver all the time:)
There are a number of tools for loading data into PostGIS.
- ogr2ogr utility in GDAL is a commandline utility
- QGIS is a desktop GIS client that can do CRUD on PostGIS
- FME is commercial software that can also do data editing in PostGIS
Lots to choose from