[sqlite] does there some fts3 document i can read

i cant find documents about fts3 in sqlite documents 2009-11-20 ouwind ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] understanding the query optimizer

Have you read this document? http://sqlite.org/optoverview.html I think it's good start for you. The main rule of optimizer is whether the query uses an index. On Wed, Nov 18, 2009 at 12:03 AM, P Kishor wrote: > Recent travails of the

Re: [sqlite] how index stored by fts3

On Nov 20, 2009, at 11:48 AM, ouwind wrote: > if used A, what different does fts3 with sqlite Right, structure A is just a regular SQLite table. It is structure B, the full-text index, that makes fts3 different. > -- > ouwind > 2009-11-20 > >

Re: [sqlite] how index stored by fts3

if used A, what different does fts3 with sqlite -- ouwind 2009-11-20 - 发件人: Dan Kennedy 发送时间: 2009-11-20 12:32 主 题: Re: [sqlite] how index stored by fts3 收件人:

Re: [sqlite] how index stored by fts3

On Nov 20, 2009, at 10:24 AM, ouwind wrote: > > it used revert index or just index > for example: > i insert some records > 1:"i am a boy" > 2:"i am a girl" > 3:"you are a boy" > > what's the table stores like > option A: id, content > 1, i am a boy > 2, i am a girl >

[sqlite] how index stored by fts3

it used revert index or just index for example: i insert some records 1:"i am a boy" 2:"i am a girl" 3:"you are a boy" what's the table stores like option A: id, content 1, i am a boy 2, i am a girl 3, you are a boy option B: value, docid i,

Re: [sqlite] Watch Sqlite databases and delete folders based on it.

On 19 Nov 2009, at 7:45pm, Sadnem wrote: > Well, I'm configuring my server to Download some folders to it and then > to upload them to another web and i was wondering how could i delete > that folders from the hdd once they were completely uploaded (thats when > the folder get marked with a 0

Re: [sqlite] another Feature Request: char from codepoint?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tim Romano wrote: > I would hope that it could be included by default. [Note I do not speak on behalf of the SQLite team but have been an observer for many years] Your request is extremely unlikely to go into the SQLite core as the bar is *very*

Re: [sqlite] Force cache flush?

Nov 19, 2009, at 12:13 PM, Jay A. Kreibich wrote: On Thu, Nov 19, 2009 at 11:58:59AM -0900, Israel Brewster scratched on the wall: When issuing an INSERT command on a SQLite database, is that insert cached before being written to the disk? Sometimes. It may be partly cached until the

Re: [sqlite] Force cache flush?

On Thu, Nov 19, 2009 at 11:58:59AM -0900, Israel Brewster scratched on the wall: > When issuing an INSERT command on a SQLite database, is that insert > cached before being written to the disk? Sometimes. It may be partly cached until the transaction is committed. If it is a stand-alone

Re: [sqlite] is ticket 4037 not a bug?

Bogdan Ureche wrote: > Allan, > > Thank you very much for the reply. You are correct when stating that, > according to SQLite documentation this SQL syntax is not expected to work. > Therefore, it is not a bug. Perhaps it should be added to the list of SQL92 > features unsupported by SQLite.

[sqlite] Force cache flush?

When issuing an INSERT command on a SQLite database, is that insert cached before being written to the disk? If so (as I suspect to be the case), is there a way to force the cache to be flushed to disk? I have an application that issues a number of INSERT statements, but these don't appear

Re: [sqlite] is ticket 4037 not a bug?

Allan, Thank you very much for the reply. You are correct when stating that, according to SQLite documentation this SQL syntax is not expected to work. Therefore, it is not a bug. Perhaps it should be added to the list of SQL92 features unsupported by SQLite. But I am asking myself: was that

Re: [sqlite] Watch Sqlite databases and delete folders based on it.

