On 8 Sep 2014, at 11:45pm, Nico Williams <n...@cryptonector.com> wrote:
> It'd also be good to have JSON and XML support, possibly as an > loadable extension. That way XPath and similar expressions matching > document snippets in SQL string values could be used in SQL queries. Not so sure about that. There are JSON and XML extensions available for pretty-much every language out there. Do you feel they need to be tightly integrated with SQLite somehow ? > It'd be *very* convenient if SQLite3 had a value type that corresponds > to loadable extensions' private types, and a protocol for releasing > and serializing values of such types. Ah, but there you struck gold. If this is to be adopted, SQLite needs a DataType of FILE. Complete with functions to do things like get a file's name, path, length, contents, and probably half a dozen other things that don't come to mind right now. In fact this might be useful for SQLite even if it isn't going to be used as an OpenDoc file container. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users