Hi,
I do the following (SQLite 308 from C++ source in windows):
BEGIN DEFERRED TRANSACTION;DELETE FROM Inbox;INSERT...;COMMIT
TRANSACTION; END TRANSACTION;
Now, nothing is done? Nothing inserted, nothing deleted from
Inbox...
Then I tried to execute the same afterwards, but then I got that I am
On Thu, Dec 02, 2004 at 11:33:33PM +0200, Ron Avriel wrote:
> Hi,
> I'm using SQLite 3.0.8 on Linux in an Apache module, in a
> multithreaded multi-process configuration. Occasionally, the database
BOTH mulit-threaded and multi-process? Why are you doing that? Is
this some sort of special
Ron Avriel wrote:
Is it OK to use the same sqlite3 session in multiple threads but
making sure that at anytime it is used by only one thread?
That depends on a number of things, including (but not limited
to) your Linux kernel version, the particular threading library
you are using, and the state
Hi,
I'm using SQLite 3.0.8 on Linux in an Apache module, in a
multithreaded multi-process configuration. Occasionally, the database
becomes deadlocked - all requests fail with a busy error. Even when I
try to access it using sqlite command line I get "Error: database is
locked" for every
I have quite a lot of data. Naturally, as an SQLite 3.08 database, my
data are significantly bigger than when they were a flat text file.
As an aside, I'm very impressed with SQLite. Basic SELECTS in this 1.4
million record database are more or less instantaneous. The performance
doing more
Taj,
> Now, I've got two questions.
> The first is that I have a column (company) in a customers table. The
> problem is that this column has a comma in it for some rows. For example:
>
> sqlite> select lastname,business FROM customers WHERE id=449;
> Toleser|St Lawrence University, Biology Dept.
D. Richard Hipp wrote:
> I have lately noticed a need for an "IS" operator in SQLite.
> IS would work just like "=" for most things. The difference
> is that "IS" would compares NULLs as equals. There would,
> of course, need to be a corresponding "IS NOT" operator.
>
> You can already us the IS
Hi All,
First off, I've been using SQLite in an open-source POS (inventory)
program and am quite happy with it. Thank you all developers and patch
submitters!
Now, I've got two questions.
The first is that I have a column (company) in a customers table. The
problem is that this column has a
George Ionescu wrote:
How can I distinguish between *your* documentations and everyone else's ?
That's the crux of the problem, isn't it I do not have
any easy solutions for you.
Great care has been taken to insure that copyright
releases are on file that cover all deliverable code
in SQLite.
9 matches
Mail list logo
