[sqlite] (no subject)

Hi, I have few queries regarding the SQLite. I have listed them below please go through them and give your answers. Thanks Say if I am working on a DB with 3 tables with 100 records each and each records with some 5 fields of data.Each field is varchar(20) 1. What will be the Stack Size? 2.

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

Yes: Inserts wrapped in transactions 10,000 at a shot. Tried pragma synchronous=OFF And 3 different threadsafe compilations for sqlite: # define SQLITE_THREADSAFE 0 /* IMP: R-07272-22309 */ # define SQLITE_THREADSAFE 1 /* IMP: R-07272-22309 */ # define SQLITE_THREADSAFE 2 /* IMP: R-07272-22309

Re: [sqlite] how to?

On Tue, Jun 5, 2012 at 12:43 PM, Jonas Malaco Filho < jonasmalacofi...@gmail.com> wrote: > I think that session info is stored in sessionrestore.js, in your Firefox > profile data folder. There is also a sessionrestore.bak, that may help you. > You can check if you have other (older) versions of

Re: [sqlite] how to?

I think that session info is stored in sessionrestore.js, in your Firefox profile data folder. There is also a sessionrestore.bak, that may help you. You can check if you have other (older) versions of these files thanks to shadowing (or any other recovery methods). *Jonas Malaco Filho*

[sqlite] Select into outfile C API

Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? I see the sqlite3 binary has an interactive .output parameter. Anything similar in the C API? TIA Pat... ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] how to?

On 5 Jun 2012, at 12:26pm, baboushka jane wrote: > i hope i have found the right place. i would like some help with my sqlite > files. > a week or so back i was clearing my recent Firefox history when my browser > froze and so i used Activity Monitor to force close

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

Have you run your bare metal test using the same share? And have you tried "pragma synchronous=OFF" ?? And I assume you are using transactions? Have you profiled your app to see where it's spinning? Probably trying to get the lock on the share. What flags did you use to comiple the sqlite

[sqlite] how to?

i hope i have found the right place. i would like some help with my sqlite files. a week or so back i was clearing my recent Firefox history when my browser froze and so i used Activity Monitor to force close Firefox. meanwhile, i was reading an e-mail and clicked on a link which opened up a

Re: [sqlite] encrypt/decrypt sqlite3 database file or content

On Tue, Jun 5, 2012 at 2:49 AM, Durga D wrote: > Hi All, > > >I am developing sqlite3 based application. I want to create/maintain > sqlite3 database in encrypted. Others should not have rights to open this > database without key. Is there any sqlite3 api's to do this?

[sqlite] encrypt/decrypt sqlite3 database file or content

Hi All, I am developing sqlite3 based application. I want to create/maintain sqlite3 database in encrypted. Others should not have rights to open this database without key. Is there any sqlite3 api's to do this? Thanks in advance. Regards,