[sqlite] Built-in ranking functions for fts?

2012-07-20 Thread AJ ONeal 
In the documentation it gives examples for `countintegers` and `rank`, but
those functions aren't built in.

http://www.sqlite.org/fts3.html#appendix_a

So how can I do anything "useful" with fts as-is? Are there built-in
functions that provide some sort of generic result ranking?

While I respect that many users will want to implement a custom solution,
it seems that the solutions mentioned solve the 90/10 problem.

If not, to whom should I propose that the 'good enough' functions mentioned
in the documentation should be part of the standard FTS build?

AJ ONeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] unrecognized parameter: content=""

2012-07-20 Thread AJ ONeal 
I'm on OS X

brew install sqlite3
sqlite3 --version
3.7.13 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc

Interestingly when I do it like this it works:
sqlite3 ':memory:' 'CREATE VIRTUAL TABLE t1 USING fts4(content="", a, b,
c);'

But when I do it like this
sqlite3 -init meta-fts.table.sql meta-fts-new.sqlite3

where `meta-fts.table.sql` is https://gist.github.com/3154874
wget
https://raw.github.com/gist/3154874/8f582883d62c82aeafed5eabf639e603ec1ac379/meta-fts.table.sql

Then it throws the error.

AJ ONeal

On Fri, Jul 20, 2012 at 11:34 PM, Kees Nuyt  wrote:

> On Fri, 20 Jul 2012 23:12:43 -0600, AJ ONeal  wrote:
>
> >I've tested with sqlite3 and the nodejs sqlite3 module and I get this
> error
> >when using the example from the documentation (as well as variants more
> >suitable to my application) for full-text search.
> >
> >Docs:
> >http://www.sqlite.org/fts3.html#section_6_2_1
> >
> >Test:
> >CREATE VIRTUAL TABLE t1 USING fts4(content="", a, b, c);
> >CREATE VIRTUAL TABLE fts USING fts4(content="data", name TEXT, path TEXT);
> >
> >Result:
> >unrecognized parameter: content=""
> >
> >Was this never implemented? Is it deprecated? Does it require special
> build
> >options? Any thoughts?
>
> Cannot reproduce that error message in the test above with:
> SQLite version 3.7.12.1 2012-05-22 02:45:53 or
> SQLite version 3.7.14 2012-06-21 17:21:52.
>
> Is your test sample complete?
>
>
> --
> Regards,
>
> Kees Nuyt
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] unrecognized parameter: content=""

2012-07-20 Thread Kees Nuyt 
On Fri, 20 Jul 2012 23:12:43 -0600, AJ ONeal  wrote:

>I've tested with sqlite3 and the nodejs sqlite3 module and I get this error
>when using the example from the documentation (as well as variants more
>suitable to my application) for full-text search.
>
>Docs:
>http://www.sqlite.org/fts3.html#section_6_2_1
>
>Test:
>CREATE VIRTUAL TABLE t1 USING fts4(content="", a, b, c);
>CREATE VIRTUAL TABLE fts USING fts4(content="data", name TEXT, path TEXT);
>
>Result:
>unrecognized parameter: content=""
>
>Was this never implemented? Is it deprecated? Does it require special build
>options? Any thoughts?

Cannot reproduce that error message in the test above with:
SQLite version 3.7.12.1 2012-05-22 02:45:53 or
SQLite version 3.7.14 2012-06-21 17:21:52.

Is your test sample complete?


-- 
Regards,

Kees Nuyt

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] unrecognized parameter: content=""

2012-07-20 Thread AJ ONeal 
I've tested with sqlite3 and the nodejs sqlite3 module and I get this error
when using the example from the documentation (as well as variants more
suitable to my application) for full-text search.

Docs:
http://www.sqlite.org/fts3.html#section_6_2_1

Test:
CREATE VIRTUAL TABLE t1 USING fts4(content="", a, b, c);
CREATE VIRTUAL TABLE fts USING fts4(content="data", name TEXT, path TEXT);

Result:
unrecognized parameter: content=""

Was this never implemented? Is it deprecated? Does it require special build
options? Any thoughts?

