Re: [sqlite] Get notified as soon as it's save to modify a db after sqlite3_update_hook() was triggered

Hi Peter, Wrapping the bbox was solely for the purpose of additional (and optional) performance. At the moment, this column would be optional and used instead of the geopackage geometry in some situations (e.g. improve rtree indexing by avoiding to create the bbox for every geometry). The

Re: [sqlite] Get notified as soon as it's save to modify a db after sqlite3_update_hook() was triggered

If you're creating GeoPackages with the F.3 RTREE Spatial Indexes extension, you do not "wrap" a bounding box. You need to define 5 functions from SQL/MM -- ST_MinX, ST_MaxX, ST_MinY, ST_MaxY and ST_IsEmpty -- that take a geometry blob as input and return (for the first four) a floating point

Re: [sqlite] Get notified as soon as it's save to modify a db after sqlite3_update_hook() was triggered

On 4/3/17, Stadin, Benjamin wrote: > 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? There is no such callback built into SQLite. But you

[sqlite] Get notified as soon as it's save to modify a db after sqlite3_update_hook() was triggered

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