Comment by kreetx
Funny, as Triplit front page shows a query much like SQL:
const deliveredMessagesQuery = client
.query("messages")
.Where("conversationId", "=", convoId)
.Order("created_at", "DESC")Funny, as Triplit front page shows a query much like SQL:
const deliveredMessagesQuery = client
.query("messages")
.Where("conversationId", "=", convoId)
.Order("created_at", "DESC")SQL is a relational algebra language which, unlike imperative languages, is compiled into an execution plan depending on the existence of indexes, table sizes, data types, etc. The reason you should love it is that you don't need to know the details when the data model is set up well. And DBMSs also have commands to view the execution plan, should it have otherwise been slow, such that you know what to do to improve it. It's really not that complicated once you learn how it works.
Well yeah choosing what to query, a filter and an order is at the heart of all query-like things. Buy SQL specifically is a text language not a fluent api.