AJ ONeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite, Linq, multithread and transaction usage

2012-07-20 Thread Joe Mistachkin 

The basic thread-safety rules of System.Data.SQLite are documented here:

https://system.data.sqlite.org/index.html/artifact?ci=trunk&filename=Doc/Ext
ra/limitations.html

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fwd: Some kind of disk I/O error occurred–SQLite3

2012-07-20 Thread wei luo 
-- Forwarded message --
From: wei luo 
Date: 2012/7/20
Subject: Some kind of disk I/O error occurred–SQLite3
To: danielk1...@gmail.com


hi:
i am a user who is seeing some kind of disk I/O error when
attempting to use an SQLite3 database.
i want to ask for you  help. my programe was writen by this:

while ( (res->sp) < row )
{
rc = sqlite3_step(res->pstmt);
if ( SQLITE_ROW == rc )
{
(res->sp)++;
}
else
{
return rc;
}
}
And i had use gdb getting the rc value. it is 10. And the 10  is
SQLITE_IOERR. See below:

  #define SQLITE_IOERR   10   /* Some kind of disk I/O error occurred */

  And i find the  SQLITE_IOERR  in your open sources. i got the infomation.
it is below:

/**
** The file I/O implementation can use the object type flags to
** change the way it deals with files.  For example, an application
** that does not care about crash recovery or rollback might make
** the open of a journal file a no-op.  Writes to this journal would
** also be no-ops, and any attempt to read the journal would return
** SQLITE_IOERR.  Or the implementation might recognize that a database
** file will be doing page-aligned sector reads and writes in a random
** order and set up its I/O subsystem accordingly.
/

Did it have any relations with journal ? if it had. Please tell me, how to
del the journal or how to resolve this problem.


Thanks

luowei
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqllite db - remote access on a shared host

2012-07-20 Thread Sebastian Bermudez 
I know 3 desktop app... wich make an PHP tunnel to manage sqlite3 db...

1) Navigat SQL Free  (has version for free)
2) SQL Maestro for sqlite (has version for free i think..)
3) Ems Manager for sqlite


--- On Fri, 7/20/12, Kieran Hever  wrote:

> From: Kieran Hever 
> Subject: [sqlite] sqllite db - remote access on a shared host
> To: sqlite-users@sqlite.org
> Date: Friday, July 20, 2012, 6:21 AM
> 
> 
> 
> 
> Hi, I there any application/program paid or free that will
> allow me to connect to a remote shared host sqlite DB. 
> A program which will allow me to make changes to the db
> design and do backups. I have very little control on the
> shared host.  I am hoping for something that will let
> me connect directly to the DB through a URL path and I will
> have a password on the db so that will be my security. I
> have looked at various apps and most are for local db
> access. ThanksKieran    
> 
>       
>   
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database AND table already exist?

2012-07-20 Thread Igor Tandetnik 
Black, Michael (IS)  wrote:
> Good pointso probably time equivalent either way.  Though table_info will 
> allow the feature creep of "does a column exist"
> pretty easily.

So would preparing a statement of the form "select ColumnToCheck from 
TableToCheck;"
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database AND table already exist?

2012-07-20 Thread Black, Michael (IS) 
Good pointso probably time equivalent either way.  Though table_info will 
allow the feature creep of "does a column exist" pretty easily.  Not that 
anybody ever adds requirements





Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems


From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of Igor Tandetnik [itandet...@mvps.org]
Sent: Friday, July 20, 2012 7:59 AM
To: sqlite-users@sqlite.org
Subject: EXT :Re: [sqlite] database AND table already exist?

Black, Michael (IS)  wrote:
> table_info() will be faster than doing "select *" I would think in most all 
> cases.

To check the existence of a table, you don't need to actually run the select 
statement - just prepare it and check for errors.
--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database AND table already exist?

2012-07-20 Thread Igor Tandetnik 
Black, Michael (IS)  wrote:
> table_info() will be faster than doing "select *" I would think in most all 
> cases.

To check the existence of a table, you don't need to actually run the select 
statement - just prepare it and check for errors.
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database AND table already exist?

2012-07-20 Thread Black, Michael (IS) 
I needed a quick excercise this morning.  Never used table_info() before.
table_info() will be faster than doing "select *" I would think in most all 
cases.



#include 
#include 
#include 
#include "sqlite3.h"

using namespace std;

bool dbExists(string dbName) {
  sqlite3 *db;
  int rc = sqlite3_open_v2(dbName.c_str(), &db, SQLITE_OPEN_READONLY, NULL);
  if(rc != SQLITE_OK) {
return false;
  }
  rc = sqlite3_close(db);
  if(rc != SQLITE_OK) {
cerr << "Error on sqlite3_close??" << endl;
  }
  return true;
}

bool tableExists(string dbName, string table) {
  sqlite3 *db;
  int rc = sqlite3_open_v2(dbName.c_str(), &db, SQLITE_OPEN_READONLY, NULL);
  if(rc != SQLITE_OK) {
return false; // db doesn't exist
  }

  sqlite3_stmt *stmt;
  stringstream ss;
  ss << "pragma table_info(" << table << ");";
  rc = sqlite3_prepare_v2( db, ss.str().c_str() , -1, &stmt, NULL );
  if(rc != SQLITE_OK) {
cerr << "Error on sqlite3_prepare_v2: " << sqlite3_errmsg(db) << endl;
  }
  rc = sqlite3_step(stmt);
  if(rc != SQLITE_DONE && rc != SQLITE_ROW) {
cerr << "Error on sqlite3_step: " << sqlite3_errmsg(db) << endl;
  }

  bool myReturn = false;
  if (sqlite3_data_count(stmt) > 0) {
myReturn = true;
  }
  sqlite3_finalize(stmt);
  sqlite3_close(db);
  return myReturn;
}


Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems




From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of Arbol One [arbol...@gmail.com]
Sent: Friday, July 20, 2012 5:51 AM
To: SqLite
Subject: EXT :[sqlite] database AND table already exist?


Is there a way to find out if a certain database AND table already exist?

In my C++ program I would like to query SQLite3 to find out if a database
already exists and also if a particular table exists in that database. Is
there a way to do this?

I am using std i/o methods to check for the existing SQLite3 file containing
the database, but I don't have a way to find out if the table in question
does in fact exist.



TIA



Freedom of speech does not translate to freedom of insulting



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite, Linq, multithread and transaction usage

2012-07-20 Thread Bernhard Mogens Ege 
Hi,

 

I have begun using SQLite in my C#/.NET 4.0 project and have created some
code already (which seems to work) but I am unsure about the multithread use
of SQLite in this context. I have tried to get wiser using the ADO.NET
documentation, but much of it is Sql (MS) specific. :-/

 

I am using a non-shared memory based SQLite db and have in VS2010 created an
entity based on an existing file-based SQlite database. I change the
connection string to :memory: once the entity is final:

 

// initialization (run only once)

string constring =
"metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provide
r=System.Data.SQLite;provider connection string=\";data source=:memory:\"";

sqlite = new testEntities(constring);

sqlite.Connection.Open(); 

/// create table (testEntities is built upon this table)

string query = @"CREATE TABLE IF NOT EXISTS DeviceMap(

UserId TEXT NOT NULL, 

UserInstance TEXT NOT NULL, 

GatewayHierarchyId TEXT NOT NULL, 

GatewayHardwareId TEXT NOT NULL, 

DeviceHierarchyId TEXT NOT NULL, 

DeviceHardwareId TEXT NOT NULL,

Active BOOL NOT NULL,

PRIMARY KEY (UserId, UserInstance, GatewayHierarchyId,
DeviceHierarchyId)

);";

sqlite.ExecuteStoreCommand(query, null);

// I also created some index… (not shown, but using ExecuteStoreCommand).

 

 

I save the “sqlite” instance for later use. This is the instance that is
access from multiple threads. Is that safe? If maybe, what is required to
make it safe? If not, would a separate testEntities instance make it
thread-safe (:memory: db has to be of the shared type)?

 

In my later queries, I access sqlite using ExecuteStoreCommand, but also
using Linq, probably from different threads and without any locks (not sure
if it is necessary). I make select, insert, update, delete queries.

 

Some of the queries I’d like to put in transactions. I am not sure how to
make transactions with SQLite in ADO.NET and certainly not if the methods I
make need to be multithread safe. One method could be this (unknown
multithread/transaction safe, would like some details):

 

public void Set(DeviceMap devObj)

{

// don't know how to use "insert or replace into" via Linq

string query = @"INSERT OR REPLACE INTO DeviceMap 

(UserId, UserInstance, GatewayHierarchyId, GatewayHardwareId,
DeviceHierarchyId, DeviceHardwareId, Active)

VALUES({0},{1},{2},{3},{4},{5},1);";

sqlite.ExecuteStoreCommand(query,

devObj.UserId,

devObj.UserInstance,

devObj.GatewayHierarchyId,

devObj.GatewayHardwareId,

devObj.DeviceHierarchyId,

devObj.DeviceHardwareId);

}

 

A select method could be this:

 

public List GetViaUserIdAndDeviceHardwareId(string
UserId, string DeviceHardwareId)

{

List x;

var q = from t in sqlite.DeviceMap 

where t.UserId == UserId && t.DeviceHardwareId ==
DeviceHardwareId && t.Active == true 

select t;

using (var t = new TransactionScope())

{

x = q.ToList();

t.Complete();

}

return x;

}

 

I have tried to add transaction to it but is it multithread safe? Am I doing
the transaction right?

 

I hope I am somewhat on the right track, but if not, any help could be
valuable to me.

 

Cheers,

 

Bernhard

=

Bernhard Mogens Ege

Software developer

 

E:   b...@saseco.dk

M: +45 51 90 50 86

 

Saseco

Åbogade 15

8200 Aarhus N

Denmark

=

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database AND table already exist?

2012-07-20 Thread Paul Corke 
On 20 July 2012 12:51, Simon Slavin wrote:

> PRAGMA table_info(myTable)

For just determining whether or not the table exists, we use:

SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND
name='some_table';

which seems easier than getting "one row for each column in the
named table".  Obviously this doesn't tell you anything about
the schema of the table, just a '1' or a '0'.

Regards,

Paul.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database AND table already exist?

2012-07-20 Thread Simon Slavin 

On 20 Jul 2012, at 11:51am, Arbol One  wrote:

> Is there a way to find out if a certain database AND table already exist?
> 
> In my C++ program I would like to query SQLite3 to find out if a database
> already exists and also if a particular table exists in that database. Is
> there a way to do this?

To find out if a database exists, use sqlite3_open_v2() and use the flag 
SQLITE_OPEN_READONLY as documented on



If the database doesn't exist, you'll get an error.  If the database does 
exist, it'll be opened and you can continue with

PRAGMA table_info(myTable)

as documented here



Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database AND table already exist?

2012-07-20 Thread Donald Griggs 
Darn.  I didn't mean to quote the table name: (though double quotes or
brackets are alllowed).   Sorry for the noise.

 SELECT 'anything'  FROM  MyTableInQuestion LIMIT 0;
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database AND table already exist?

2012-07-20 Thread Donald Griggs 
On Fri, Jul 20, 2012 at 6:51 AM, Arbol One  wrote:

> Is there a way to find out if a certain database AND table already exist?
>
> I am using std i/o methods to check for the existing SQLite3 file
> containing the database,


==> I think that's the standard method.


but I don't have a way to find out if the table in question
> does in fact exist.
>
> ==> You can
  - query sqlite_master
  - PRAGMA table_info
  - SELECT 'anything'  FROM 'MyTableInQuestion' LIMIT 0;
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Many tables in one database

2012-07-20 Thread Donald Griggs 
 Arbol One  wrote:

> Using SQLite3.7.8 amalgamation and C++, I would like to create a database
> with several joined tables. Can SQLite3 have many tables in one database?
>
> 
I'm perhaps not understanding your question.

-- If you mean  "Can a sqlite database contain more than one table?"
The answer is "certainly."   You may want to play with the commandline
utility and read a bit in sqlite.org

-- If you mean "Can sqlite accomodate an application with many hundreds of
tables?"The answer is "Yes, but it's likely your application would
benefit from more normalization."

-- If you mean, "Can sqlite accomodate table sharding" then I imagine the
answer is "No, but the UNION command *is* supported."

Do any of the above answer your question?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] database AND table already exist?

2012-07-20 Thread Arbol One 
Is there a way to find out if a certain database AND table already exist?

In my C++ program I would like to query SQLite3 to find out if a database
already exists and also if a particular table exists in that database. Is
there a way to do this?

I am using std i/o methods to check for the existing SQLite3 file containing
the database, but I don't have a way to find out if the table in question
does in fact exist.

 

TIA  

 

Freedom of speech does not translate to freedom of insulting

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqllite db - remote access on a shared host

2012-07-20 Thread Jean-Christophe Deschamps 


Hi, I there any application/program paid or free that will allow me to 
connect to a remote shared host sqlite DB.  A program which will allow 
me to make changes to the db design and do backups. I have very little 
control on the shared host.  I am hoping for something that will let 
me connect directly to the DB through a URL path and I will have a 
password on the db so that will be my security. I have looked at 
various apps and most are for local db access.


Try here:

http://www.atensoft.com/dev/sqlite3.php 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Many tables in one database

2012-07-20 Thread Arbol One 
Using SQLite3.7.8 amalgamation and C++, I would like to create a database
with several joined tables. Can SQLite3 have many tables in one database?

 

Freedom of speech does not translate to freedom of insulting

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqllite db - remote access on a shared host

2012-07-20 Thread Roger Andersson 

On 07/20/12 11:21, Kieran Hever wrote:




Hi, I there any application/program paid or free that will allow me to connect 
to a remote shared host sqlite DB.  A program which will allow me to make 
changes to the db design and do backups. I have very little control on the 
shared host.  I am hoping for something that will let me connect directly to 
the DB through a URL path and I will have a password on the db so that will be 
my security. I have looked at various apps and most are for local db access. 
ThanksKieran   
___


Google did return e.g. https://code.google.com/p/phpliteadmin/

/Roger

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqllite db - remote access on a shared host

2012-07-20 Thread Kieran Hever 




Hi, I there any application/program paid or free that will allow me to connect 
to a remote shared host sqlite DB.  A program which will allow me to make 
changes to the db design and do backups. I have very little control on the 
shared host.  I am hoping for something that will let me connect directly to 
the DB through a URL path and I will have a password on the db so that will be 
my security. I have looked at various apps and most are for local db access. 
ThanksKieran 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] force read schema after "delete from sqlite_master"

2012-07-20 Thread Gabriel Corneanu 

Yuriy Kaminskiy wrote:
>Check
>PRAGMA secure_delete;
>(and disable if it was enabled by default; it would be rendered 
ineffective by your trick anyway).


It is not enabled.

>Probably there are way to make it work (altering PRAGMA schema_version; or
>something), but I think it is way to hackerish and unsafe to use such 
tricks in

>anything resembling production code.
>Basically, you break consistency of your database image (and then 
kind-of-"fix"

>it with vacuum;).

Yes, and that's why I asked here.
"The Truncate Optimization" talks about something, but it's still quite 
slow.
To understand what I'm saying, please just try it; fill a dummy db until 
it's a few GB in size then try to "clear" it *quickly*.


-
Michael wrote:

>Why don't you just attach another database and switch your user 
connections to that one?

>Then you can just delete the old file and not worry about vaccum at all.

Unfortunately this is not an option at this time; readers are different 
independent processes, which are just prepared to handle a truncate...


>Sounds though like sqlite3 could use a "truncate" command like Oracle 
has which is the speedy way to zero out a table there.


This is what I asked for; but even with "Truncate Optimization" it still 
takes quite some time. It might be hard to avoid, because it probably 
needs to go through the btree to free pages.


But I really believe that a "clear" for the db should be relatively easy 
to do it *fast*; even if it's done without journaling, because it makes 
no real sense to journal a full delete (it means a full backup).
This is what I done via "delete from sqlite_master" / "vacuum", but I 
needed to be safe, therefore inside a transaction...



Gabriel


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users