Readit News logoReadit News
matlin commented on Offline-First with CouchDB and PouchDB in 2025   neighbourhood.ie/blog/202... · Posted by u/felideon
justanotheratom · 4 months ago
triplit sounds awesome. Any precedence of someone using it from a native iOS app?
matlin · 4 months ago
With React Native yes but not yet with Swift. There's been quite a few requests to my surprise through--I figured CloudKit, etc would be sufficient on iOS but I don't have experience there.
matlin commented on Offline-First with CouchDB and PouchDB in 2025   neighbourhood.ie/blog/202... · Posted by u/felideon
elcritch · 4 months ago
Nice, I’ll have to try out Triplit. There’s also Couchbase which has a local sync database in C++ IIRC.

Also, heads up the first triplit link I tried gave me a 404: https://www.triplit.dev/docs/client/query/select#selecting-r...

matlin · 4 months ago
Great catch, fixed!
matlin commented on Offline-First with CouchDB and PouchDB in 2025   neighbourhood.ie/blog/202... · Posted by u/felideon
matlin · 4 months ago
PouchDB and CouchDB were what inspired me to build Triplit[1]. The idea of having an identical (or merely similar in the case of Pouch/Couch) query engine accessible on client and server is insanely powerful.

The author links to a much longer post on handling conflicts which is worthy of its length because it's not a pleasant experience with this setup.

I highly recommend trying a modern setup from one of the many new local first solutions [2]

1. https://triplit.dev

2. https://www.localfirst.fm/landscape

matlin commented on Stop syncing everything   sqlsync.dev/posts/stop-sy... · Posted by u/neilk
matlin · 5 months ago
My ideal version of this is simple: just define the queries you want (no matter how complex) and the you'll get exactly the data you need to fulfill those queries, no more, no less. And the cherry on top would be to have your queries update automatically with changes both locally and remote in close to real-time.

That's basically what we're doing with Triplit (https://triplit.dev), be it, not with SQL--which is a plus for most developers.

matlin commented on Electric (Postgres sync engine) beta release   electric-sql.com/blog/202... · Posted by u/austinbirch
vinner_roy · 9 months ago
Eagerly awaiting the React Native compatible version. https://zerosync.dev/ is the main alternative I'm considering.
matlin · 9 months ago
You should check out Triplit as well, we have React Native support[0] and the best Typescript integration by far

0. https://www.triplit.dev/docs/frameworks/react-native

matlin commented on Streaming joins are hard   estuary.dev/streaming-joi... · Posted by u/danthelion
crazygringo · 10 months ago
Can someone explain what the use case is for streaming joins in the first place?

I've written my fair share of joins in SQL. They're indispensable.

But I've never come across a situation where I needed to join data from two streams in real time as they're both coming in. I'm not sure I even understand what that's supposed to mean conceptually.

It's easy enough to dump streams into a database and query the database but clearly this isn't about that.

So what's the use case for joins on raw stream data?

matlin · 10 months ago
We apply incremental, streamable "joins" (relational queries) for real-time syncing between application client and server. I think much of the initial research in this space was around data pipelines but the killer app (no pun intended) is actually in app development

u/matlin

KarmaCake day558February 14, 2017
About
Making Triplit - the fullstack database (https://triplit.dev)
View Original