[GH-ISSUE #26] Query questions #24

New issue

Closed

opened 2026-05-23 08:26:25 -06:00 by gitea-mirror · 0 comments

gitea-mirror commented

2026-05-23 08:26:25 -06:00

Owner

Originally created by @clibu on GitHub (Mar 24, 2021).
Original GitHub issue: https://github.com/appy-one/acebase/issues/26

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.

Originally created by @clibu on GitHub (Mar 24, 2021). Original GitHub issue: https://github.com/appy-one/acebase/issues/26 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](https://nanosql.io/query/query-function-api.html#simple-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.