Xavier Noria <[EMAIL PROTECTED]> wrote:
> I asked this in a couple of Rails places without luck. I guess this
> is actually related to Rails, just ask it here in case someone knows
> about it.
>
> The file config/database.yml rails generates has as SQLite database
> for testing ":memory:",
I asked this in a couple of Rails places without luck. I guess this
is actually related to Rails, just ask it here in case someone knows
about it.
The file config/database.yml rails generates has as SQLite database
for testing ":memory:", but the simplest of the tests in the Agile
book
Joe Wilson <[EMAIL PROTECTED]> wrote:
> Does Sqlite support the ability to have several concurrent non-blocking
> database read operations
> in a single thread?
>
> What about the more traditional many-threads-each-with-a-blocking-read model?
>
Two or more connections can all read at the same
Does Sqlite support the ability to have several concurrent non-blocking
database read operations
in a single thread?
What about the more traditional many-threads-each-with-a-blocking-read model?
--- [EMAIL PROTECTED] wrote:
> Beginning with version 3.3.0, you will be able to configure SQLite
>
"Dan Petitt" <[EMAIL PROTECTED]> wrote:
> Are there any plans for sqlite to support row or table level locking, or
> possibly even Multiversion Concurrency Control, MVCC, its definition being:
>
"Axel Mammes \(gmail\)" <[EMAIL PROTECTED]> wrote:
> Does your flat file support ACID transactions?
Does your flat file support ACID transactions? That´s the killer feature fo
my app. I want to store financial transactions and I don´t trust normal flat
files.
-Original Message-
From: Dan Petitt [mailto:[EMAIL PROTECTED]
Sent: Viernes, 23 de Diciembre de 2005 08:00 p.m.
To:
Are there any plans for sqlite to support row or table level locking, or
possibly even Multiversion Concurrency Control, MVCC, its definition being:
~~
While querying a database each transaction sees a snapshot of data (a
database version) as it was some time ago, regardless of the
Just for the records.
I just compiled sqlite 3.2.8 with a new compiler (Intel 9.0) and gives these
warnings (among many others):
attach.c
.\Sqlite\v3\attach.c(142): remark #1599: declaration hides variable "i"
(declared at line 34)
int i = db->nDb - 1;
date.c
.\Sqlite\v3\date.c(506):
-Original Message-
From: Paul Bohme [mailto:[EMAIL PROTECTED]
Sent: Friday, December 23, 2005 2:10 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] ring buffer table
Cory Nelson wrote:
>afaik, sqlite doesn't store row counts so count(*) causes a full table
scan.
>
>On 12/23/05,
Cory Nelson wrote:
afaik, sqlite doesn't store row counts so count(*) causes a full table scan.
On 12/23/05, Axel Mammes (gmail) <[EMAIL PROTECTED]> wrote:
Wouldn´t a SELECT COUNT(*) just read the table header and get the amount of
records from there? That should be faster and simpler than
afaik, sqlite doesn't store row counts so count(*) causes a full table scan.
On 12/23/05, Axel Mammes (gmail) <[EMAIL PROTECTED]> wrote:
> Wouldn´t a SELECT COUNT(*) just read the table header and get the amount of
> records from there? That should be faster and simpler than maintaning a
>
Wouldn´t a SELECT COUNT(*) just read the table header and get the amount of
records from there? That should be faster and simpler than maintaning a
separate table for the counters.
-Original Message-
From: Paul Bohme [mailto:[EMAIL PROTECTED]
Sent: Viernes, 23 de Diciembre de 2005 02:52
Julien LEFORT wrote:
Hi,
I would like to implement a log table with a finite dimension, for exemple a
table with 500 records, and when the last record is set in the table I would
like to come back at the first tuplet and write over the previous value
recorded. I think it's the way SQLite
Paul,
This work could be enormously useful to me. The configuration like
looks what I need. If you could supply the patch that would be good.
I am looking forward to seeing how SQLite works on my pocket Linux box.
Ben
Paul Bohme wrote:
Ben Clewett wrote:
Dear SQLite
I wish to
14 matches
Mail list logo