Using Conditions on Upserts in Typesense
TLDR Jacob inquired about using conditions on upsert commands in Typesense. Kishore Nallan guided Jacob to a relevant open feature request on GitHub to upvote.
Sep 21, 2022 (15 months ago)
Jacob
05:46 AMlowest_price property, but only if the new price is lower than already stored price. There might be many parallell incoming price-updates, so reading the value and then doing the update will not work as it will create a race condition.
Kishore Nallan
05:48 AMWe've a feature request open for this, but it's not implemented yet.: https://github.com/typesense/typesense/issues/496
Can you please upvote that issue? It's certainly a useful feature, so we will prioritize this in the near future.
Jacob
06:02 AM
Typesense
Indexed 3011 threads (79% resolved)
Similar Threads
Conditional Upsert for Typesense
Imtiaz inquires about carrying out conditional upsert for Typesense but Kishore Nallan suggests it's currently not supported. Instead, they advise creating a feature request on Github.
Handling Kinesis Stream Event Batching with Typesense
Dui had questions about how to handle Kinesis stream events with Typesense. Kishore Nallan suggested using upsert mode for creation/update and differentiating with logical deletion. After various discussions including identifying and resolving a bug, they finalized to introduce an `emplace` action in Typesense v0.23.
Issues with Version "0.23.0.rc69" and Upsert Request in Typesense
Bill raised a concern about inconsistent performance of version "0.23.0.rc69" and upsert issues in Typesense. Jason advised upgrading to version "0.23" and switching to "emplace" instead of "upsert". Kishore Nallan provided additional clarification.