On 04/26/2011 08:13 AM, Nikolaus Rath wrote:
Nikolaus Rathnikol...@rath.org writes:
[ WAL Performance ]
Really no one an idea of why this is happening?
I tried to investigate this further myself and created a small example
program (attached). It fills a table with 500,000 entries without
Hi,
I need to create a table in the sqlite3 database used by CA Enterprise Log
Manager as a requirement to get Arcsight to work. When I connect to the
database using the JDBC or ODBC clients it says read only. When I go
directly to the Linux server where is install CA Enterprise Log Manager I
Hi and sorry for my poor English.
I want to know if is it possible to test if a column is a foreign key. I
mean, where the constraint is stored ?
The only system table i know for Sqlite is the sqlite_master but can't
find anything in her for the foreign key.
For example, if i have a table
I have two tables:
CREATE TABLE INV
( REQ int,
INV char,
AMT float );
CREATE TABLE REP
( REQ int,
ACCT char
AMT float );
I need to flag any combinations where for a given REQ value, one table has a
list of numbers of mixed signs, and the other table has one and only one value.
So
I had to use the pragmas:
# foreign_key_list
# foreign_keys
But also the sqlite_master table includes the command used to create each
table. Foreign fields will have a REFERENCES key word.
Regards,
¬Jonathan
-Original Message-
From: sqlite-users-boun...@sqlite.org
REQ3 is a problem because you have mixed signs in INV and only one record in
REP
How would I craft a query to return REQ3?
Could be something like this:
select INV.REQ,
count(case when INV.AMT 0 then 1 else null end) positive,
count(case when INV.AMT 0 then 1 else null end) negative,
Hi
I'm using Freeswitch, which has an old version of SQLite embedded in its
source code. I'm getting a segmentation fault whenever I do something
that uses triggers. The segmentation fault occurs inside SQLite code
(strdup gets called with a null pointer inside sqlite3ExprListDup).
I've been having a somewhat unexpected condition where I get database
is locked when using the SQLite backup api (.backup from the sqlite3 command).
This is with version 3.7.2 and using WAL. My impression was that the
backup API would yield and occasionally finish. I seem to
On Tue, Apr 26, 2011 at 3:18 PM, Neven Boric nbo...@yx.cl wrote:
Hi
I'm using Freeswitch, which has an old version of SQLite embedded in its
source code. I'm getting a segmentation fault whenever I do something that
uses triggers. The segmentation fault occurs inside SQLite code (strdup gets
Richard Hipp escribió:
On Tue, Apr 26, 2011 at 3:18 PM, Neven Boricnbo...@yx.cl wrote:
Hi
I'm using Freeswitch, which has an old version of SQLite embedded in its
source code. I'm getting a segmentation fault whenever I do something that
uses triggers. The segmentation fault occurs
Hi all,
I have a table like this;
CREATE TABLE entity (
id BIGINT NOT NULL,
a_id VARCHAR(64),
b_id VARCHAR(64),
path VARCHAR,
more fields,
created_at TIMESTAMP,
PRIMARY KEY (id)
);
3.1M records.
When I create an index for a_id it is
On Apr 26, 2011, at 11:44 PM, Douglas Eck wrote:
3.1M records.
When I create an index for a_id it is very slow to create (many hours).
Hmmm... sounds like many hours too many :)
For example, as a comparison point, on a underpowered laptop, indexing a
randomly sorted text column over ~26
It was as simple as
PRAGMA cache_size = 10;
begin Dr. Evil voice; pinkie to lower lip
I want one *million* database disk pages.
/end
Thx,
Doug
On Tue, Apr 26, 2011 at 2:44 PM, Douglas Eck d...@google.com wrote:
Hi all,
I have a table like this;
CREATE TABLE entity (
id
Hi,
I sent this message to the list
As I'm going to be using Java, I would like to know what is the best
JDBC driver for SQLite - or if there isn't a best one, what are the
pros and cons of the different ones.
two days ago - and haven't received a single reply. Is this not the
correct
14 matches
Mail list logo