use case
Let's say I have a list of users and I want to search after the username. Currently I am either forced to have the entire list filtered on the client or I have a procedure that iterates over the entire user list and does manual filtering.
It would be nice to have an out of the box operator for this common task.
changes
I would hope for the operator to be available in reducers / procedures, the query builder and SQL queries
benefit
this would make a common use case easier, lead to better performance and it helps Spacetimedb become more compatible with the complete sql syntax
Requested by @ClemensWon via the SpacetimeDB site.
use case
Let's say I have a list of users and I want to search after the username. Currently I am either forced to have the entire list filtered on the client or I have a procedure that iterates over the entire user list and does manual filtering.
It would be nice to have an out of the box operator for this common task.
changes
I would hope for the operator to be available in reducers / procedures, the query builder and SQL queries
benefit
this would make a common use case easier, lead to better performance and it helps Spacetimedb become more compatible with the complete sql syntax
Requested by @ClemensWon via the SpacetimeDB site.