-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 07/07/13 16:19, Simon Slavin wrote:
> <http://unqlite.org>

What has generally become important to me is being able to supply
arbitrary JSON as a "record", be able to query it, and get the same
arbitrary JSON back out.

In addition to unqlite, some of the other "nosql" databases have the same
approach (eg MongoDB).  Even postgres is adding JSON storage via hstore.

What hasn't standardised is how you query which means you can't easily
change engines or write (mostly) portable code like you can with SQL.

MongoDB uses JSON shaped structures with $prefixed operators.  unqlite is
using a custom Jx9 interpreted language.  And postgres uses minor
extensions to SQL.  There was unql which DRH was involved in two years
ago, but appears unadopted.

My favourite is the MongoDB approach since the queries and data are
substantially similar - it is very similar to Query By Example.

Roger

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iEYEARECAAYFAlHaGJwACgkQmOOfHg372QTXaQCgkiy49SE5bHyvRr8gn+Oecgve
kSMAoLcq1ZXRg4Z5KXdU3HsfT9CkyqhE
=J/3c
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to