Hi, Is there a hook which allows to get notified as soon as it’s save to modify a db connection after (or as alternative to) sqlite3_update_hook was triggered?
The background to this question is that I’m trying to prepare a proposal for Geopackage. And one of the questions is if it’s possible to avoid Geopackage using a wrapper object [1] which is used in combination with user defined functions to update the rtree index after a change to the geometry table occurred. This object is currently necessary because it wraps another object (an envelope / bbox) to be used by the user defined function when the SQL update trigger is called. So my idea is to register an update hook and do the update to the rtree index directly after the step(). So this could execute an arbitrary statement, or more concrete a statement which would read an envelope column from the geometry table where the update occurred and update the rtree table accordingly. This would allow those columns to be plain and widely adopted WKB fields instead of this Geopackage binary wrapper object. Regards Ben [1] http://www.geopackage.org/spec/#gpb_spec _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
