Re: [sqlite] Properly bulk-inserting into FTS5 index with external content table

On 31 Oct 2017, at 12:54pm, Eugene Mirotin wrote: > This field is actually boolean, but also nullable. From other languages > (like Python and JS) I actually assumed the NULL check is faster than value > comparison. In SQLite, NULL, 0 and 1 are all special cases and take

Re: [sqlite] Segfault when query again in-memory db

On 10/31/17, Wang, Peter (Xu) wrote: > Hi > I am trying to provide a asychnonous queue based on sqlite3 in Python > Current, I already passted the file based tests with my queue > When switching file to in-memory db, I keep meeting a "segfault" issue when > running the same

[sqlite] Segfault when query again in-memory db

Hi I am trying to provide a asychnonous queue based on sqlite3 in Python Current, I already passted the file based tests with my queue When switching file to in-memory db, I keep meeting a "segfault" issue when running the same tests test suite Can anyone help me out of this situation? I

Re: [sqlite] Properly bulk-inserting into FTS5 index with external content table

On 31 Oct 2017, at 10:21am, Eugene Mirotin wrote: > Hmm, I think I've found the solution: > > INSERT INTO search (rowid, question, answer, altAnswers, comments, authors, > sources) SELECT id, question, answer, altAnswers, comments, authors, > sources FROM questions WHERE

Re: [sqlite] Properly bulk-inserting into FTS5 index with external content table

Thanks for the tip. This field is actually boolean, but also nullable. From other languages (like Python and JS) I actually assumed the NULL check is faster than value comparison. Will improve later (for now it's definitely not a bottleneck). On Tue, Oct 31, 2017 at 3:50 PM Simon Slavin

Re: [sqlite] LSM database file growth?

Thanks so much, this explains things neatly. I was aware of the tree compaction and the use of delete tombstones, but wasn't sure how it all played out in terms of space reclamation. In other words, if the total size of my keyspace is fixed, then the database won't grow without bounds, even if

[sqlite] ASP.NET MVC 5 Connection

I am trying to attach SQLite with my MVC 5 app. I cannot able to do so. Also, I have not found any solution online ye. Can any of them help me in this regard. Thanks in advance. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] LSM database file growth?

On 10/31/2017 10:50 PM, Charles Leifer wrote: Is the LSM database append-only, as in the file size will always grow/never shrink (even if there are deletions/overwrites)? An LSM database is basically a series of tree structures on disk. When you write to an LSM database you add the new key to

Re: [sqlite] Segfault when query again in-memory db

>I tested the in-memory with multi-thread (but inserts/deletes are in >a lock) What does "with multi-thread" mean (to you)? --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users

[sqlite] LSM database file growth?

Is the LSM database append-only, as in the file size will always grow/never shrink (even if there are deletions/overwrites)? Thanks! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] ASP.NET MVC 5 Connection

Yes I am using MVC 5 in my project. I will go to Core in future but at this time, I am using MVC 5. Is there any example for me you found elsewhere...??? On Wed, Nov 1, 2017 at 12:48 AM, Joseph L. Casale wrote: > -Original Message- > From: sqlite-users

Re: [sqlite] ASP.NET MVC 5 Connection

-Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Rahmat Ali Sent: Tuesday, October 31, 2017 10:43 AM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] ASP.NET MVC 5 Connection > I am trying to attach SQLite with my MVC 5

Re: [sqlite] ASP.NET MVC 5 Connection

You may want to have a look at http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki Rahmat Ali schrieb am 31.10.2017 um 17:43: I am trying to attach SQLite with my MVC 5 app. I cannot able to do so. Also, I have not found any solution online ye. Can any of them help me in this

Re: [sqlite] ASP.NET MVC 5 Connection

I have searched a lot. But not able to find a solution. I have viewed that page several times. But nothing here is helping me out. On Tue, Oct 31, 2017 at 11:59 PM, GB wrote: > You may want to have a look at http://system.data.sqlite.org/ > index.html/doc/trunk/www/index.wiki >

Re: [sqlite] ASP.NET MVC 5 Connection

-Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Rahmat Ali Sent: Tuesday, October 31, 2017 2:17 PM To: SQLite mailing list Subject: Re: [sqlite] ASP.NET MVC 5 Connection > Yes I am using MVC 5

[sqlite] bug: explain Rewind Le

create table t(n number, v varchar2(10)); insert into t values (1, 'one') explain select * from t where 0 < n; addr opcode p1p2p3p4 p5 comment - - -- - 0 Init 0 110

[sqlite] Properly bulk-inserting into FTS5 index with external content table

Hi, I have a table questions with lots of columns. Out of them 6 columns represent text content and the rest are technical (FKs, update timestamp, etc) I need to build the FTS5 search index for this table to only index the content columns (that 6). The DB is only built once on the server and

Re: [sqlite] Properly bulk-inserting into FTS5 index with external content table

Hmm, I think I've found the solution: INSERT INTO search (rowid, question, answer, altAnswers, comments, authors, sources) SELECT id, question, answer, altAnswers, comments, authors, sources FROM questions WHERE obsolete IS NULL; On Tue, Oct 31, 2017 at 1:02 PM Eugene Mirotin