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.
I've played with building a JSON extension for SQLite3 using jq's excellent JSON C library. The biggest "problem" with that work is that the extension has to serialize values to JSON (and, of course, parse) in many cases where it could be avoided with some help from SQLite3. 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. (jq has an XPath-like language, but for JSON.) Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
