[sqlite] JSON expressions for records and synchoronisation

2015-04-13 Thread James K. Lowden
On Fri, 10 Apr 2015 14:15:43 -0700 Roger Binns wrote: > On 04/10/2015 01:51 PM, Simon Slavin wrote: > > With a cursory glance I do see important incompatibilities with > > SQLite. > > I use JSON as the data format for $work stuff (startups) for years, > and these JSON schemas etc miss why some

[sqlite] JSON expressions for records and synchoronisation

2015-04-13 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/13/2015 03:15 PM, James K. Lowden wrote: > I beg to differ, Roger. Note that I deliberately said "some" and not "all". Everyone has their reasons, and not everyone has the same reason. > The programming language of choice doesn't affect the

[sqlite] JSON expressions for records and synchoronisation

2015-04-10 Thread Simon Slavin
A web site of no official standing features two JSON formats which might interest readers of this list. The first is for describing a table of data: It does something close to what a CREATE TABLE statement does: define fields, their types, and

[sqlite] JSON expressions for records and synchoronisation

2015-04-10 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/10/2015 01:51 PM, Simon Slavin wrote: > With a cursory glance I do see important incompatibilities with > SQLite. I use JSON as the data format for $work stuff (startups) for years, and these JSON schemas etc miss why some of us use JSON. If