I'm developping an web-application using opengeo server. The data is stored into a PostGIS database, and some tables contains non-spatial data (that is related to the geographical data).
Is there a way to access the data in the non-spatial tables (to populate Ext.data.Store) and modify it?
I've tried many things from now, but none of them have succeed.
- To read the data, I have for example set up a WFS layer, and then a WFS store in the web application. It gives me a read access, but no write access. Even if I get the record from the store, modify it, mark it as dirty and commit the changes, I see that the message that is sent to the server does not contain any modification (no updated records) - maybe because the store is not designed to work without layer.
- The REST api does not provide access to the data.
An option could be to use web frameworks, but in that case, which ones are the best to use with Opengeo? I prefer to avoid this solution because it would require to manage an other server application (and it will complicate the management of the creditentials, since authentication is required to access the data).