On Mon, Jul 11, 2011 at 01:18, H. Phil Duby wrote:
> On Sat, Jul 9, 2011 at 23:22, Stephan Beal wrote:
>
>> On Sun, Jul 10, 2011 at 4:25 AM, Tom Browder
>> wrote:
>>
>> > sqlite db files and making sure that directory is writable by my web
>> > server. I make sure that the directory is not used
On Sat, Jul 9, 2011 at 23:22, Stephan Beal wrote:
> On Sun, Jul 10, 2011 at 4:25 AM, Tom Browder
> wrote:
>
> > sqlite db files and making sure that directory is writable by my web
> > server. I make sure that the directory is not used for anything else
> > in order to help secure my web site.
On Sun, Jul 10, 2011 at 4:25 AM, Tom Browder wrote:
> sqlite db files and making sure that directory is writable by my web
> server. I make sure that the directory is not used for anything else
> in order to help secure my web site.
>
Another tip for such uses:
.htaccess:
(or however your d
On Thu, Jun 30, 2011 at 15:02, Stephan Beal wrote:
> On Thu, Jun 30, 2011 at 9:52 PM, Tom Browder wrote:
>
>> But I think the journal file is the problem...as I understand it, it
>> has to be on disk, doesn't it?
The answer seems to be yes.
I have solved my problem by defining an explicit direc
On Thu, Jun 30, 2011 at 9:52 PM, Tom Browder wrote:
> But I think the journal file is the problem...as I understand it, it
> has to be on disk, doesn't it?
>
Now that you mention it, that might be:
http://www.sqlite.org/compile.html
i interpretted SQLITE_TEMP_STORE=3 as using memory for the jo
On Thu, Jun 30, 2011 at 14:44, Stephan Beal wrote:
> On Thu, Jun 30, 2011 at 9:06 PM, Tom Browder wrote:
...
>> Thanks, Richard (and Simon), I think I can solve my web access problem
>> by giving the db file its own directory.
...
> You can also try disabling the temp files (telling it to use mem
On Thu, Jun 30, 2011 at 9:06 PM, Tom Browder wrote:
> Thanks, Richard (and Simon), I think I can solve my web access problem
> by giving the db file its own directory.
>
You can also try disabling the temp files (telling it to use memory
instead).
--
- stephan beal
http://wanderinghorse.ne
On Thu, Jun 30, 2011 at 13:42, Richard Hipp wrote:
> On Thu, Jun 30, 2011 at 2:30 PM, Tom Browder wrote:
...
>> From my limited testing on my web server [temporary files] are
>> written in the same directory as the db file, but I would like them to
>> be written to a separate directory.
...
> Se
On 30 Jun 2011, at 7:30pm, Tom Browder wrote:
> I've not looked at the code yet, but is there any way, without
> changing the code and recompiling, to control where the temporary
> files are created? From my limited testing on my web server they are
> written in the same directory as the db file
On Thu, Jun 30, 2011 at 2:30 PM, Tom Browder wrote:
> From my limited testing on my web server [temporary files] are
> written in the same directory as the db file, but I would like them to
> be written to a separate directory.
>
See http://www.sqlite.org/tempfiles.html for a list of the variou
I've seen various threads in the users' list archives about the
subject of temporary file location with no definitive answer, and I've
seen the use of the pragma temp_store_directory is deprecated so that
solution is out.
I've not looked at the code yet, but is there any way, without
changing the
11 matches
Mail list logo