Re: [sqlite] overwritten iphone contacts

no backups at itunes or anywhere. thanks. On Sat, Jan 30, 2010 at 3:44 AM, Simon Slavin wrote: > > On 30 Jan 2010, at 3:13am, ishak kalkavan wrote: > > > I accidently overwritten my iphone's contact list with an empty one. here > is > > what I have done so far. > > You

Re: [sqlite] overwritten iphone contacts

On 30 Jan 2010, at 3:13am, ishak kalkavan wrote: > I accidently overwritten my iphone's contact list with an empty one. here is > what I have done so far. You have no backup of your phone's data in iTunes ? It should have automatically been taking backups at regular intervals. Were you

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

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 the sqlite3.h header file but I am linking to the sqlite3.dll through the sqlite3.lib import library. I appreciate your help and do not want to waste your time anymore. I

[sqlite] overwritten iphone contacts

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 tools like sqlite manager. (could not find any contacts) - opened the

[sqlite] parallelizing an update

Are there some white papers or examples of how to do updates in parallel using sqlite? I have a large dataset in sqlite that I need to process outside of sqlite and then update the sqlite database. The process looks something like this: sqlite3 -separator $'\t' sample.db 'select rowid, item

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

Why don't you use sqlite as a dll? then you can download it already pre-compiled. I know this is not always possible (or wanted). Cheers, Sylvain On Fri, Jan 29, 2010 at 6:35 PM, Edward Diener < eldlistmaili...@tropicsoft.com> wrote: > Sylvain Pointeau wrote: > > Hello, > > > > Sorry I

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

Sylvain Pointeau wrote: > Hello, > > Sorry I believed you tried to compile sqlite in C++/CLI (managed) > if you access sqlite from unmanaged class then I think everything is fine. > I don't know if this warning message is important or not, I would say "no". > Why don't you use the dll only? What

Re: [sqlite] SQlite query performs 10 times slower than MS Access query

> > > The sqlite3_stmt_status() interface was designed for this purpose. > http://www.sqlite.org/c3ref/stmt_status.html > Thanks for the info, I hope it will be extended also with other counters I did some test with this Rowid/Id trick. A larger base, 22mb, 100,000 records (220 bytes per record

Re: [sqlite] what are the limitations for IN() lists?

On Jan 29, 2010, at 8:10 PM, Tim Romano wrote: > Dan, > Thanks for that detail about the b-tree for IN-list queries. When I > examine a query plan for a query like the one below: > > explain query plan > select * from title where id IN(10,20,30,40) > > the plan indicates that an index is used

Re: [sqlite] what are the limitations for IN() lists?

Dan, Thanks for that detail about the b-tree for IN-list queries. When I examine a query plan for a query like the one below: explain query plan select * from title where id IN(10,20,30,40) the plan indicates that an index is used (there's a unique index on title.id) : TABLE title WITH INDEX

[sqlite] enable ICU in SQLite on windows platform

hi all I tried to enable using ICU by SQLite engine (to support Unicode) and found issue: when I added preprocessor define SQLITE_ENABLE_ICU i got error about "can't find function icu_openDatabase" or so. I found that this function is located in file ext/icu/icu.c of Linux source package, but

Re: [sqlite] SQlite query performs 10 times slower than MS Access query

On Jan 7, 2010, at 8:18 AM, Tim Romano wrote: > I don't claim any SQLite expertise, but indexes on values like > True/False, Male/Female -- i.e. where there are only a couple or a few > different values possible in the column -- are normally to be > avoided > because low-cardinality indexes

Re: [sqlite] SQlite query performs 10 times slower than MS Access query

On Jan 29, 2010, at 6:15 AM, Max Vlasov wrote: > To be sure that there's no > full or almost-full table scan I use VFS monitoring in such cases. The sqlite3_stmt_status() interface was designed for this purpose. http://www.sqlite.org/c3ref/stmt_status.html D. Richard Hipp d...@hwaci.com

Re: [sqlite] SQlite query performs 10 times slower than MS Access query

On Fri, Jan 29, 2010 at 6:02 AM, Doyel5 wrote: > I deleted all indexes, kept only the indexes on the temporary tables, > namely > - tempSimArgs and tempPartArgs, and seemingly my original query's running > time decreased to around 1 sec (when I ran the query the second time).

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

Hello, Sorry I believed you tried to compile sqlite in C++/CLI (managed) if you access sqlite from unmanaged class then I think everything is fine. I don't know if this warning message is important or not, I would say "no". Why don't you use the dll only? Cheers, Sylvain On Fri, Jan 29, 2010 at

Re: [sqlite] sqlite3_finalize(transaction_stmt) nonsense ?

And yes - i failed at another point: hangup() must work so: PyObject *LiteLineUp_HangUp(litelineup *self) { Py_ssize_t i = 0; if (self->COMMIT_stmt) { sqlite3_finalize(self->COMMIT_stmt); self->COMMIT_stmt = NULL; } while (L3LSELF->update_stmts[i++]) sqlite3_finalize(self-