Re: [sqlite] forming sqlite3_statements using stored sql

2018-11-03 Thread Dingyuan Wang
It seems that SpatiaLite (an extension for GIS) plans to support that: https://www.gaia-gis.it/fossil/libspatialite/wiki?name=Stored+Procedures 2018-11-02 03:53, Thomas Kurz: >> Rather than inserting the SQL into a user-visible table, it might be > preferable to support CREATE PROCEDURE. > > +1

Re: [sqlite] forming sqlite3_statements using stored sql

2018-11-03 Thread James K. Lowden
On Fri, 2 Nov 2018 15:24:51 -0700 Jens Alfke wrote: > > On Nov 2, 2018, at 12:50 AM, Thomas Kurz > > wrote: > > > > My opinion is that the logic for database queries should be held > > together with the data. > > Why? The logic has to be in the application itself (where else would > it come