Re: [sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

2013-06-15 Thread Stefan Keller
Hi Régis I'd wish to give you a solution but I'm sorry to have new news about that issue. I'd be happy if there are any SQlite devs around to give you a solution in order to make this database more usable (an more SQL compatible). Yours, Stefan 2013/6/11 regish : > Hi all, > I'm starting to us

Re: [sqlite] Multiprocess accessing SQLite connection

2013-06-15 Thread Richard Hipp
On Fri, Jun 14, 2013 at 9:42 AM, wrote: > On Fri, 14 Jun 2013, Richard Hipp might have said: > > > I've read of multiple processes opening the same database. How far > can this go? Is it allowed to have one writer and many readers or can > each process be writer and reader? I am thinking of hav

Re: [sqlite] Porting Sqlite to MQX Operating system

2013-06-15 Thread JCharavda
Geoff, Did you manage to get sqlite working with MQX? -- Jay -- View this message in context: http://sqlite.1065341.n5.nabble.com/Porting-Sqlite-to-MQX-Operating-system-tp16685p69428.html Sent from the SQLite mailing list archive at Nabble.com. ___ s

Re: [sqlite] Feature request: add support for COMMENT statement

2013-06-15 Thread Alexey Pechnikov
Hello! > Suppose you have it. What would you do with it? > What's the use case? > --> Igor Tandetnik The COMMENTs can be used to store any information for interchanging with application and external systems. As example, ORM (object relational mappers) may need some additional metainfo for all m

Re: [sqlite] Multiprocess accessing SQLite connection

2013-06-15 Thread mikeegg1
On Fri, 14 Jun 2013, Richard Hipp might have said: > On Fri, Jun 14, 2013 at 9:10 AM, Vijay Khurdiya < > vijay.khurd...@securetogether.com> wrote: > > > Please confirm below statement is TRUE when Sqlit3 configure in thread > > safe mode. (I am checking for Serialized) > > > > "Multiple processes

Re: [sqlite] Bug in Apress SQLite book. Was: Different result set of query in examples of SQLite book

2013-06-15 Thread Mike Owens
It seems to me that this should be invalid as COUNT(id) does not refer to a valid field in the subquery's column list. I would vote for throwing an error as it seems that wrong. Since its been over six years since I wrote that query, I don't know what I was thinking at the time. Sent from my iPhon