I see I can query() using like which is case-insensitive however I can't see a way to perform a case-insensitive sort.
Is it possible to use our own custom query filter function. Something like filter(key, operator, compare) where operator would be a function we'd provide and you'd pass it key and compare. In nanoSQL you can add query functions.
Finally what is the best way to iterate all nodes in a path, one at a time which is performant and doesn't uses lots of memory (doesn't cache). ex. Like db.query('songs') to get every node, one at a time.
I see I can
query()using like which is case-insensitive however I can't see a way to perform a case-insensitive sort.Is it possible to use our own custom query filter function. Something like
filter(key, operator, compare)whereoperatorwould be a function we'd provide and you'd pass itkeyandcompare. In nanoSQL you can add query functions.Finally what is the best way to iterate all nodes in a path, one at a time which is performant and doesn't uses lots of memory (doesn't cache). ex. Like
db.query('songs')to get every node, one at a time.