Re: [sqlite] Exclusive Transactions and Attached Databases

Am 18.09.2007 um 19:26 schrieb [EMAIL PROTECTED]: Michael Plagge <[EMAIL PROTECTED]> wrote: Just for interest: Am I the only one being faced with the quoted situation and did I not understand the documentation, or is there some misbehaviour in sqlite's handling of multiply attached database

Re: [sqlite] Exclusive Transactions and Attached Databases

I accidently ran into this situation and spent a couple of hours for finding the cause. In our environment we have a list of modules -> databases assignments. As it is possible that some modules share the database, they point to the same file. So we are attaching each module's database and

Re: [sqlite] Compiling amalgamation with G++

-ldl -lpthread (at least in my last builds) On 9/18/07, Olaf Beckman Lapré <[EMAIL PROTECTED]> wrote: > > I'm trying to compile the amalgamation on Xubuntu Linux with G++ but I'm > getting linking errors: several about pthread and others about dlopen() etc. > > Is there anything I need to add

[sqlite] Compiling amalgamation with G++

I'm trying to compile the amalgamation on Xubuntu Linux with G++ but I'm getting linking errors: several about pthread and others about dlopen() etc. Is there anything I need to add (libraries, includes, defines) to get it to compile? Kind regards, Olaf

Re: [sqlite] Opinions about per-row tokenizers for fts?

[Input == great!] Regarding space usage, my current prototype stores an additional column on %_content, defined like 'tokenizer TEXT DEFAULT NULL'. If NULL, the default tokenizer is used and the per-row cost is negligible. Otherwise, it is the string specifying the tokenizer, which I

[sqlite] Re: Opinions about per-row tokenizers for fts?

I've realized that this proposal does not easily allow for tables without per-row tokenizers. I think that modifying the create syntax to be like: CREATE VIRTUAL TABLE t USING fts3(TOKENIZER DEFAULT , ...); could handle that. If you use "TOKENIZER ", then you get the current behaviour, with a

[sqlite] SQLite+ns2

Hello! Currently i am working on my diploma thesis and i would really appreciate your help. I want to simulate a wireless network using ns2. I want each node to have a database. So i would like to ask you if i can combine ns2 with a database such as sqlite. Have you tried anything similar? Is

Re: [sqlite] Exclusive Transactions and Attached Databases

Michael Plagge <[EMAIL PROTECTED]> wrote: > Just for interest: Am I the only one being faced with the quoted > situation and did I not understand the documentation, or is there > some misbehaviour in sqlite's handling of multiply attached database > files? > You are probably the only

Re: [sqlite] Exclusive Transactions and Attached Databases

Just for interest: Am I the only one being faced with the quoted situation and did I not understand the documentation, or is there some misbehaviour in sqlite's handling of multiply attached database files? Thanks Michael Am 15.09.2007 um 19:43 schrieb Michael Plagge: Dear group,

Re: [sqlite] large bulk insert speed observations when page_size and cache_size are varied

100% CPU is optimal. The less than 100% numbers indicate that the performance is limited by waits on disk access. When all the data is in memory disk access would cease and no longer be a bottleneck. RaghavendraK 70574 wrote: Why is the CPU shot up by 100% (relative)when the full db is in

Re: [sqlite] Undefined reference Compile Error

Gary G Allen wrote: Hello Everyone in SQLite land. I am totally new to the sites and sounds here. I have a issue. I hope you can help me with. I downloaded source code from: http://www.sqlite.org/download.html sqlite-3_4_2.zip (179.14 KB) Ran the makefile and everything worked fine. I

Re: [sqlite] large bulk insert speed observations when page_size and cache_size are varied

Why is the CPU shot up by 100% (relative)when the full db is in mem? This can be a concern.I understand there is not much i/o but 100% is too high. regards ragha ** This email and its attachments contain

[sqlite] large bulk insert speed observations when page_size and cache_size are varied

The bash script below attempts to quantify the relationship between SQLite (3.5.0 alpha) page_size and cache_size towards the speed of populating a large table with many indexes. First some rough metrics on the final populated database: The database is approximately 208M in size, consisting of

