Re: [sqlite] how to disable a trigger

2011-10-02 Thread Mr. Puneet Kishor
On Oct 2, 2011, at 10:29 PM, Igor Tandetnik wrote: > Sam Carleton wrote: >> Is there any way to "disable" a trigger in sqlite? > > If you have control over the trigger's definition, you could do something > like this: > > create trigger MyTrigger on ... > when

Re: [sqlite] how to disable a trigger

2011-10-02 Thread Igor Tandetnik
BareFeetWare wrote: > On 03/10/2011, at 2:12 PM, Sam Carleton wrote: > >> Ok, how do I list what a trigger is so that I can add it back once I want to >> "reactive" it? > > select SQL from SQLite_Master where name = 'trigger name' and Type = 'trigger' And be careful

Re: [sqlite] how to disable a trigger

2011-10-02 Thread Igor Tandetnik
Sam Carleton wrote: > Is there any way to "disable" a trigger in sqlite? If you have control over the trigger's definition, you could do something like this: create trigger MyTrigger on ... when (select enabled from TriggerControl where name='MyTrigger') begin ...

Re: [sqlite] how to disable a trigger

2011-10-02 Thread BareFeetWare
On 03/10/2011, at 2:12 PM, Sam Carleton wrote: > Ok, how do I list what a trigger is so that I can add it back once I want to > "reactive" it? select SQL from SQLite_Master where name = 'trigger name' and Type = 'trigger' Tom Tom Brodhurst-Hill BareFeetWare -- iPhone/iPad/iPod and Mac

Re: [sqlite] how to disable a trigger

2011-10-02 Thread Mr. Puneet Kishor
On Oct 2, 2011, at 10:12 PM, Sam Carleton wrote: > Ok, how do I list what a trigger is so that I can add it back once I want to > "reactive" it? You are looking to temporarily deactivate a TRIGGER, but there is no such mechanism. You could simply copy the code for the TRIGGER, then DROP it,

Re: [sqlite] how to disable a trigger

2011-10-02 Thread Sam Carleton
Ok, how do I list what a trigger is so that I can add it back once I want to "reactive" it? On Sun, Oct 2, 2011 at 9:07 PM, Igor Tandetnik wrote: > Sam Carleton wrote: > > Is there any way to "disable" a trigger in sqlite? > > DROP TRIGGER > --

Re: [sqlite] how to disable a trigger

2011-10-02 Thread Igor Tandetnik
Sam Carleton wrote: > Is there any way to "disable" a trigger in sqlite? DROP TRIGGER -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] how to disable a trigger

2011-10-02 Thread Sam Carleton
Is there any way to "disable" a trigger in sqlite? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

2011-10-02 Thread Joe Mistachkin
Marc Henrickson wrote: > > System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> > System.TypeInitializationException: The type initializer for 'System.Data.SQLite.SQLiteFactory' threw an exception. ---> > System.DllNotFoundException: Unable

Re: [sqlite] System.Data.SQLite - is 1.0.74 or 1.0.75 thecurrentversion?

2011-10-02 Thread Joe Mistachkin
Wamiduku wrote: > > Are there any plans to also provide the stable version as a NuGet package? > Yes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite - is 1.0.74 or 1.0.75 the currentversion?

2011-10-02 Thread Wamiduku
OK, so the version on the download page is the stable version and the NuGet package is the development version. Are there any plans to also provide the stable version as a NuGet package? -John On Oct 1, 10:33 pm, "Joe Mistachkin" wrote: > Wamiduku wrote: > > > Is this a

Re: [sqlite] How Do i use sqlite3 log?

2011-10-02 Thread Kees Nuyt
On Sun, 02 Oct 2011 21:20:27 +0800, ?? wrote: > thank you very much for replying me. my application is really > very slow when insert data, and i have tried translation. I guess you mean transaction, not translation? > but it does not increase speed. so what can i do?

Re: [sqlite] row storage / column order

2011-10-02 Thread yary
Data is stored in pages, and if you have a large blob as the first column, the other data is being pushed out to other pages (I think they are called "internal pages" in the docs). So to read the other data, sqlite has to first read the row's header page, then find & read the page that the other

Re: [sqlite] How Do i use sqlite3 log?

2011-10-02 Thread 张一帆
thank you very much for replying me. my application is really very slow when insert data,and i have tried translation. but it does not increase speed. so what can i do? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] row storage / column order

2011-10-02 Thread Mira Suk
_ > Od: "Simon Slavin" > Datum: 02.10.2011 14:01 > > >On 2 Oct 2011, at 12:49pm, Mira Suk wrote: > >> CREATE TABLE [Data1] (Index INTEGER PRIMARY KEY NOT NULL, Data BLOB, >> Description TEXT) >> vs >> CREATE TABLE [Data2] (Index

Re: [sqlite] row storage / column order

2011-10-02 Thread Simon Slavin
On 2 Oct 2011, at 12:49pm, Mira Suk wrote: > CREATE TABLE [Data1] (Index INTEGER PRIMARY KEY NOT NULL, Data BLOB, > Description TEXT) > vs > CREATE TABLE [Data2] (Index INTEGER PRIMARY KEY NOT NULL, Description TEXT, > Data BLOB) > > essentially those tables are same. however accessing the

[sqlite] row storage / column order

2011-10-02 Thread Mira Suk
Hey everyone,   Imagine tables   CREATE TABLE [Data1] (Index INTEGER PRIMARY KEY NOT NULL, Data BLOB, Description TEXT) vs CREATE TABLE [Data2] (Index INTEGER PRIMARY KEY NOT NULL, Description TEXT, Data BLOB)   essentially those tables are same. however accessing the column "Description"

[sqlite] query performance help

2011-10-02 Thread Mira Suk
Hey everyone,   currently I have some temporary table which I populate this way (recursive triggers on)   CREATE TEMPORARY TABLE IF NOT EXISTS NestedEntriesResult_ID (IDX INTEGER NOT NULL, DBORDER INTEGER PRIMARY KEY NOT NULL);   CREATE TEMPORARY TRIGGER IF NOT EXISTS NestedEntriesPopulate_ID