Re: [sqlite] Best JDBC driver for SQLite?

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

Re: [sqlite] Speeding up index insertion

It was as simple as PRAGMA cache_size = 10; I want one *million* database disk pages. Thx, Doug On Tue, Apr 26, 2011 at 2:44 PM, Douglas Eck wrote: > Hi all, > I have a table like this; > CREATE TABLE entity ( >        id BIGINT NOT NULL, >        a_id VARCHAR(64), >    

Re: [sqlite] Speeding up index insertion

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

[sqlite] Speeding up index insertion

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

Re: [sqlite] Segmentation fault when using triggers inside Freeswitch

Richard Hipp escribió: > On Tue, Apr 26, 2011 at 3:18 PM, Neven Boric 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

Re: [sqlite] Segmentation fault when using triggers inside Freeswitch

On Tue, Apr 26, 2011 at 3:18 PM, Neven Boric 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

[sqlite] backup api database is locked?

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

[sqlite] Segmentation fault when using triggers inside Freeswitch

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).

Re: [sqlite] query to find mixed values

> 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)

Re: [sqlite] Test Foreign Key Column

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

[sqlite] query to find mixed values

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

[sqlite] Test Foreign Key Column

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

[sqlite] sqlite3 cannot create table, says read only

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

Re: [sqlite] No journal vs WAL journal

On 04/26/2011 08:13 AM, Nikolaus Rath wrote: > Nikolaus Rath 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