Re: [sqlite] Docs: ON CONFLICT clause versus CHECK constraints

2014-08-14 Thread Richard Hipp
On Thu, Aug 14, 2014 at 6:06 PM, Zsbán Ambrus wrote: > Hi, I'd like to report a small confusion in the documentation. > > The documentation page for the ON CONFLICT clause at > "http://sqlite.org/draft/lang_conflict.html; describes at the > beginning what kind of constraints

[sqlite] Docs: ON CONFLICT clause versus CHECK constraints

2014-08-14 Thread Zsbán Ambrus
Hi, I'd like to report a small confusion in the documentation. The documentation page for the ON CONFLICT clause at "http://sqlite.org/draft/lang_conflict.html; describes at the beginning what kind of constraints this clause deals with: > The ON CONFLICT clause applies to UNIQUE and NOT NULL

Re: [sqlite] MS open source Portable Class Library for SQLite

2014-08-14 Thread Eric Sink
I would describe the msopentech PCL wrapper as "slightly thick" (because it's trying to be higher level than the sqlite3 API itself), and "quite narrow" (because it covers only a small part of the underlying sqlite3 API). Related and possibly of interest: My own C# wrapper is a fork of the one

Re: [sqlite] MS open source Portable Class Library for SQLite

2014-08-14 Thread Simon Slavin
On 14 Aug 2014, at 9:14pm, a...@zator.com wrote: > May be that some know it already, but digging the Web to know about the > client-side storage Web SQL Database, I've found this post of MS Open > Technologies, that may be of interest to many of you who often ask about > SQLite in Window

[sqlite] MS open source Portable Class Library for SQLite

2014-08-14 Thread ajm
May be that some know it already, but digging the Web to know about the client-side storage Web SQL Database, I've found this post of MS Open Technologies, that may be of interest to many of you who often ask about SQLite in Window Phone.

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-08-14 Thread Andy Ling
That looks like a makefile generated by the vxWorks eclipse based workbench IDE tool. The bit that would be based on "user input" is that list of OPTs (the source files would be read automatically by adding to the project). I use a custom build, so don't use these automatically generated files.

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-08-14 Thread Jan Nijtmans
2014-08-13 14:31 GMT+02:00 Andy Ling : > > From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of > Richard Hipp > > OK, I did find some cases where unlink() is called on files that do not > exist. > > > Anyway, a patch has now been checked in. > > Great,