Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

2018-06-10 Thread Kevin Benson
On Sun, Jun 10, 2018 at 12:45 PM skywind mailing lists < mailingli...@skywind.eu> wrote: > Hi, > > but to which directory should I set it? There is no general tmp directory > accessible. > > Regards, > Hartwig > > > Am 2018-06-10 um 02:30 schrieb Bob Friesenhahn < > bfrie...@simple.dallas.tx.us>:

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

2018-06-10 Thread Thomas Kurz
I suggest using a tmp directory within in your private app directory. - Original Message - From: skywind mailing lists To: SQLite mailing list Sent: Sunday, June 10, 2018, 18:44:45 Subject: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail Hi, but to

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

2018-06-10 Thread skywind mailing lists
Hi, but to which directory should I set it? There is no general tmp directory accessible. Regards, Hartwig > Am 2018-06-10 um 02:30 schrieb Bob Friesenhahn : > > On Sat, 9 Jun 2018, skywind mailing lists wrote: > >> Hi, >> >> currently I am not creating large subqueries or views and therefor

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

2018-06-09 Thread Simon Slavin
On 10 Jun 2018, at 1:30am, Bob Friesenhahn wrote: > On Sat, 9 Jun 2018, skywind mailing lists wrote: > >> storing the temporary data in memory is a solution but I would like to have >> a future proof solution. And I do not like to think about it anymore in the >> future. > > Have you tried se

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

2018-06-09 Thread Bob Friesenhahn
On Sat, 9 Jun 2018, skywind mailing lists wrote: Hi, currently I am not creating large subqueries or views and therefore storing the temporary data in memory is a solution but I would like to have a future proof solution. And I do not like to think about it anymore in the future. Have you t

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

2018-06-09 Thread skywind mailing lists
Hi, currently I am not creating large subqueries or views and therefore storing the temporary data in memory is a solution but I would like to have a future proof solution. And I do not like to think about it anymore in the future. Or can we stop deprecating sqlite3_temp_directory? Why was it a

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

2018-06-09 Thread Dan Kennedy
On 06/10/2018 12:00 AM, skywind mailing lists wrote: Hi, what is your experience with temporary files requested by SQLite3 on Android? I am using SQLite3 natively on Android - I compiled SQLite3 by myself - and get an error when SQLite3 tries to create temporary files because: - the directori

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

2018-06-09 Thread J. King
On June 9, 2018 1:08:07 PM EDT, J Decker wrote: >On Sat, Jun 9, 2018 at 10:00 AM skywind mailing lists < >mailingli...@skywind.eu> wrote: > >> Hi, >> >> what is your experience with temporary files requested by SQLite3 on >> Android? I am using SQLite3 natively on Android - I compiled SQLite3 >by

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

2018-06-09 Thread J Decker
On Sat, Jun 9, 2018 at 10:00 AM skywind mailing lists < mailingli...@skywind.eu> wrote: > Hi, > > what is your experience with temporary files requested by SQLite3 on > Android? I am using SQLite3 natively on Android - I compiled SQLite3 by > myself - and get an error when SQLite3 tries to create

[sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

2018-06-09 Thread skywind mailing lists
Hi, what is your experience with temporary files requested by SQLite3 on Android? I am using SQLite3 natively on Android - I compiled SQLite3 by myself - and get an error when SQLite3 tries to create temporary files because: - the directories /var/tmp /usr/tmp /tmp