Re: [sqlite] How to execute SQL Query via text/sql file

Great. Thanx. I will try that out and get back to you ASAP Thanks & Regards, Sachin Gupta| iPolicy Networks -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Tuesday, January 18, 2011 6:06 PM To: sq

Re: [sqlite] How to execute SQL Query via text/sql file

Subject: Re: [sqlite] How to execute SQL Query via text/sql file Sachin Gupta wrote: > We want that the SQLite schema and data be written in a text file. When the > application comes up, the SQL file can be executed to > create the schema and import the data. The text file would have t

[sqlite] How to execute SQL Query via text/sql file

code by creating a command invoking sqlplus and passing the file with a @. I was wondering whether the same could be achieved with SQLite (in Memory). I know can be done via code pretty easily, but still if we have the schema and data in a text file, it would help a lot. Thanks & Regards, Sa

Re: [sqlite] Using WAL?

sers@sqlite.org Subject: Re: [sqlite] Using WAL? "Sachin Gupta" schrieb im Newsbeitrag news:51b335651c9a0c4ea520d47f23a580b414f5d4d...@sinnodmbx001.techmahindra.com... > Thank you for the detailed response. > It sure does help us a lot. > > One more Q for you: > Considering

Re: [sqlite] Using WAL?

Subject: Re: [sqlite] Using WAL? "Sachin Gupta" schrieb im Newsbeitrag news:51b335651c9a0c4ea520d47f23a580b414f5cd5...@sinnodmbx001.techmahindra.com... > --- The Application will be using the in memory SQLite > as Cache. You could also consider some sort of "sorted Dictiona

[sqlite] FW: Using WAL?

ions: Ques. No there will be no such instances, since the InMemory-DB-Connection is used on only one thread - but that isn't really a problem, if you "do it right"... >>>> Does that mean that only one connection can be made to In Memory DB? I >>>> read some

Re: [sqlite] Using WAL?

sage- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Eric Smith Sent: Friday, December 31, 2010 9:11 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Using WAL? Sachin Gupta wrote: > Our application is kind of heavily multi-thre

Re: [sqlite] Using WAL?

concurrency? Can using Shared Cache Mode be of use? http://www.sqlite.org/sharedcache.html Experts: Your comments please. Thanks & Regards, Sachin Gupta -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dustin Sallings Sent: Fr

Re: [sqlite] Using WAL?

...@sqlite.org [sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin [slav...@bigfraud.org] Sent: Thursday, December 30, 2010 7:50 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Using WAL? On 30 Dec 2010, at 10:51am, Sachin Gupta wrote: > Is there a way to know whether WAL mode

Re: [sqlite] Using WAL?

Is there a way to know whether WAL mode is turned on? Thanks & Regards, Sachin Gupta -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Sachin Gupta Sent: Thursday, December 30, 2010 2:57 PM To: General Discussion of SQ

[sqlite] Using WAL?

. Thanks & Regards, Sachin Gupta -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, December 29, 2010 12:01 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Cancel execution

Re: [sqlite] Cancel execution of a executing Query

, and does not complete execution. This would cause problems! So to come out of this, we would need a unique transaction id to kill it. Is there a way to achieve this or is there a better way to do this? Thanks & Regards, Sachin Gupta -Original Message- From: sqlite-users-boun

[sqlite] Cancel execution of a executing Query

Hi, Suppose that there is a query executing on the in memory Database which I have executed. Now in my application, I want the user to have the functionality to be able to cancel the ongoing query depending on certain scenarios. How can I achieve the same? Thanks & Regards, Sachin G