Re: [sqlite] sqlite jdbc and rcp Eclipse

Hi Enrico, the eclipse runtime has some caching mechanism to avoid reading the plugins meta information on every startup. When I was new to eclipse rcp I had some hard time finding out why the changes to my plugins did not take effect and it was because of this caching. Starting your eclipse

Re: [sqlite] DBD::SQLite reporting corruption sqlite3 CL program does not

Not sure if this will help, running this through the debugger the error is being generated from DBD::SQLite::db::_login which is in the XS/C code. main::getDBConnection(projectory.cgi:1577): 1577: $dbh = DBI->connect("dbi:SQLite:dbname=projectory.sqlite3","","") or die "$DBI::errstr\n";

Re: [sqlite] Entering large chunk of data

On 24 Jun 2009, at 7:43pm, Dhruv Adhia wrote: > I want to enter 2000 news items at once for the testing purpose. I > would > like to know the shorter way out. Just make sure you put BEGIN ... COMMIT around the whole block of your INSERT commands. This will greatly speed up the process. On

Re: [sqlite] Getting

I believe that it is supposed to come with python, but I just downloaded python, compiled from source and the _sqlite3.so is not where it should be. A similar problem was described here: http://www.linuxquestions.org/questions/slackware-14/no-sqlite3.so-in-usrlib python2.5lib-dynload-599027/ I

[sqlite] Entering large chunk of data

Hello All, I have the following table in my database sqlite> .schema promo_new CREATE TABLE "promo_new" ( "id" integer NOT NULL PRIMARY KEY, "title" varchar(200) NOT NULL, "news_content" varchar(200) NOT NULL, "pub_date" datetime NOT NULL ); I want to enter 2000 news items at

Re: [sqlite] Getting

I think that sqlite3 is part of the standard python distribution since version 2.5. http://docs.python.org/library/sqlite3.html Are you trying to compile because you wanted a more up to date version? If not then you should be able to just start using it. On Wed, Jun 24, 2009 at 12:23 PM, Ryan

[sqlite] Getting

Hi, I¹m trying to get Python 2.6 installed with the sqlite3 module compiled, which according to the README requires sqlite3 ³including the header files². I¹ve tried compiling sqlite3.6.15 and was hoping there was a ‹with-[PACKAGE]=yes that would work but I don¹t know what the package name might

Re: [sqlite] Two simple questions

You'll have to call sqlite3_column_name() in a loop to find the named column returned from a prepared select statement. As for the default values, to get that information you'll have to execute a "PRAGMA TABLE_INFO(tablename)" query and examine the 5th column "dflt_value" for the row matching the

Re: [sqlite] Two simple questions

On Wed, Jun 24, 2009 at 12:18 PM, Shaun Seckman (Firaxis) wrote: > Just two quick and simple questions :) > > > >                In a prepared statement, is there a quick way to > determine what the index of a column with a specific name is or must I > just iterate

[sqlite] Two simple questions

Just two quick and simple questions :) In a prepared statement, is there a quick way to determine what the index of a column with a specific name is or must I just iterate through all columns and perform a string comparison? How can I go by determining the

Re: [sqlite] sqlite jdbc and rcp Eclipse

Hello Jurgen, sorry for my late (I've been off-line since 2 weeks due to adsl problem). I've never used clean option. What is it? How do I have to use it? Thanks. Cheers On Wed, Jun 10, 2009 at 7:43 AM, Juergen Schwitalla < j.schwita...@science-computing.de> wrote: > Hello Enrico, > > just to

Re: [sqlite] what is most effective way to temporarily disable triggers?

D. Richard Hipp wrote: > On Jun 24, 2009, at 10:35 AM, Michal Seliga wrote: >>> Instead of >>> >>> WHEN not exists(SELECT * FROM ) >>> >>> create an application-defined function (perhaps called >>> "enable_triggers()") that returns either 1 or 0 depending on the >>> setting of some

Re: [sqlite] what is most effective way to temporarily disable triggers?

On Wed, Jun 24, 2009 at 9:17 AM, Michal Seliga wrote: > hi > > in my application i sometimes must insert huge amount of pre-prepared data so > i > don't want triggers to do any action while i am inserting them > > for this reason i created one small table which is

Re: [sqlite] what is most effective way to temporarily disable triggers?

On Jun 24, 2009, at 10:35 AM, Michal Seliga wrote: >> >> Instead of >> >> WHEN not exists(SELECT * FROM ) >> >> create an application-defined function (perhaps called >> "enable_triggers()") that returns either 1 or 0 depending on the >> setting of some variable in your application. Then

Re: [sqlite] what is most effective way to temporarily disable triggers?

D. Richard Hipp wrote: > On Jun 24, 2009, at 9:17 AM, Michal Seliga wrote: > >> hi >> >> in my application i sometimes must insert huge amount of pre- >> prepared data so i >> don't want triggers to do any action while i am inserting them >> >> for this reason i created one small table which

Re: [sqlite] what is most effective way to temporarily disable triggers?

On Jun 24, 2009, at 9:17 AM, Michal Seliga wrote: > hi > > in my application i sometimes must insert huge amount of pre- > prepared data so i > don't want triggers to do any action while i am inserting them > > for this reason i created one small table which is normally empty, > however if it

[sqlite] what is most effective way to temporarily disable triggers?

hi in my application i sometimes must insert huge amount of pre-prepared data so i don't want triggers to do any action while i am inserting them for this reason i created one small table which is normally empty, however if it contains record set to 1 triggers shoudl not do any action. to make

[sqlite] How to enable_load_extension from ruby?

Hi everybody, I am running ruby and need to access sqlite3 with the SpatiaLite spatial extension enabled. Info on SpatiaLite extension: http://www.gaia-gis.it/spatialite Problem is, I can not find any description how to "enable_load_extension" from ruby. And without it no extension can be loaded

Re: [sqlite] What's the different of the types TEXT and VARCHAR in sqlite3?

Hi, type names do not matter in sqlite, see http://www.sqlite.org/datatype3.html Martin Kermit Mei schrieb: > Hello, I'm a newbie for sqlite3, I hope somebody can tell me what's the > different of TEXT and VARCHAR. Does TEXT can save arbitrary characters, > but VARCHAR? Which is better, then?

[sqlite] What's the different of the types TEXT and VARCHAR in sqlite3?

Hello, I'm a newbie for sqlite3, I hope somebody can tell me what's the different of TEXT and VARCHAR. Does TEXT can save arbitrary characters, but VARCHAR? Which is better, then? Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLITE_CORRUPT error

users >>> >>> __ Informazioni da ESET NOD32 Antivirus, versione del >>> database delle firme digitali 4177 (20090622) __ >>> >>> Il messaggio è stato controllato da ESET NOD32 Antivirus. >>> >>> www.nod32.it >>> >