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]
> Cc
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, 2
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 11:
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: [
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.
Use
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
tha
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", "Insta
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 <[EMAI
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?
>
>
> >
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 P
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 Threa
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
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 http://www.sqlite.org/famous.h
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
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 PROTE
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 PROTEC
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 a
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
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:
Hi All,
I have some per
--- 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 l
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 o
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 erro
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 al
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 f
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 a
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;
SELEC
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 realise
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
CO
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 t
For our stock management I created a SQLITE 3.5.3 table, containing
around 1,5M entries.
The FTS3 table is created with statement:
CREATE VIRTUAL TABLE volltext using FTS3(referenzcode, code, deut, engl,
ital, sppm, rep, info)
"referenzcode" and "code" are containing part numbers with 10 or 1
--- 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, 2),
"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\",
> \"hostIfc=eth0:1;hos
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.
--- 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
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 TABL
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,&preparedGet,NULL);
Is there a way that I can find out the number of a given column name
in the query?
You can enumerate all co
Hello,
I have a prepared statement that looks like
char *getSql = "select * from transducer where id = ?";
rc = sqlite3_prepare_v2(transducerDb,getSql,-1,&preparedGet,NULL);
Is there a way that I can find out the number of a given column name in the
query?
Instead of
ts.ke
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:
http://sql
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 CREATE
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 c
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
41 matches
Mail list logo