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
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 database)
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
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
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
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
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 ability
Roger wrote:
quote... 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. /quote
I would hope that it could be included by default. Those who are
concerned about the overall weight of the EXE
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
--
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
balamurugan.c...@gmail.com wrote:
hi im using Before TRIGGER for validation PURPOSE (before inserting)
i just want to know , is there any way to
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
On 11/19/09 14:55 , Tim Romano tim.rom...@yahoo.com 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 available,
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 sqlite 2.8.17
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
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
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
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
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?
Yes.
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
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
On Wed, Nov 18, 2009 at 8:39 AM, Vasu Nori vn...@google.com wrote:
On Wed, Nov 18, 2009 at 4:06 AM, D. Richard Hipp d...@hwaci.com 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 _id, typeof(_id) FROM feeds;
On Thu, Nov 19, 2009 at 12:58 PM, Sadnem sad...@gmx.com 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
Note
On Thu, Nov 19, 2009 at 12:32 PM, Tim Romano tim.rom...@yahoo.com 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 }] }
db
P Kishor wrote:
On Thu, Nov 19, 2009 at 12:58 PM, Sadnem sad...@gmx.com 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 --
On Thu, Nov 19, 2009 at 1:45 PM, Sadnem sad...@gmx.com wrote:
P Kishor wrote:
On Thu, Nov 19, 2009 at 12:58 PM, Sadnem sad...@gmx.com 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
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
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
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.
IMHO it's
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
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
-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*
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
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, 1,2
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
3, you are a
if used A, what different does fts3 with sqlite
--
ouwind
2009-11-20
-
发件人: Dan Kennedy danielk1...@gmail.com
发送时间: 2009-11-20 12:32
主 题: 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
Have you read this document?
http://sqlite.org/optoverview.html
http://sqlite.org/optoverview.htmlI 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 punk.k...@gmail.com wrote:
Recent travails of the user
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
38 matches
Mail list logo