editor with sqlite data source with flask

Ben21

I am trying to make use of the editor feature to update my table data store in an sqlite DB using the flask web interface.
I only see way using ajax but I like to point to sql db directly without having to convert it.

can someone direct me with an exemple how this should be configured. I like to buy the editor license but I am not able to make it work

kthorngren

You will need to use Ajax to send the data to Flask. You can use the ajax.data to send the Editor data as JSON. See the last example in the docs.

You can use something like this example to send the different edit types (Edit, Create, Delete) to different Flask routes. You will then need to parse the JSON request to build the SQL queries, perform any desired validation and provide the expected response as documented here. Not a trivial task but not terribly difficult depending on the complexities of your Sqlite DB. This might work well with SQLAlchemy.

Kevin

Ben21

Many thanks Kevin for your help