> I do not understand why lemon waits for one more token when it has
> enough information to reduce
...
>
> >>> I don't think you can. Why do you want to? Why not just go
> >>> ahead and send it the next token?
> >>>
> >> Most people find a way around this problem using white-spac
On Wed, 2007-10-24 at 21:38 -0700, Richard Klein wrote:
> As I was thinking about the locking mechanism in SQLite 3,
> it occurred to me that the following race condition could
> occur.
>
> Imagine a joint bank account with a balance of $10,000.
> The wife makes a withdrawal of $1,000 at ATM 'A' (
As I was thinking about the locking mechanism in SQLite 3,
it occurred to me that the following race condition could
occur.
Imagine a joint bank account with a balance of $10,000.
The wife makes a withdrawal of $1,000 at ATM 'A' (serviced
by process A in the bank's mainframe), while at the same
t
John Stanton wrote:
Are you certain that you need to run a full suite of tests on Sqlite
to verify that your compatibility layer is correct? How about
developing a test suite for your porting layer If it works
identically on each platform you can have confidence that your
overlaid software w
Gaspard Bucher wrote:
> PS: There is another reason, aside from aesthetics and simpler grammar
> to filter white spaces inside the tokenizer: you avoid all the parser
> conflicts you could get with "empty | or space" rules.
>
> 2007/10/24, Gaspard Bucher <[EMAIL PROTECTED]>:
>
>>> Gaspard Bucher
These only strip lines with Space characters. I need also to filter
out also tabs, carriage returns and all series characters that
constitute a white space.
-
To unsubscribe, send email to [EMAIL PROTECTED]
---
Ken, Igor,
I read the article you referenced. Much appreciated.
http://sqlite.org/lockingv3.html
I didn't want to complicate my original questions with the intricate
details of the application requirements which involve not allowing any
database access while certain other operations are executin
PS: There is another reason, aside from aesthetics and simpler grammar
to filter white spaces inside the tokenizer: you avoid all the parser
conflicts you could get with "empty | or space" rules.
2007/10/24, Gaspard Bucher <[EMAIL PROTECTED]>:
> > Gaspard Bucher <[EMAIL PROTECTED]> wrote:
> > > I
If you are using seperate processes then a mutex will not help since it is
local to a process. A semaphore could be used however.
You can use a begin immediate around all statements that perform DML
(ins/upd/sel)
Then loop on the busy at the begin immediate command. This is a fairly simple
thi
> Gaspard Bucher <[EMAIL PROTECTED]> wrote:
> > I do not understand why lemon waits for one more token when it has
> > enough information to reduce.
> >
> > I want to recognize :
> > foo = Bar()
> > when the token CLOSE_PAR is received, not when an extra token is parsed..
> >
> > How can I avoid le
Lee Crain <[EMAIL PROTECTED]> wrote:
Igor,
I did say "controlled" concurrency.
I'll rephrase question 3.
3) Would use of a MUTEX to avoid the dreaded "SQLite busy" condition
be a
good solution?
Wouldn't it prevent multiple concurrent readers? That's usually
something you want.
Or is some
Igor,
I did say "controlled" concurrency.
I'll rephrase question 3.
3) Would use of a MUTEX to avoid the dreaded "SQLite busy" condition be a
good solution? Or is some other method of avoiding a busy condition
recommended?
Lee Crain
__
-Original Message-
From: Igor T
Lee,
1. Qualified Yes, depending on your definition of concurrency.
2. Connections may remain open.
3. Mutexes are not required for protection.
Read the following:
http://sqlite.org/lockingv3.html
Lee Crain <[EMAIL PROTECTED]> wrote: I loosely follow this forum so I am almost
certain this s
Lee Crain <[EMAIL PROTECTED]> wrote:
1. Can multiple processes "concurrently" access the same SQLite
database?
Yes.
2. If so, can multiple processes maintain an open connection to the
database? Or must the connection be opened and closed, before and
after,
respectively, each database access?
I loosely follow this forum so I am almost certain this subject has come
up in the forum in the last few months. However, until Monday of this
week, this subject had not come up in my company's application
requirements so I made few mental notes on it. Now, a requirement for
having 2 or more proces
Hello,
With php, I want to create 2 tables, userid is a
primary key in TUser and a foreign key in TRight. I
want to create a default user during database
creation.
$sql1 = 'CREATE TABLE TUser(userid UNSIGNED INTEGER
PRIMARY KEY AUTOINCREMENT NOT NULL, username TEXT,
pseudo TEXT, password TEXT,
Gaspard Bucher <[EMAIL PROTECTED]> wrote:
> I do not understand why lemon waits for one more token when it has
> enough information to reduce.
>
> I want to recognize :
> foo = Bar()
> when the token CLOSE_PAR is received, not when an extra token is parsed.
>
> How can I avoid lemon waiting for t
I do not understand why lemon waits for one more token when it has
enough information to reduce.
I want to recognize :
foo = Bar()
when the token CLOSE_PAR is received, not when an extra token is parsed.
How can I avoid lemon waiting for the extra token before reducing ?
Thanks for your help !
I see now, thanks for the clarification. Sorry for the ramblings.
And there is a .mode csv so that should take care of data loading.
Regards,
Ken
Joe Wilson <[EMAIL PROTECTED]> wrote: --- Ken wrote:
>A new command ".imp" command could be made to use my proposed array based
> processing.
This can be done with a custom aggregate function. I posted an example a
week or so ago here in the list (example in C#).
SELECT key, DisplayList(data)
GROUP BY Key
where DisplayList() is a custom function that concatenates it's values.
I don't think this can be done in straight SQL.
HTH,
Sa
All:
I have the following table
key data
1 'Version 1'
1 'Version 2'
1 'Version 3'
2 'Version 4'
2 'Version 5'
(obviously key is not primary)
I want to write a query that returns
key data
1 'Version 1 Version 2 Version 3'
2
Thomas Damme <[EMAIL PROTECTED]> wrote:
> Hello,
>
> this question was propably asked a hundred times before but I was not
> able to find a good answer for it on the web.
>
> Is it possible to change the directory where SQLite places the
> journal-file? We have a damn-slow USB-Stick where the dat
Hello,
this question was propably asked a hundred times before but I was not
able to find a good answer for it on the web.
Is it possible to change the directory where SQLite places the
journal-file? We have a damn-slow USB-Stick where the database resides.
It does not fit into the fast internal
Hi All,
I need small help regarding opening the .db files.Actually my application
was developed in .Net by using SQLite2.1 version as back end.while running
the application we are facing the problem with opening the .db
files.Following exception is occurring.
SQLiteNET.SQLiteException:Co
Am 24.10.2007 um 13:14 schrieb Markus Hoenicka:
Quoting nishit sharma <[EMAIL PROTECTED]>:
Hi All,
Sending y peoples same query with some explanation.
i have a database name myds.db which is having one column as index
(integer
default 0) which has no values
in complete database.
when i used
thnx for the help
regards
Nishit
On 10/24/07, Markus Hoenicka <[EMAIL PROTECTED]> wrote:
>
> Quoting nishit sharma <[EMAIL PROTECTED]>:
>
> > Hi All,
> > Sending y peoples same query with some explanation.
> > i have a database name myds.db which is having one column as index
> (integer
> > defau
Quoting nishit sharma <[EMAIL PROTECTED]>:
Hi All,
Sending y peoples same query with some explanation.
i have a database name myds.db which is having one column as index (integer
default 0) which has no values
in complete database.
when i used to access somthing with reference to index in comman
Hi All,
Sending y peoples same query with some explanation.
i have a database name myds.db which is having one column as index (integer
default 0) which has no values
in complete database.
when i used to access somthing with reference to index in command than i get
the error
SQL error: near "index"
Barabbas Jiang Gmail <[EMAIL PROTECTED]> writes:
>
> Hi all,
>
> I found another strange problem of SQLite on Vista with IE7.
> I have an input method with SQLite. When I opened it in IE7 for
> typing Chinese, the SQLite returned nothing. However, *if IE7 is
> "run as administrator," SQLite work
On Tue, 2007-10-23 at 19:54 -0500, Andrew Wiley wrote:
> I've been using SQLite on several minor projects now (it makes File IO so
> easy), and the one suggestion I would make would be to make the
> documentation (api reference) downloadable.
> It would be very handy for myself and probably many ot
Hi All,
i have a database in which there is a column named index (integer value).
when i m doing select index and all other stuff i m continuosly getting an
error that is:
SQL error: near "index": syntax error
and this error doesn't come if i remove index entry from my command
can anybody tell me
On Tue, 2007-10-23 at 19:33 -0700, d_maniger06 wrote:
> ok..i have this sample code:
>
> [code]
> void printIfInsert()
> {
> printf( "Insertion was done in t1\n" );
> }
>
> void createTrigger( sqlite** db, sqlite_vm** pvm )
> {
> char* errMsg;
> const char** psql = NULL;
> const c
You should consider the extension for, at least, three situations:
- Anti virus can check files differently depending on the extension
- Backup programs can also react on this
- Windows takes it into account when indexing files
Compass Ing. y Sistemas Dr. Ramon Ribo
http://ww
Well... From the lack of responses I gather that you actually don't give
a damn what file extension I use :)
I think this is fare enough and maybe a SQLite database shouldn't be
tied to a single file extension.
Anyway.. Thanks for listening and thanks for the best database ever!
Daniel Önnerby
On Wed, 24 Oct 2007 05:21:03 +0200 (CEST), you wrote:
>Hello,
>
>I have few questions on SQLite3, i'm using it through
>pdo with php5.
>
>- is unsigned int available?
http://www.sqlite.org/datatype3.html
The range of available positive signed integers is large, and
you can avoid negative values w
Hello Olaf Beckman Lapré,
>Aren't there any source documents? I assume the documentation wasn't written
>in HTML originally.
All documentation is available via CVS and can be build using the provided TCL
scripts.
The DISQLite3 HTML Help (http://www.yunqa.de/delphi/) contains the full SQLite3
36 matches
Mail list logo
