At 9:04 PM -0500 11/23/03, Vania Smrkovski wrote:
> Speaking to the first question, regarding security of data, aside from
>some of the obvious, like putting the DB files out of the web document
>tree, are there any ways to configure SQLite to keep the DB files in
>some non-readable format?
Hello,
I became acquainted to SQLite through its implementation in the
upcoming PHP version 5.0. As such, it is taking on much the same role
that MySQL used to in versions up to the current official release (still
in the 4.x range). As I understand it, one of the primary reasons is
MySQL'
Hello,
"D. Richard Hipp" <[EMAIL PROTECTED]>
23/11/2003 12:09 AM
To: [EMAIL PROTECTED]
cc:
Subject:[sqlite] Improving concurrency in SQLite
> Feedback is requested on the paper found at:
> http://www.sqlite.org/concurrency.html
> Your analysis and
Looking at the feedback paper, I wonder whether, possibly, things are being
made more complicated than necessary.
In most (if not all) of the situations I've seen people mention where
concurrency is a problem (and in our own similar situation), it looks as if
the problem is all in 'single appli
Have you read the article on threads in the FAQ at ?
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Please, give me some examples of the kinds of things you are
doing which could benefit from improved concurrency.
* What SQL are you running that takes more than a fraction
of a second to complete?
* Are you holding transactions open for an extended period
of time? Why?
My embedded
>> It seems to me that all the people send theiur ewmail double, and that
>> it
>> is a failure in the list software configuration.
>>
>> This email has only one TO: sqlite-users <[EMAIL PROTECTED]>
>> And no CC or BCC, thus, if this is posted twice, it is the list software
>
> Ever thought that it
Hello,
On 11/23/03 6:22 PM, D. Richard Hipp wrote:
Lots of people seem to think that better concurrency in
SQLite would be useful. But I am having trouble understanding
why.
I have SQLite or Server systems. I would like not to make that
choice - soft option I mean. As you can read I'm useing "w
> Please, give me some examples of the kinds of things you are
> doing which could benefit from improved concurrency.
One typical application for me is data recording for regulatory
compliance (FDA 21 CFR 11). Instruments are polled or issue data
frequently, say once a second. Data from several of
My thoughts are that most programmers over use and abuse threading and I
love the simplicity of your database as it is. Can't tell you how many C
projects that have almost failed because of threading and memory issues (til
I took over them and became Mr. Fix man). First thing I did was pull out
a
Hi Richard,
On Sun, Nov 23, 2003 at 12:22:25PM -0500, D. Richard Hipp wrote:
> Lots of people seem to think that better concurrency in
> SQLite would be useful. But I am having trouble understanding
> why.
First, kind thanks for SQLite - it's a nice piece of work, and fits a project
I'm working
On Sat, 2003-11-22 at 16:23, Bert Verhees wrote:
> > It seems to me that all the people send theiur ewmail double, and that it
> > is a failure in the list software configuration.
> >
> > This email has only one TO: sqlite-users <[EMAIL PROTECTED]>
> > And no CC or BCC, thus, if this is posted twic
On Sat, 2003-11-22 at 12:02, D. Richard Hipp wrote:
> It is more complicated than that. In order to maintain isolation
> (the "I" in "ACID") the second commit must fail if at any time during
> the transaction it read a value that was written by the first commit,
> or if the first commit read a val
On Sun, 23 Nov 2003 12:22:25 -0500
"D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> Lots of people seem to think that better concurrency in
> SQLite would be useful. But I am having trouble understanding
> why.
I've only just caught onto this thread but I have to also ponder and agree... SQLite
i
Hello sqlite-users
I am sorry for my last post - I change the subject. Once again:
I am new with SQLite and need your advice.
I'm using DBD-SQLite 0.28 on WindowsXP SP1 ActiveState Perl 5.8.0 and
use threads (because this is a GUI-app).
The get following error :
thread failed to start: DBD::SQL
Hello sqlite-users
I am new with SQLite and need your advice.
I'm using DBD-SQLite 0.28 on WindowsXP SP1 ActiveState Perl 5.8.0 and
use threads (because this is a GUI-app).
The get following error :
thread failed to start: DBD::SQLite::db do failed: handle 2 is owned by thread 2
240e4 not curren
Lots of people seem to think that better concurrency in
SQLite would be useful. But I am having trouble understanding
why.
Please, give me some examples of the kinds of things you are
doing which could benefit from improved concurrency.
* What SQL are you running that takes more than a fraction
Wow! Thank you for putting the idea on board.
My point of view. Right now I have to use BDE (Borland Databse
Engine). It is slow, small SQL embadden engine, which works on
Paradox / DBase files (I know - many others, but for description
that two is all you need to understand it). I don't like A
Hello everyone,
I strongly agree with Doug. I've been using SQLite in multithreaded,
single process mode, and after reading the draft, I thought that
perhaps another thread could provide a locking service. As Doug states,
this "client-server" environment would allow for finer locking
capabilit
19 matches
Mail list logo
