SQLite/LiveCode Issues

[Bob Sneidar]

Brilliant! On my way to put my 2 cents in. 

Bob


On May 10, 2012, at 3:30 PM, Peter Haworth wrote:

> If you don't use some of the more advanced features of SQLite, this email
> probably won't be of interest.
> 
> The SQLite library included with Livecode up to 5.0 is 3.7.4.  It dates
> from about 1 1/2 years ago and there have been 7 major releases of the
> library since then including several enhancements and performance
> improvements.
> 
> The library includes support for two of the three components of the SQLite
> Full Text Search extension, fts3 and fts4, but not ftsaux.  The rtree
> extension is included in the library but is not available because it has to
> be enabled at compile time.
> 
> SQLite include a load_extension function that provides the capability of
> loading extensions from an external library.  That extension is not exposed
> to Livecode.
> 
> The sqlite3_progress_handler function is not exposed to LC.  This function
> gives the ability to specify a callback handler which gets invoked at
> regular intervals during long running sqlite3 tasks, thus making it
> possible to update a record count, progress bar, etc, or even allow the
> user to abort the process.
> 
> I have entered QCC Report # 10207 requesting that these issues be addressed
> by including a more recent version of the SQLite library with Livecode and
> also making the functions mentioned above available to us.
> 
> Thanks,
> 
> 
> Pete
> lcSQL Software <http://www.lcsql.com>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode