[sqlite] Ranking in fts.

I've lined up some time to work on fts, again, which means fts3. One thing I'd like to include would be to order doclists by some baked-in ranking. The idea is to sort to most important items to the front of the list, and then you can do queries which limit the number of hits and can thus be

[sqlite] Re: Why is there no sqlite3_exec16() method?

Rob Richardson <[EMAIL PROTECTED]> wrote: Our shop writes in Visual C++ 6, and our applications are all developed with _UNICODE defined. But if we want to use sqlite3_exec(), we are forced to convert the SQL statements to single-byte characters. Why is there no sqlite3_exec16() method? Or is

[sqlite] Why is there no sqlite3_exec16() method?

Greetings! Our shop writes in Visual C++ 6, and our applications are all developed with _UNICODE defined. But if we want to use sqlite3_exec(), we are forced to convert the SQL statements to single-byte characters. Why is there no sqlite3_exec16() method? Or is there a version of the SQLite

Re: [sqlite] SQL query help...

- Original Message - From: "Trey Mack" <[EMAIL PROTECTED]> To: Sent: Friday, June 08, 2007 1:08 PM Subject: Re: [sqlite] SQL query help... Here's what I tried, which didn't work... select name, substr(name,1,length(name)-3) as zone,

Re: [sqlite] SQL query help...

Here's what I tried, which didn't work... select name, substr(name,1,length(name)-3) as zone, substr(name,length(name)-2,2) as location, max(thick) - min(thick) as diff from plypoint where diff > 0.0005 group by zone,location That causes a "misuse of aggregate" error. select name,

[sqlite] SQL query help...

Hi All, I need a little help in constructing a SQLite query.. Here's what I have so far that works... select name, substr(name,1,length(name)-3) as zone, substr(name,length(name)-2,2) as location, max(thick) - min(thick) as diff from plypoint group by zone,location The above properly

Re: [sqlite] Why do you use SQLite? Comments for an article needed

A.J.Millan wrote: John Elrick wrote: Tim Anderson wrote: We are working on a project for the Census Bureau and needed an embeddable database that was zero configuration for the user and fast. We evaluated SQLite against numerous competitors... IMHO, a bit exaggerated the "numerous

Re: [sqlite] Why do you use SQLite? Comments for an article needed

Tim Anderson wrote: > I'm writing an article about SQLite and I'd love to get some comments > from users about why you use it. Performance? Features? Reliability? > Cost? Is the open source aspect important? Anything else? For that > matter, anything you really don't like about SQLite? > > You can

Re: [sqlite] Why do you use SQLite? Comments for an article needed

Am Donnerstag, 7. Juni 2007 19:49 schrieb Tim Anderson: > I'm writing an article about SQLite and I'd love to get some comments > > >from users about why you use it. Performance? Features? Reliability? > > Cost? Is the open source aspect important? Anything else? For that > matter, anything you

[sqlite] Re: Syntax help with UPDATE in SQLite Database Browser

Ellis Robin (Bundaberg) <[EMAIL PROTECTED]> wrote: Update Parameter set ParameterValue = (select NewParams.parametervalue from Scenario, Link, Catchment, FunctionalUnit, FunctionalUnitDefinition, StandardFU, Parameter, NewParams where Scenario.ScenarioID = 1004 and Scenario.NetworkID =

Re: [sqlite] Truncate Issue

On Fri, 2007-06-08 at 09:50 +0530, Jimmy Mathew Ambalathuruthel wrote: > Hi all, > > I am working in a porting project of SQLite from windows. > > I Could not port the Truncate () function (For Eg: WinTruncate () in > windows code in the file os_win.c ) as the same logic cannot be applied >

Re: [sqlite] Why do you use SQLite? Comments for an article needed

John Elrick wrote: > Tim Anderson wrote: > > We are working on a project for the Census Bureau and needed an > embeddable database that was zero configuration for the user and fast. > We evaluated SQLite against numerous competitors... IMHO, a bit exaggerated the "numerous competitors" part of