Re: [sqlite] regarding internal design of SQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Aditya Bhave (adbhave) wrote: > I am interested in learning about the internals of SQLite. The SQLite documentation page at http://sqlite.org/docs.html contains almost all the information you could possibly want. > How it parses > SQL strings, what g

[sqlite] regarding internal design of SQLite

Hi, I am interested in learning about the internals of SQLite. How it parses SQL strings, what goes on the parsing stack, how it executes SQL statements etc. The source code although commented is too large to read. Is there a document I can refer to that explains how this whole process is carried

Re: [sqlite] sqlite3 3.5.9 floating point division seems odd

On Mon, Jul 7, 2008 at 9:06 PM, Shane Harrelson <[EMAIL PROTECTED]> wrote: > Make sure SQLite isn't being compiled with -ffast_math on the the Debian > side. That might cause problems. -ffast-math would not cause sqlite to bug out like described. it lets the compiler reorder floating point expre

Re: [sqlite] Bad UPDATE Problems in Mobile6 device

also that query will update all rows in the commentlist table.  is that what you want to do?   Woody --- On Mon, 7/7/08, Stephen Oberholtzer <[EMAIL PROTECTED]> wrote: From: Stephen Oberholtzer <[EMAIL PROTECTED]> Subject: Re: [sqlite] Bad UPDATE Problems in Mobile6 device To: "General Discussio

Re: [sqlite] sqlite3 3.5.9 floating point division seems odd

Make sure SQLite isn't being compiled with -ffast_math on the the Debian side. That might cause problems. On 7/3/08, Tom Epperly <[EMAIL PROTECTED]> wrote: > > When I tried reproducing this behavior on a Red Hat box, the 3.5.9 > version gave the expected results, so I guess it is a Debian unstabl

[sqlite] How can i use sqlite's fts3 to support full text search of gb2312(chinese)?

Anyone can give me a hint, thanks so much. Best regards! 2008-07-08 wenhm ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bad UPDATE Problems in Mobile6 device

On Mon, Jul 7, 2008 at 7:26 AM, Bob Dennis <[EMAIL PROTECTED]> wrote: > Hi > I am getting odd results with a simple update query in a Mobile 6 device. > It only works sometimes , but never reports an error. > The same code works fine in PocketPC and Mobile5 devices. > > UPDATE 'CommentList' SET x

Re: [sqlite] No such column ?

Thx, actually that didn't work either, but I see now what my problem is, I was using activerecord which in turn add this FROM (nm_visitors bbb) , when I use normal query it is than FROM nm_visitors AS bbb and than it works... > - Original Message - > From: "D. Richard Hipp" <[EMAIL PROTE

Re: [sqlite] No such column ?

On Jul 7, 2008, at 4:37 PM, Milan Nikollic wrote: > > SELECT > COUNT(visitor_id) AS num_visits, > human_year AS year, > human_month AS month, > human_day AS day, > (SELECT COUNT(DISTINCT ip_address) FROM nm_visitors AS aaa > WHERE aaa.human_year = bbb.human_year >

[sqlite] No such column ?

Hi, I have trouble getting this query to qork in sqlite, in mysql it works but I can't get it to work in sqlite, I tried different things, aliasing table name, without alias, I googled first ofcourse but didn't found anything... Can somebody help, here goes sql: SELECT COUNT(visitor_id) AS num_

Re: [sqlite] Fuzzy Matching

Hi, Folks. While I do not have any expertise to compare levenshtein with other approaches, my current approach for fuzzy matching is, taking a word w, compute all possible near words with distance n. This is known to generate a big number of near misses, but it is quicker to then search for these

Re: [sqlite] FTS query syntax for "starts with"?

Jason Boehle wrote: > Is the an FTS syntax that allows me to find a field (or fields) that > start with one of the terms in the search query? > > Or should I just be doing a LIKE query against the FTS table? Do you want any word starts with? fts_table MATCH 'st*' will match all words like 'st

[sqlite] FTS query syntax for "starts with"?

Is the an FTS syntax that allows me to find a field (or fields) that start with one of the terms in the search query? Or should I just be doing a LIKE query against the FTS table? Jason Boehle [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-use

Re: [sqlite] Bits selection

В сообщении от Monday 07 July 2008 16:38:56 Raphaël KINDT написал(а): > I use Blob because I don't know how many bits I must use (maybe 1024 bits > or more). It's the user choice not mine. Moreover, I think Blob takes less > space than Bool field (which is TINYINT or somethings like that). And ho

Re: [sqlite] Bits selection

I use Blob because I don't know how many bits I must use (maybe 1024 bits or more). It's the user choice not mine. Moreover, I think Blob takes less space than Bool field (which is TINYINT or somethings like that). Thanks for your reply -Message d'origine- De : [EMAIL PROTECTED] [mailt

Re: [sqlite] Bits selection

"Raphaël KINDT" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I use an events table which looks like this: > > CREATE TABLE events( >time REAL NOT NULL, >detections BLOB); > > I want to select all events which have the BIT3 of detections field > enable between

[sqlite] Bad UPDATE Problems in Mobile6 device

Hi I am getting odd results with a simple update query in a Mobile 6 device. It only works sometimes , but never reports an error. The same code works fine in PocketPC and Mobile5 devices. UPDATE 'CommentList' SET xFlag = 3 I wondered if anyone else has seen this, and why would a query not work

Re: [sqlite] Bits selection

В сообщении от Monday 07 July 2008 13:42:11 Raphaël KINDT написал(а): > Hello, > > I use an events table which looks like this: > > CREATE TABLE events( >time REAL NOT NULL, >detections BLOB); > > I want to select all events which have the BIT3 of detections field enable > bet

[sqlite] Bits selection

Hello, I use an events table which looks like this: CREATE TABLE events( time REAL NOT NULL, detections BLOB); I want to select all events which have the BIT3 of detections field enable between two time. How can I do that with the SELECT request? Thanks in advance... -

Re: [sqlite] SQLite Data types

guyot jerome wrote: Hi, I would like to realize the dialect between SQLite and Hibernate but I need to know the correspondence between the SQLite types and the general types (e.g.:How a boolean type is represented under SQLite). What is that somebody can give myself this piece of i

[sqlite] SQLite Data types

Hi, I would like to realize the dialect between SQLite and Hibernate but I need to know the correspondence between the SQLite types and the general types (e.g.:How a boolean type is represented under SQLite). What is that somebody can give myself this piece of information because I d

Re: [sqlite] Importing tab-separated data containing quotes

Hi Donald, You're right. We're using a slightly modified build of sqlite3 at the company I work for, and it turns out that the problem is specific to our version. The "official" build of sqlite3 doesn't have this issue. Of course I should have tested the official binary first before jumping to