On Thu, Nov 19, 2009 at 1:45 PM, Sadnem wrote: > P Kishor wrote: >> On Thu, Nov 19, 2009 at 12:58 PM, Sadnem wrote: >> >>> how could i make a script that would keep watching a sqlite table and >>> cheking to delete folders marked with status 0? this is an example

Re: [sqlite] Watch Sqlite databases and delete folders based on it.

P Kishor wrote: > On Thu, Nov 19, 2009 at 12:58 PM, Sadnem wrote: > >> how could i make a script that would keep watching a sqlite table and >> cheking to delete folders marked with status 0? this is an example of >> the database i'm talking about --> >>

Re: [sqlite] Suggested user-defined-function example

On Thu, Nov 19, 2009 at 12:32 PM, Tim Romano wrote: > Thank you, Jay and Pavel. > > So, there is much work going on "behind the scenes" in these two lines > because of the tightly-knit connection between TCL and SQlite: > > proc sql_addnum { a b } { return [expr { $a + $b }]

Re: [sqlite] Watch Sqlite databases and delete folders based on it.

On Thu, Nov 19, 2009 at 12:58 PM, Sadnem wrote: > how could i make a script that would keep watching a sqlite table and > cheking to delete folders marked with status 0? this is an example of > the database i'm talking about --> > http://www.wikifortio.com/834317/example.sqlite >

Re: [sqlite] bad data in a database file or bug?

On Wed, Nov 18, 2009 at 8:39 AM, Vasu Nori wrote: > > > On Wed, Nov 18, 2009 at 4:06 AM, D. Richard Hipp wrote: > >> >> On Nov 17, 2009, at 9:49 PM, D. Richard Hipp wrote: >> >> > >> > On Nov 17, 2009, at 9:45 PM, Vasu Nori wrote: >> >> >> >> sqlite> SELECT

[sqlite] Watch Sqlite databases and delete folders based on it.

how could i make a script that would keep watching a sqlite table and cheking to delete folders marked with status 0? this is an example of the database i'm talking about --> http://www.wikifortio.com/834317/example.sqlite Note that the folder name is exactly the same as the one under "Release"

Re: [sqlite] Suggested user-defined-function example

Thank you, Jay and Pavel. So, there is much work going on "behind the scenes" in these two lines because of the tightly-knit connection between TCL and SQlite: proc sql_addnum { a b } { return [expr { $a + $b }] } db function addnum sql_addnum Regards Tim Romano

Re: [sqlite] Suggested user-defined-function example

> can what Walter is doing be done in other languages, namely Adobe Flex > AIR/ActionScript? I don't know Flex's API but I bet you have documentation for that and can find there whether it has registration of user-defined functions or not. > Is "return [expr { $a + $b }]" also written in TCL?

Re: [sqlite] Suggested user-defined-function example

Perhaps the list can help me to get beyond some fundamental igorance here. What is the name for what Walter is doing in the two lines below, and can what Walter is doing be done in other languages, namely Adobe Flex AIR/ActionScript? proc sql_addnum { a b } { return [expr { $a + $b }] } db

Re: [sqlite] is ticket 4037 not a bug?

This was brought up before by me here: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2009-September/015484.html The response was: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2009-September/015486.html Which said: According to http://www.sqlite.org/lang_select.html

Re: [sqlite] Asynchronous I/O and shared cache

According to the documentation : "database connection in read-uncommitted mode does not attempt to obtain read-locks before reading from database tables as described above. This can lead to inconsistent query results if another database connection modifies a table while it is being read, but it

Re: [sqlite] another Feature Request: char from codepoint?

Thanks for the heads-up, Jean-Denis. I was going to try to deploy the almost-finished Flex/AIR app on my wife's Mac notebook this weekend to see how it goes. That it works quickly under Windows XP is all I know at this point. I am very concerned about query performance and app

Re: [sqlite] temp directory?

I believe you can specify the directory in which temporary files will be created. This is done with pragma temp_store_directory. I think you can also set this in compilation. Artur Reilin wrote: > >> >> On 19 Nov 2009, at 8:05am, Artur Reilin wrote: >> >>> My host have sqlite support vor

Re: [sqlite] another Feature Request: char from codepoint?

On 11/19/09 14:55 , "Tim Romano" wrote: > The app was written in .NET against MS-Access; my Macintosh colleagues > couldn't use it. They outnumbered the Windows users. But I didn't own a > Mac and had never programmed on a Mac. But now Adobe Flex/AIR with > SQLite is

Re: [sqlite] another Feature Request: char from codepoint?

Roger, Also, you mentioned that it could take some time for a flip() function to make its way into the OSX version assuming it had been accepted and put on the docket. I can wait a good long time for SQlite to add a flip() function. About eight years ago now I wrote my app, a full-text search

Re: [sqlite] Doubt in Trigger

> is it possible to have[insert or update] ? No. http://www.sqlite.org/lang_createtrigger.html Pavel On Thu, Nov 19, 2009 at 8:53 AM, greensparker wrote: > > hi im using Before TRIGGER for validation PURPOSE (before inserting) > > i just want to know , is there any

[sqlite] Doubt in Trigger

hi im using Before TRIGGER for validation PURPOSE (before inserting) i just want to know , is there any way to use the same trigger for UPDATE also. ex: create trigger Testing before insert or update on testTable begin end; is it possible to have[insert or update] ? Bala --

Re: [sqlite] another Feature Request: char from codepoint?

Roger wrote: ... You still have the issue that the [flip()] code would likely be excluded by default just as soundex is, so it would still require re-compiling SQLite. I would hope that it could be included by default. Those who are concerned about the overall weight of the EXE (as a

Re: [sqlite] Asynchronous I/O and shared cache

> I meant the mutex that is a member of the BtShared struct > (BtShared.mutex). Grabbed by the call to sqlite3VdbeMutexEnterArray() > at the top of sqlite3VdbeExec() and not released until that function > returns. Okay, now I see that and I don't like it at all. Of course it doesn't eliminate

Re: [sqlite] another Feature Request: char from codepoint?

Yet I don't want to do this reversal "in my application". I am not a C programmer and would have to rely upon data-providers to talk to the database. Providers, as good as they may be, are not 100% transparent conduits between the client app and the database. Right now, three of them are

Re: [sqlite] temp directory?

> Okay. That suggests something strange is happening. Perhaps instead of > making sure that the right 'user' has access to the database directory you > can use the 'group' that 'nobody' is in, and give that group privilages. I changed it to the group 'nobody', but no i have an empty result. I

Re: [sqlite] temp directory?

On 19 Nov 2009, at 10:05am, Artur Reilin wrote: > The user which runs php (or has the highest rights) is called nobody. Okay. That suggests something strange is happening. Perhaps instead of making sure that the right 'user' has access to the database directory you can use the 'group' that

Re: [sqlite] temp directory?

> > On 19 Nov 2009, at 8:05am, Artur Reilin wrote: > >> My host have sqlite support vor sqlite 2.8.17 and i can use it. But i >> have >> to give chMod 0777 to the directory where i use sqlite. Not only on the >> directory, that contains the sqlite database. let me show it: >> >> /index.php (uses

Re: [sqlite] temp directory?

On 19 Nov 2009, at 8:05am, Artur Reilin wrote: > My host have sqlite support vor sqlite 2.8.17 and i can use it. But i have > to give chMod 0777 to the directory where i use sqlite. Not only on the > directory, that contains the sqlite database. let me show it: > > /index.php (uses sqlite

[sqlite] temp directory?

Hello. My host have sqlite support vor sqlite 2.8.17 and i can use it. But i have to give chMod 0777 to the directory where i use sqlite. Not only on the directory, that contains the sqlite database. let me show it: /index.php (uses sqlite database) /data/data.sqlite (sqlite database) If i give