RE: [sqlite] File Is Encrypted Or Is Not a Database

I apologise. Just discoverd that it is a Berkely db file. I am really sorry to waste your time on this. Many thanks, though, for your assistance. Mark > -Original Message- > From: P Kishor [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 5 December 2007 6:11 p.m. > To: [EMAIL PROTECTED] >

RE: [sqlite] File Is Encrypted Or Is Not a Database

The db I am trying to open is attached. Thanks > -Original Message- > From: P Kishor [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 5 December 2007 6:11 p.m. > To: [EMAIL PROTECTED] > Cc: sqlite-users@sqlite.org > Subject: Re: [sqlite] File Is Encrypted Or Is Not a Database > > On Dec 4,

RE: [sqlite] File Is Encrypted Or Is Not a Database

Sorry ... how do I get sqlite v3.4.2? > -Original Message- > From: P Kishor [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 5 December 2007 6:11 p.m. > To: [EMAIL PROTECTED] > Cc: sqlite-users@sqlite.org > Subject: Re: [sqlite] File Is Encrypted Or Is Not a Database > > On Dec 4, 2007

RE: [sqlite] File Is Encrypted Or Is Not a Database

Aahh, ok - I have the same version. Many thanks. I will try that version of sqlite then. Fingers crossed. :) > -Original Message- > From: P Kishor [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 5 December 2007 6:11 p.m. > To: [EMAIL PROTECTED] > Cc: sqlite-users@sqlite.org > Subject: Re:

Re: [sqlite] File Is Encrypted Or Is Not a Database

On Dec 4, 2007 11:02 PM, Mark Easton <[EMAIL PROTECTED]> wrote: > Sorry, but how do I check the version of DBD::SQLite I have installed? Perl > is not my thing. When I look in the Perl code I can see DBIx::SimplePerl > commands. I ran the scipt below but it did not show any installed modules.

RE: [sqlite] File Is Encrypted Or Is Not a Database

I am sure on the versions of sqlite I have been using. When yoy run them it always shows the version of sqlite you are running. This is very very frustrating. I have a sqlite db which the Perl app is opening fine using DBIx::SimplePerl, yet U cannnot open the db from command line. It seems more

RE: [sqlite] File Is Encrypted Or Is Not a Database

Sorry, but how do I check the version of DBD::SQLite I have installed? Perl is not my thing. When I look in the Perl code I can see DBIx::SimplePerl commands. I ran the scipt below but it did not show any installed modules. "#!/usr/bin/perl use CPAN; printf("%-20s %10s %10s\n", "Module",

Re: [sqlite] sqlite locking mechanism with threads

99.9% certain this is not a sqlite issue. But a script language issue. It depends on how the script language implements threads. Try writing this in C and using posix threads. You'll also need to have multiple cpu's to really take advantage of threading as well. yahalome

Re: [sqlite] File Is Encrypted Or Is Not a Database

On 12/4/07, Mark Easton <[EMAIL PROTECTED]> wrote: > I have also tried v 3.5.3 now and still cannot open the database. I guess I > need the right version of sqlite3 so that I can dump to sql and then I can > rebuild in a newer version. But how do I find our what version of sqlite I > need? > > > >

RE: [sqlite] File Is Encrypted Or Is Not a Database

I have also tried v 3.5.3 now and still cannot open the database. I guess I need the right version of sqlite3 so that I can dump to sql and then I can rebuild in a newer version. But how do I find our what version of sqlite I need? > -Original Message- > From: Mark Easton [mailto:[EMAIL

[sqlite] sqlite locking mechanism with threads

I work with sqlite 3.5.3. I experimented with threads and I get a strange behavior. it looks like one thread takes over sqlite and does not leave it until it is finished even though I tell it to wait (using random after). This is the script I use: package require sqlite3 package require

[sqlite] File Is Encrypted Or Is Not a Database

I have a sqlite db file. I have tried to open it with sqlite v 3.4.1, 2.8.17 and 3.3.5 and each of these versions give me the same error "File Is Encrypted Or Is Not a Database". How can I determine what version of sqlite will open this db? The perl application can open the database using the perl

Re: [sqlite] SQLite is in Android

On 12/4/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Richard Klein <[EMAIL PROTECTED]> wrote: > > Surely I'm not the first person to notice that > > SQLite is part of Google's open-source Android > > platform for mobile phones. > > > > I've had Android listed at

Re: [sqlite] search time in FTS3 tables sometimes very long

2007/12/4 Scott Hess <[EMAIL PROTECTED]>: > This seems a little excessive, though. I do see that there's an > O(N^2) path in the prefix-searching (loadSegmentLeavesInt()'s call to > docListUnion()). I can reasonably make that O(logN), which might help > a great deal, if you're hitting it. Not

Re: [sqlite] SQLite is in Android

Richard Klein <[EMAIL PROTECTED]> wrote: > Surely I'm not the first person to notice that > SQLite is part of Google's open-source Android > platform for mobile phones. > I've had Android listed at http://www.sqlite.org/famous.html since the day it was announced. -- D. Richard Hipp <[EMAIL

[sqlite] SQLite is in Android

Surely I'm not the first person to notice that SQLite is part of Google's open-source Android platform for mobile phones. This is a *huge* win for SQLite ... - Richard Klein - To unsubscribe, send email to [EMAIL

Re: [sqlite] search time in FTS3 tables sometimes very long

2007/12/4 Ingo Godau-Gellert <[EMAIL PROTECTED]>: > What is really strange is that FTS3 search phrases like > SELECT referenzcode FROM volltext where volltext match ('installation > manual') are performed really fast within some milliseconds, independent > to the search phrase. > But in general I

Re: [sqlite] fts table insert performance

Sorry for the delayed response. Was waiting for time to dig into this a little. Nov 18, 2007 2:05 AM Wang Yun <[EMAIL PROTECTED]>: > I insert rfc txt files into a full text search table, 4119 txt files are > 188MB totally. After insert, database file is 443MB. > Logic is below, it's not the real

Re: [sqlite] ORDER BY Performance on 30,000 records

Thanks, now it takes only few ms : ) - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Sunday, December 02, 2007 7:52 PM Subject: Re: [sqlite] ORDER BY Performance on 30,000 records On Dec 2, 2007, at 12:01 PM, Ofir Neuman wrote:

Re: [sqlite] UNION and ORDER BY errors starting from sqlite 3.4.2

--- Dan <[EMAIL PROTECTED]> wrote: > The "b" in the ORDER BY does not match "x1.b" because it is > not a simple identifier (according to matchOrderbyToColumn()). > It does not match either "" or " as ". > > After failing to find a match for "b" in the leftmost SELECT, > SQLite searches the next

Re: [sqlite] Allocating Memory For A Pool Of Database Connections

David, You have some pointer issues going on! Maybe something like this struct db_cache_type { sqlite3 *db; /* database file pointer */ char *key; /* key identifies the database that was opened */ int mode; /* database open mode */ }; struct db_cache_type **db_cache_list; /* list

Re: [sqlite] Allocating Memory For A Pool Of Database Connections

David Gelt <[EMAIL PROTECTED]> wrote: > > The application is ... a synchronuous, single threaded application. Yes! Way to go! > > In order to keep all these database connections open, I defined > an array (simple list) but when I am trying to allocate memory > for sqlite3 type I get an

[sqlite] Allocating Memory For A Pool Of Database Connections

Hi there, I am having a minor issue when trying to malloc() memory for a list of database connections. I need to keep open a large number of database files and run queries against them. The application is running on Linux and is a synchronuous, single threaded application. In order to keep

Re: [sqlite] Cache resizing problem.

On Dec 4, 2007, at 11:47 PM, Dennis Cote wrote: Dan wrote: This is failing because the internal representation of the database schema used by the first connection has not yet been updated to include the changes made in step 4 by the second connection. After the sqlite3_prepare() in step 6

Re: [sqlite] Getting values by column name

Jon Drnek wrote: Is there a way that I can find out the number of a given column name in the query? Instead of ts.key = sqlite3_column_int(preparedGet,0); I'd like to do something like: ts.key = sqlite3_column_int(preparedGet,get_column_id(preparedGet,"id")); Is there

Re: [sqlite] UNION and ORDER BY errors starting from sqlite 3.4.2

On Dec 4, 2007, at 10:35 PM, Joe Wilson wrote: --- Dan <[EMAIL PROTECTED]> wrote: i.e., if we have: CREATE TABLE x1(a, b, c); CREATE TABLE x2(a, b, c); then the following pairs of statements are equivalent: ... SELECT x1.b, a FROM x1 UNION SELECT a, b FROM x2 ORDER BY b;

Re: [sqlite] Cache resizing problem.

Dan wrote: This is failing because the internal representation of the database schema used by the first connection has not yet been updated to include the changes made in step 4 by the second connection. After the sqlite3_prepare() in step 6 fails with the "no such table" error, SQLite

Re: [sqlite] sqlite:Deletion in Joins method

Sreedhar.a wrote: CREATE TABLE ALBUM (AlbumId INTEGER NOT NULL PRIMARY KEY,Album Text); CREATE TABLE ARTIST (ArtistId INTEGER NOT NULL PRIMARY KEY,Artist Text); CREATE TABLE BGM (BgmId INTEGER NOT NULL PRIMARY KEY,Bgm Text); CREATE TABLE MUSIC (Id INTEGER NOT NULL PRIMARY KEY,Album_Id INTEGER

RE: [sqlite] SQLite does not support multi-row inserts?

MS SQL 2008 will support multi-row insert statements too. http://richardsbraindump.blogspot.com/2007/07/what-new-in-sql-2008-katmai.ht ml Sam --- We're Hiring! Seeking a passionate developer to join our team building Flex based products. Position is in

Re: [sqlite] SQLite does not support multi-row inserts?

--- Sander Marechal <[EMAIL PROTECTED]> wrote: > Joe Wilson wrote: > > --- Sander Marechal <[EMAIL PROTECTED]> wrote: > >> I ran into a problem when using SQLite from PHP. It appears that SQLite3 > >> does not support multi-row inserts in the form: > >> > >> INSERT INTO (col1, col2) VALUES (1,

Re: [sqlite] Single row insert speeds

"Mark Riehl" <[EMAIL PROTECTED]> wrote: >> > For testing, I've modified the the insert to look like this: > char *insertStatement = "PRAGMA synchronous=OFF;BEGIN;INSERT INTO > sampleTable VALUES (\"hostname\", \"6\", \"5.1.0\", \"0\", \"1708\", > \"1196303669.065335988998\", >

[sqlite] Writing to Flash Memory

I'm developing an application to run on an ARM-based PDA-like device. It's running Linux and I've got SQLite 3.4.1 installed. I'm trying to optimize my insert statements (in a different discussion thread) I've gotten some good suggestions to use the PRAGMA statement to disable the syncronization.

Re: [sqlite] UNION and ORDER BY errors starting from sqlite 3.4.2

--- Dan <[EMAIL PROTECTED]> wrote: > i.e., if we have: > >CREATE TABLE x1(a, b, c); >CREATE TABLE x2(a, b, c); > > then the following pairs of statements are equivalent: ... > >SELECT x1.b, a FROM x1 UNION SELECT a, b FROM x2 ORDER BY b; >SELECT x1.b, a FROM x1 UNION SELECT a, b

Re: [sqlite] Single row insert speeds

All - After reviewing some of my calculations, I realized I made a mistake and that the inserts didn't improve as much as I thought. I used the PRAGMA synchronouse = OFF and I'm averaging about 0.21 ms for an insert on a Core 2 Shuttle running Fedora 3. Here is the table I've defined: CREATE

[sqlite] Re: Getting values by column name

Jon Drnek wrote: I have a prepared statement that looks like char *getSql = "select * from transducer where id = ?"; rc = sqlite3_prepare_v2(transducerDb,getSql,-1,,NULL); Is there a way that I can find out the number of a given column name in the query? You can enumerate all columns and

[sqlite] Getting values by column name

Hello, I have a prepared statement that looks like char *getSql = "select * from transducer where id = ?"; rc = sqlite3_prepare_v2(transducerDb,getSql,-1,,NULL); Is there a way that I can find out the number of a given column name in the query? Instead of ts.key =

[sqlite] How to get older source

I'm trying to access the 3.4.2 (and previous) sources from the website by changing the version numbers in the source download link to various values, which has worked for me in the past. If I use the following links, things work and I can get both the long form and amalgamated sources:

Re: [sqlite] Cache resizing problem.

On Dec 4, 2007, at 3:49 PM, Sabyasachi Ruj wrote: Hi, I am getting a problem if I am modifying cache size. This can be reproduced by the following steps:- We need two connections to reprodce this. Say the database name is: "test.db" *"test.db" SHOULD NOT BE EXISTING ALREADY, WE HAVE TO

[sqlite] Cache resizing problem.

Hi, I am getting a problem if I am modifying cache size. This can be reproduced by the following steps:- We need two connections to reprodce this. Say the database name is: "test.db" *"test.db" SHOULD NOT BE EXISTING ALREADY, WE HAVE TO CREATE EACH TIME WE WANT TO GET THE PROBLEM.* 1. Create a

Re: [sqlite] UNION and ORDER BY errors starting from sqlite 3.4.2

On Dec 4, 2007, at 10:27 AM, Dr Gerard Hammond wrote: I have reported it as a bug - ticket is http://www.sqlite.org/ cvstrac/tktview?tn=2822 It appears as though the /src/select.c (Line1499) changed from: if( iCol<0 && mustComplete ){ to: }else if( mustComplete ){ in version 1.336 of