[sqlite] View workarounds

My suggestion is add the extra columns you need to the view, then when you make a query against that view, only specify the more limited set of output columns you want in the final output As others have said already, don?t think of a view as a stored query. Think of it as multiple joined table

[sqlite] BUG: readline is not auto-detected

it seemed to detect it for me when I built on Debian 7 I had the following packages installed via apt-get: readline-common libreadline6-dev libreadline6 On May 20, 2016, at 6:07 AM, Jeroen Demeyer wrote: > With SQLite 3.13.0 using the autoconf tarball, running ./configure without > arguments

[sqlite] Podcast with Dr Hipp: SQLite history,    success and funding

ps - I had not heard of veracity before and on the surface it looks quite interesting as a direct competitor to fossil, but it also looks a bit abandoned. On May 18, 2016, at 11:38 AM, Steve Schow wrote: > Interesting read, thanks! > > I?m new to fossil, but personally I have

[sqlite] Podcast with Dr Hipp: SQLite history,    success and funding

Interesting read, thanks! I?m new to fossil, but personally I have fallen in love with it over the past month or so I?ve been using it. My reaction to git after several years of dabbling with it here or there has been 180 degrees opposite?not love git is a menace On May 18, 2016, at 11:04

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

thanks for letting us know about that, thoroughly enjoyed listening?. On May 14, 2016, at 2:17 PM, Simon Slavin wrote: > Those interested in SQLite might like to listen to > > > > Play on the page or download as an MP3. > > Unusual information on Dr Hipp's early

[sqlite] 2 different SQLite versions inside the same process space

they are each using their own private global. Do I understand it correctly now? On May 11, 2016, at 8:36 AM, Richard Hipp wrote: > On 5/11/16, Steve Schow wrote: >> >> Typically concurrency happens when two different users execute their program >> that has sq

[sqlite] 2 different SQLite versions inside the same process space

On May 11, 2016, at 8:22 AM, Steve Schow wrote: > > Oh that actually makes more sense?but also even more concerning in a way, > unless I?m still misunderstanding the conundrum. Just thinking out loud?.is this problem related to specifically when people try to compile sqlite into

[sqlite] 2 different SQLite versions inside the same process space

On May 10, 2016, at 4:15 PM, Richard Hipp wrote: > On Tue, 10 May 2016 22:47 +0100, Tim Streater wrote: >> >> I read it as two different *copies*. It doesn't sound to me as if the >> versions have anything to do with it. >> > > Correct. Two different *copies*of the library. They can both h

[sqlite] 2 different SQLite versions inside the same process space

I would like to understand this issue a little bit better? On May 10, 2016, at 2:31 PM, Richard Hipp wrote: > > In unix, SQLite has to use global variables to work around the > well-known design bugs in posix advisory locks. And so if you have > two different instances of SQLite running on un