Re: [sqlite] parallelizing an update

On 31 Jan 2010, at 12:15am, Robert Citek wrote: > The question would be, how to modify the script to process the data in > with parallel processes? Run any number of of copies of the script at once. The script takes any record which has not so far been processed, processes it and writes the

Re: [sqlite] parallelizing an update

Sure. This script can use a lot of aesthetic improvement, but it highlights processing the data in a single process. The question would be, how to modify the script to process the data in with parallel processes? Regards, - Robert On Sat, Jan 30, 2010 at 4:36 AM, Sylvain Pointeau

Re: [sqlite] overwritten iphone contacts

thanks for all answers, I learned all necessary keywords to search internet further. On Sat, Jan 30, 2010 at 6:21 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > ishak kalkavan wrote: > > file I could see phone numbers and contact names but in

Re: [sqlite] overwritten iphone contacts

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ishak kalkavan wrote: > file I could see phone numbers and contact names but in a very complex way. > I couldnt find any way to match those data. The file format is documented at http://www.sqlite.org/fileformat.html Roger -BEGIN PGP

Re: [sqlite] Getting an error "table insert failed for eventLog" any idea what is the reason

On 30 Jan 2010, at 4:00pm, Vasanta wrote: > Thanks Simon. actually I have one sql file contains all tables info > (system.sql, then system.db file gets created using this command "sqlite3 > system.sb < system.sql), then lua script runs on this database file using > default configuration

Re: [sqlite] Bug Report

CAST was just an attempt to workaround the problem... I just need a way to know what type is "UserCount"... in the query, it is an Integer (because it is a aggregated COUNT function). If SQLite is unable to determine it's type, at least pragma table_info should then get it from a CAST =\ On Sat,

Re: [sqlite] Bug Report

> RecNo cid name typenotnull dflt_value pk > - --- -- --- --- -- -- >1 0 ID CHAR(32)0 (null) 0 >2 1 Active BOOLEAN 0 (null) 0 >3 2 Name VARCHAR(64)

[sqlite] Bug Report

Consider those tables: CREATE TABLE [UserGroups] ([ID] CHAR(32) PRIMARY KEY NOT NULL UNIQUE,[Active] BOOLEAN NOT NULL,[Name] VARCHAR(64) NOT NULL,[PasswordExpiration] INTEGER NOT NULL,[Created] DATE NOT NULL, [Modified] DATE NULL); and CREATE TABLE [Users] ([ID] CHAR(32) PRIMARY KEY NOT NULL

Re: [sqlite] Getting an error "table insert failed for eventLog" any idea what is the reason

Thanks Simon. actually I have one sql file contains all tables info (system.sql, then system.db file gets created using this command "sqlite3 system.sb < system.sql), then lua script runs on this database file using default configuration (restoreDB.lua system.db def_config_ascii), then this

Re: [sqlite] Getting an error "table insert failed for eventLog" any idea what is the reason

>when Database tries to create tables, getting the below error: >"table insert failed for eventLog" any idea what is the reason, also I >have >these errors when I run manually, I gets these: Uh! To help you in an efficient manner, it's obvious we absolutely need an octal core dump of your

Re: [sqlite] Getting an error "table insert failed for eventLog" any idea what is the reason

On 29 Jan 2010, at 8:52pm, Vasanta wrote: > when Database tries to create tables, getting the below error: > "table insert failed for eventLog" any idea what is the reason, also I have > these errors when I run manually, I gets these: Everything apart from this line > sh: 1: unknown operand

[sqlite] Getting an error "table insert failed for eventLog" any idea what is the reason

when Database tries to create tables, getting the below error: "table insert failed for eventLog" any idea what is the reason, also I have these errors when I run manually, I gets these: SQL error near line 2: table dbUpdateRegisterTbl already exists SQL error near line 17: table sqliteLock

Re: [sqlite] overwritten iphone contacts

On Sat, 30 Jan 2010 03:13:35 +, ishak kalkavan wrote: >I accidently overwritten my iphone's contact list with an empty one. here is >what I have done so far. > >- I jailbreaked my phone and accessed its files. >- copied addressbook.sqlitedb >- tried to browse the file with

Re: [sqlite] parallelizing an update

a good thing would have been to generate one file with all the statements... if you do that then you run sqlite with this file surrounded by transaction begin/commit echo "begin transaction" >> update.sql sqlite3 -separator $'\t' sample.db 'select rowid, item from foo;' | while read rowid item ;

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

thank you for the feedback, good that there is no issue. best regards, Sylvain On Sat, Jan 30, 2010 at 4:19 AM, Edward Diener < eldlistmaili...@tropicsoft.com> wrote: > Sylvain Pointeau wrote: > > Why don't you use sqlite as a dll? > > I am using it as a DLL. The actual types I mentioned are in