Re: [sqlite] Database locking Error

On 08/26/2013 01:37 PM, techi eth wrote: Hi, I come across database file locking error while trying below case with Update. Case: One process is updating a Colum periodically & other process is selecting same Colum or other colum in table periodically for read. What is the best way to handle so

[sqlite] Database locking Error

Hi, I come across database file locking error while trying below case with Update. Case: One process is updating a Colum periodically & other process is selecting same Colum or other colum in table periodically for read. What is the best way to handle so that Update will not get locking error? C

Re: [sqlite] BETWEEN and explicit collation assignment

On Fri, 23 Aug 2013 17:08:59 + Roman Fleysher wrote: > This leads to enormous growth in number of types. Another solution is > to realize that the comparator (the thing that makes comparisons) is > actually an object of its own An operation is not an object. SQL has no objects. The "enormou

Re: [sqlite] Compiling spellfix for sqlite3

On Sun, Aug 25, 2013 at 6:25 AM, Mirat Bayrak wrote: > I needed wanted to build "did you mean this?" feature to my website. I'm > using sqlite3 and learned that i can use spellfix module to order tables > via levenstein. > > I downloaded source code of > sqlite3

Re: [sqlite] Compiling spellfix for sqlite3

> I downloaded source code of and compiled spellfix.c (it's inside /ext/misc/) > like this: > gcc -shared -fPIC -Wall -I/tmp/sqlite-src-3071700/ spellfix.c -o spellfix > It compiles successfuly but when i load it into sqlite: > sqlite> .load ./spellfix > I'm getting this error: > Error: .

[sqlite] Compiling spellfix for sqlite3

I needed wanted to build "did you mean this?" feature to my website. I'm using sqlite3 and learned that i can use spellfix module to order tables via levenstein. I downloaded source code of sqlite3 and compiled spellfix.c (it's inside /ext/misc/)

[sqlite] Unsuitable info regarding version of VC++ Runtime Requirement

hi the proper version of Visual C++ 2005 SP1 Redistributable Package is not specified inSystem.Data.SQLite Download Page . this caused  severall hours for trying to run a simpe c# app to run in end-user computers without success. It must be clearly specified that users need to install "Visual