query with limit(5) returns more than 5 elements

[ditiem]

Hello,

I am testing how nanoSQL behaves and I found something that it is not what I am expecting, so I wanted to ask if I am wrong or there is a bug. I have done a codepen:

https://codepen.io/anon/pen/bKEqbM?editors=0010#anon-login

My idea was to check whether an observable was invoked when an inserted element affect the result query (in this case the "second page"):

nSQL().observable( ( ) =>
nSQL("users").query('select').limit( 5 ).offset( 5 ).emit() )
.subscribe( update ) ;

And then I run some simple code that inserts elements in the database.

So I run into these 2 issues:
1- The observable is called every time the database is modified. I can live with it, but then I see no much difference between nSQL().on("change") and .observable.
2- The number of rows (8) is bigger than the limit set (5)

Thank you!

[only-cliches]

Ah the cache haunts me again!

This was being caused by the query cache not clearing itself properly. I've disabled the query cache outright for now, live as of 1.6.4.

That should fix your problem. 😄

[only-cliches]

Oh, forgot about your other question...

The observable actually uses .on("change") internally, but there are way more options for debouncing and filtering the output, all the options available:

nSQL().observable( ( ) =>
    nSQL("users").query('select').limit( 5 ).offset( 5 ).emit() 
)
.debounce(1000) // dont trigger more than every second
.distinct() // only trigger if the previous record doesn't match the next record to trigger
.filter(rows => rows.length > 10) // use a filter function to only emit changes based on provided fn.
.map(rows => rows) // mutate the result
.first() // only emit the first change
.skip(10) // skip the first n elements
.take(10) // only get the first n elements
.subscribe( update ) ;

Obviously each function is optional.

[only-cliches]

Closing this issue since there's been no activity for a few days, feel free to open it back up if you have more questions.