Please find attached a makefile for building sqllite 3.2.1 using
MSVC .NET 2003 and Cygwin. This makefile closely mimics linux
makefile and builds everything (including lemon.exe, all necessary
header files, parser, opcodes, ...).
Hope that this would help someone :)
Aleksey Sanin
#
# Makefile
Hello All,
There are 3 tables interconnected with each other by foreign keys. On
deleting particular item from one table should delete all items from other
tables that was pointing to it using foreign key (Just like
ON_DELETE_CASCADE - SQLite does not support ON_DELETE_CASCADE, so I want to
write
Op maandag 13 juni 2005 17:44, schreef Ben Clewett:
> F.W.A. van Leeuwen,
>
> I am only using SQLite. I would never consider accessing the database
> file directly. Madness that way lies... :)
>
> Bert,
>
> I agree that SQLite should not be used multi-thread. I think there was
> a lot of discus
On 9 Jun 2005, at 10:15, Puneet Kishor wrote:
My question is: could I set some kind of "trace" that tells me what is
going on with SQLite?
$dbh->trace(LEVEL);
Try a level of 2 first and go up from there.
__
This email has b
>
> I am only using SQLite. I would never consider accessing the database
> file directly. Madness that way lies... :)
I was suggesting putting row level locking into the SQLite library
(not your own code).
F.W.A. van Leeuwen,
I am only using SQLite. I would never consider accessing the database
file directly. Madness that way lies... :)
Bert,
I agree that SQLite should not be used multi-thread. I think there was
a lot of discussion about multi-threads using the same SQLite handle. A
big
Paolo Vernazza wrote:
Trygg Johan wrote:
Hello,
I'm using SQLite with TCL and I have a small question:
Is it possible to get information on how many lines a select query with
the LIMIT keyword would have produced if I hadn't used the LIMIT
keyword?
One way of doing this would be to do anoth
Trygg Johan wrote:
Hello,
I'm using SQLite with TCL and I have a small question:
Is it possible to get information on how many lines a select query with
the LIMIT keyword would have produced if I hadn't used the LIMIT
keyword?
One way of doing this would be to do another query without the LIM
> >> Second, it seems logical that if I have UNIQUE then I don't have to
> >> declare NOT NULL. For example,
> >
> > Not redundant. UNIQUE does not imply NOT NULL.
>
> thanks for all the valuable clarification. However, the above seems
> contradictory. After all, if more than one row can be NULL,
Ben Clewett wrote:
I think this method may not be applicable for database abstract
locking. For instance locking many rows and assigning a timeout to
that lock.
There may well be advanced problems where low-level OS locking is not
up to the job. Like Deadly Embrace, where two processes are
I personally don't think this is a big issue for SQLite.
A database file will typically only be accessed by the programs designed
for it (i.e., they know the format).
If another (closed source) program accesses the database file - out of
your control - it will be a problem anyway.
Typically the
I think this method may not be applicable for database abstract locking.
For instance locking many rows and assigning a timeout to that lock.
There may well be advanced problems where low-level OS locking is not up
to the job. Like Deadly Embrace, where two processes are waiting for
each oth
Hello,
I'm using SQLite with TCL and I have a small question:
Is it possible to get information on how many lines a select query with
the LIMIT keyword would have produced if I hadn't used the LIMIT
keyword?
One way of doing this would be to do another query without the LIMIT
keyword, count the
Doesn't look good for file locking:
from:
http://www.hackinglinuxexposed.com/articles/20030623.html
"Last week I described three locking functions - flock, lockf, and
fcntl. These functions, while managed by the Linux kernel, are known
as advisory locking mechanisms. Any program which doesn't bot
On Jun 13, 2005, at 12:47 AM, Ben Clewett wrote:
If any users have any ideas or comments, I would be very interested.
I use triggers, but I also use a custom function I have registered
that takes care of determining if a given record is locked. That way
I don't have to use a special tabl
It's my understanding once you have an exclusive lock no other process
can modify the database and therefore can't trigger a schema change.
On 6/11/05, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Let's say I start a transaction with either BEGIN IMMEDIATE or BEGIN
> EXCLUSIVE, by successfully
You can't just lock a portion of the file?
I've seen support for it in the past but I never used it.
On 6/13/05, Ben Clewett <[EMAIL PROTECTED]> wrote:
> Dear D. Richard Hipp and SQLite users,
>
> I am having problems with concurrency in SQLite. Specifically the
> database lock method is produci
Dear D. Richard Hipp and SQLite users,
I am having problems with concurrency in SQLite. Specifically the
database lock method is producing too many lock errors.
I would like to experiment with replacing this with row locking.
Locking the specific rows when a process is making a change to tha
18 matches
Mail list logo