Re: [sqlite] json1 as loadable extension

> On 28/09/2016, at 4:22 AM, Mark Woodward wrote: > > I've built the JSON1 module as a loadable extension, and this loads fine if I > also compile sqlite myself. This is on windows as x86 (32 bit). > > I cannot get any pre built version of sqlite3.dll to load the

Re: [sqlite] json1 as loadable extension

Of course, it could also be because the default build (depending on which one you are using) have the json extension already loaded (compiled in). see pragma compile_options; and if one of the returned options is ENABLE_JSON, then the extension is already loaded in the core ... >

Re: [sqlite] json1 as loadable extension

Are you using the correct entry-point name? Although the source file is called json1.c the entry-point name is sqlite3_json_init, not sqlite3_json1_init ... > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Mark Woodward

[sqlite] json1 as loadable extension

Hi all, I've built the JSON1 module as a loadable extension, and this loads fine if I also compile sqlite myself. This is on windows as x86 (32 bit). I cannot get any pre built version of sqlite3.dll to load the extension, I get "'error during initialization: '" with no subsequent message.

Re: [sqlite] A problem with 'pragma table_info(...)'

On Wed, Sep 21, 2016 at 9:57 AM, Stepan Zakharov wrote: > We are using VFS however, may be that can be ill-implemented somehow so it > makes PRAGMA not to work.. It can. And I think you're the third person on the mailing list to fall into that trap. From an earlier mail

Re: [sqlite] SQLite3 database slowdown at 1GB

To avoid unnecessary rebalance and split operation of b-tree, sort the data before insert it to table. Create temp table bf_temp(id integer, offset); -- careful, no primary key Begin; Insert into bf_temp(id, offset) values(?,?); … create table if not exists bf_fav_nis(id integer primary