It could be useful to support easy authoring of XSLT transformations on JSON documents. The main stumbling block today is knowing the internal structure of the XML that represents the JSON.

Transforming from one JSON form to another doesn't feel like an exceptionally common use case. While a user could do this, making this aspect easy seems lower on my list. Transforming to a totally different format (HTML, XML) feels more valuable.

Open to opinions.

When searching sometimes we want to return only urls of things and not the contents. This would save cycles on the database by just doing a lexicon call.

Should provide a property= paramater.

In simply kv queries it is sometimes necessary to ass exclude clases:

e.g.

  find id:123
  but exclude id:345

Would be nice to be able to use xslt on update and insert

on function escapeNCName function underbar "_" should not be escaped as it is a valid JSON name character.

Specifying an extractPath the returns multiple nodes and applying a transform causes a 500 because transforms can only accept a single node, not a sequence.

Not being able to specify anything but kv/qs is somethimes not sufficient.

The current update functionality serves few purposes that are not in insert.

It was agreed it would be nicer to support something like:

  function updateUser(ghUser) {
    console.log("Trying to update github user " + ghUser.login);
    db.json.update_first(
       { github_login: ghUser.login })
         .increment('version', 1)
         .replace('github_login', ghUser.login)
         .replace('github', ghUser)
         .delete('linkedin.deletemeplease')
         .rename('meeutp','meetup')
         .push('anarray', 1)
         .addCollection('github') // also replaceCollection
         .setQuality(9)
         .replacePermissions(['a','b','c']) // also addPermissions
         .save(
           function saveCb(e) {
             if(e) {
               console.log("Couldn't update " + ghUser.login);
               return;
             }
             console.log(ghUser.login + " updated");
             return;
         });
  };