[sqlite] With recursive question

2015-02-28 Thread Igor Tandetnik
On 2/28/2015 7:22 PM, Jean-Christophe Deschamps wrote: > Once again thank you very much Igor. I was making my life miserable > trying to scan the "tree" from the other end. That, too, could be arranged. Something along these lines: with recursive FileDirs as ( select FileId, FileDirID

[sqlite] Sqlite and threads/multiple applications

2015-02-28 Thread Simon Slavin
On 28 Feb 2015, at 7:02pm, Olivier Vidal wrote: > According to this paragraph http://www.sqlite.org/faq.html#q5, multiple > applications or multiple instances of the same application can access the > *same* database at the *same time*. Even in WAL mode? Yes. Assuming that you are talking

[sqlite] Sqlite and threads/multiple applications

2015-02-28 Thread Olivier Vidal
Hello all, According to this paragraph http://www.sqlite.org/faq.html#q5, multiple applications or multiple instances of the same application can access the *same* database at the *same time*. Even in WAL mode? If I have understood correctly, all applications will be able to read the sqlite

[sqlite] With recursive question

2015-02-28 Thread Igor Tandetnik
On 2/28/2015 6:02 PM, Jean-Christophe Deschamps wrote: > What I want to obtain is the list of all files (in random order but > that's not the point) containing: > FileID > FileName > Directory path from root using some kind of group_concat(dir, '/') with recursive DirTree as ( select DirID, ''

[sqlite] Sqlite and threads/multiple applications

2015-02-28 Thread Keith Medcalf
>If I have understood correctly, all applications will be able to read >the sqlite database at the same time, but there will be only one thread >(one thread of one application) who will write at the same time (in WAL >mode). There will be only one *connection* that can write at a time. This will

[sqlite] List duplication

2015-02-28 Thread Tim Streater
On 27 Feb 2015 at 22:47, Simon Slavin wrote: > On 27 Feb 2015, at 10:04pm, R.Smith wrote: > >> Ah, I think this is the answer probably. Maybe people hitting the "reply to >> all" or such and it copies across lists. Simon is possibly not subscribed to >> both, hence not getting duplicates. > >

[sqlite] List duplication

2015-02-28 Thread Darren Duncan
On 2015-02-28 3:15 AM, R.Smith wrote: > On 2015-02-28 05:02 AM, Darren Duncan wrote: >> I'm seeing a lot of message duplication too, but the ones I see are due to >> someone putting the list address twice as a recipient. >> >> For example a bunch of the "PhD student" messages say "To" >>

[sqlite] List duplication

2015-02-28 Thread R.Smith
On 2015-02-28 05:02 AM, Darren Duncan wrote: > I'm seeing a lot of message duplication too, but the ones I see are > due to someone putting the list address twice as a recipient. > > For example a bunch of the "PhD student" messages say "To" > sqlite-users at mailinglists.sqlite.org plus "Cc"

[sqlite] problem compiling std_call dll

2015-02-28 Thread Bart Smissaert
Trying to compile a std_call dll to be used with VB6 and VBA. Using instructions and files from this website: https://sqliteforexcel.codeplex.com/ All works well and have added a few SQLite functions that weren't in the compiled dll as in the download section from that website. However having

[sqlite] List duplication

2015-02-28 Thread R.Smith
On 2015-02-28 12:47 AM, Simon Slavin wrote: > On 27 Feb 2015, at 10:04pm, R.Smith wrote: > >> Ah, I think this is the answer probably. Maybe people hitting the "reply to >> all" or such and it copies across lists. Simon is possibly not subscribed >> to both, hence not getting duplicates. > I

[sqlite] List duplication

2015-02-28 Thread R.Smith
On 2015-02-27 10:09 PM, Peter Aronson wrote: > I've seen it too. All of the duplicate messages appear to have been sent to > both sqlite-dev at mailinglists.sqlite.org and sqlite-dev at sqlite.org or to > both sqlite-usersmailinglists.sqlite.org and sqlite-users at sqlite.org. Ah, I think