[sqlite] 3.7.7.1 database corruption

Dear all,   we are using SQLite in our projects. We are using the 3.7.7.1 version compiled on Windows platform from the amalgamation file. One of our servers crashed badly (power outage) and after the server restarted, we saw that the database was corrupt (all queries we tried return

Re: [sqlite] determine SQLITE_MAX_LENGTH or sql_limit/sqlite3_limit

Hi All I need to create table with more than 2000 columns, How to reset SQLITE_MAX_COLUMN value which is 2000 . Plz help me on this issue. Thanks Vinay Vannus wrote: > > That should do the trick, thanks for pointing it out. > > On 10 February 2011 06:18, Dan Kennedy

Re: [sqlite] Wanted: Windows SQLite shell 3.6.x (not the current version!)

On 12.11.2011 16:00 CE(S)T, Yves Goergen wrote: > Could somebody please send me an older version 3.6.x of the SQLite > Windows shell client? Thank you. -- Yves Goergen "LonelyPixel" Visit my web laboratory at http://beta.unclassified.de

[sqlite] FTS: Phrase queries

When I have a basic FTS query that needs to be restricted to a column, I can write it in two ways: 1.) WHERE column MATCH 'apple' 2.) WHERE table MATCH 'column:apple' But when I have a phrase query, I can only write it in one way: 1.) WHERE column MATCH '"apple juice"' The problem is that when