[sqlite] Note, using SQLAR compared to TGZ archive

On 3/29/16, Kevin wrote: > Richard, > > Just a note of thanks for the SQLAR tool. I'm glad you find it useful. Really is it just a proof-of-concept. If you are a C programmer and would like to try to enhance it, write to me and I'll get you check-in privileges on the respository. So where did

[sqlite] Broken database after experiments with fts.

Hello, On 2016-03-29 20:36, Cezary H. Noweta wrote: > I'm sorry, if I've missed something, but what about Parse::isMultiWrite? > AFAIK, Parse::mayAbort is used solely in conjunction with > Parse::isMultiWrite. How can lone Parse::mayAbort influence on > OP_Transaction (or on any other behavior

[sqlite] Broken database after experiments with fts.

Hello, On 2016-03-29 19:25, Dan Kennedy wrote: > I think that's the right thing to do as well. See here: > >http://sqlite.org/src/info/d0a3853b37230c12 > > The fix should appear as part of the 3.13 release (not 3.12 - the > version that was tagged earlier this morning). I'm sorry, if I've

[sqlite] Broken database after experiments with fts.

Hello, On 2016-03-26 15:37, John Found wrote: > Why cannot drop the table test? > > sqlite> begin transaction; > sqlite> create virtual table test using fts5; > Error: vtable constructor failed: test > sqlite> commit; It is not required. Non-commited-and-non-rolledback, dangling transaction

[sqlite] Help needed for COPY Command.

Thank you all for your responses. I'll try your inputs and let me see which one suits my requirement. Thanks & Best Regards, - Mahi On Mon, Mar 28, 2016 at 6:27 PM, Don V Nielsen wrote: > You need to handle the load yourself. Since you are talking bulk load, a > scripting language is probably