[sqlite] Undefined reference Compile Error

Hello Everyone in SQLite land. I am totally new to the sites and sounds here. I have a issue. I hope you can help me with. I downloaded source code from: http://www.sqlite.org/download.html sqlite-3_4_2.zip (179.14 KB) Ran the makefile and everything worked fine. I have been trying to run

RE: [sqlite] Filesystem Layer problems

If you only need Windows compatibility you can use the System.Data.SQLite port. It's made for ADO.NET but it is also binary compatible with SQLite and can be used from C code. It includes Windows-specific encryption and is free. http://sqlite.phxsoftware.com/ With the ADO.NET stuff it's

Re: [sqlite] 'Misuse of aggregate' reported in subquery which works as a query

"Simon Davies" <[EMAIL PROTECTED]> wrote: > Hi All, > > Is this expected behaviour (pre-compiled windows binary)? > http://www.sqlite.org/cvstrac/tktview?tn=2652 -- D. Richard Hipp <[EMAIL PROTECTED]> - To

Re: [sqlite] Filesystem Layer problems

We have considered this option carefully in the last few years (since we love SQLite and would love to support it), but $2000 was too expensive for us at the time... :-( [EMAIL PROTECTED] escreveu: You could purchase a license for the SQLite Encryption Extension

Re: [sqlite] Sqlite insertion performance

John Stanton <[EMAIL PROTECTED]> wrote: > I haven't looked at how Sqlite manages its cache, so my suggestion may > be irrelevant but we have had success in such a cacheing situation by > crafting the cache with pages organized in most recently used order. > The least recently used pages is the

Re: [sqlite] Filesystem Layer problems

=?ISO-8859-1?Q?Lu=EDs_Santos?= <[EMAIL PROTECTED]> wrote: > Hi, people > > We have managed to add a simple obfuscation layer to SQLite on windows > platform; this has been working since version 3.0.8, but We've found a > problem on the last versions. > > We've introduces a simple stream

Re: [sqlite] Sqlite insertion performance

[EMAIL PROTECTED] wrote: "Paul Harris" <[EMAIL PROTECTED]> wrote: A thought along the same lines, can sqlite create a unique index that is hash-based? this would provide the UNIQUE support, but it wouldn't provide a sorted index. That should resolve the massive-insert-too-slow problem, and

[sqlite] Filesystem Layer problems

Hi, people We have managed to add a simple obfuscation layer to SQLite on windows platform; this has been working since version 3.0.8, but We've found a problem on the last versions. We've introduces a simple stream criptography layer on two functions on /os_win.c/ (winRead and winWrite).

Re: [sqlite] Sqlite insertion performance

"Paul Harris" <[EMAIL PROTECTED]> wrote: > > > A thought along the same lines, can sqlite create a unique index that > is hash-based? this would provide the UNIQUE support, but it wouldn't > provide a sorted index. > > That should resolve the massive-insert-too-slow problem, and > afterwards

[sqlite] 'Misuse of aggregate' reported in subquery which works as a query

Hi All, Is this expected behaviour (pre-compiled windows binary)? SQLite version 3.4.2 Enter ".help" for instructions create table monthNames( shortName TEXT, longName TEXT ); insert into monthNames values( 'Jan', 'January' ); insert into monthNames values( 'Feb', 'February' ); insert into

Re: [sqlite] Primary Keys of a table

On Tue, 18 Sep 2007 15:18:27 +0530, you wrote: >All, > > > >Is there any API in sqlite3 which will provide the Primary keys of the table >and also the Non-primary keys of the table? Here is something to start with: SQLite v3.4.2 CREATE TABLE persons( person_id INTEGER PRIMARY KEY NOT

[sqlite] Primary Keys of a table

All, Is there any API in sqlite3 which will provide the Primary keys of the table and also the Non-primary keys of the table? Like suppose I have a table create table t1 (c1 char, c2 char, c3 char, primary key(c1,c3)); And in my application, I need to know the columns which are the