Re: [sqlite] sql server management studio like tool for SQLite

2011/11/4 David Hubbard : > Is there any tool for SQLite like sql server management studio? We are > looking at using SQLite and I have no > expireince with it but would like an easy to use tool to use with > SQLite that can perform the same functions as SSMS. http://www.adminer.org/ -- Kit _

Re: [sqlite] concurrent writes and reads to /from DB

Is there a good practice /setting for such high rate of concurrent writes with reads ? I understand that multiple readers with single writer at any time t is the model which sqlite has with various locks/states (unlocked, pending , shared , reserved , exclusive). "with" is a bit unclear. To

Re: [sqlite] concurrent writes and reads to /from DB

Hi, Using sqlite version 3.6.x, so WAL mode not available. Need to see if i need to upgrade to 3.7.x. By the way, in WAL mode, i understand that whenever the WAL file reaches 1000 page of changes(which is the default), only then checkpoint/write happens to the real database file . Ho

[sqlite] Converting existing database to WAL

I'm checking my understanding. Please confirm, deny, or point out problems. I have a database file created with version 3.6.x, but are now using 3.7.3. I don't use an weird PRAGMAs. I can rely on other people not using the file while I convert. All I need to do to convert it to WAL mode is

Re: [sqlite] Converting existing database to WAL

On Sat, Nov 5, 2011 at 3:09 PM, Simon Slavin wrote: > I'm checking my understanding. Please confirm, deny, or point out > problems. > > I have a database file created with version 3.6.x, but are now using > 3.7.3. I don't use an weird PRAGMAs. I can rely on other people not using > the file wh

Re: [sqlite] concurrent writes and reads to /from DB

On Sat, Nov 5, 2011 at 2:56 PM, swamir wrote: > > Hi, >Using sqlite version 3.6.x, so WAL mode not available. Need to see if i > need to upgrade to 3.7.x. > > By the way, in WAL mode, i understand that whenever the WAL file reaches > 1000 page of changes(which is the default), only then check

Re: [sqlite] Converting existing database to WAL

On 5 Nov 2011, at 7:43pm, Richard Hipp wrote: > On Sat, Nov 5, 2011 at 3:09 PM, Simon Slavin wrote: > >> open database >> PRAGMA journal_mode = WAL >> close database > > The above is all you need to do. Many thanks. Simon. ___ sqlite-users mailing

Re: [sqlite] sql server management studio like tool for SQLite

Kit, I've tried many of the tools listed @ http://www.sqlite.org/cvstrac/wiki?p=ManagementTools. My hands-down vote is for SQLiteExpert Professional @ http://sqliteexpert.com/. In my opinion spending $59 for the Pro version is a **no-brainer** for many reasons. John

Re: [sqlite] sql server management studio like tool for SQLite

At 21:46 05/11/2011, you wrote: In my opinion spending $59 for the Pro version is a **no-brainer** for many reasons. Seconded! Time saved in few days pays back the ticket. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:80

Re: [sqlite] WAL mode is reliable?

> boun...@sqlite.org] On Behalf Of Richard Hipp > (2) WAL really does give better concurrency since it allows other processes > to continue reading while a single process is writing to the database. In > rollback mode you can have one writer *or* multiple readers. In WAL mode > you can have one w