ochiba

5 ms·

1.
by ochiba 21d ago
I did the exact same thing for our “company brain”. Works great
2.
by ochiba 1y ago
PowerSync supports OPFS as SQLite VFS since earlier 2025: https://github.com/powersync-ja/powersync-js/pull/418
3.
by ochiba 1y ago
This is great to see and I like the simplicity of the approach. You can also look at PowerSync (which I work on). It's in a similar space as ElectricSQL. It syncs to SQLite on the client-side and provides built-in reactivity. On the we
4.
by ochiba 1y ago
This site also has a directory of devtools: https://lofi.so/
5.
by ochiba 1y ago
You can look at PowerSync: https://www.powersync.com/
6.
by ochiba 1y ago
Realm's sync functionality (Atlas Device Sync) has been deprecated by MongoDB: https://www.mongodb.com/docs/atlas/app-services/sync/device-...
7.
by ochiba 1y ago
I really enjoyed the talk at Local-First Conf today — well done. I thought it was very well explained and made compelling arguments for the event-sourcing materialized into SQLite architecture. Thank you for championing SQLite and especiall
8.
Escaping the Network Tarpit(powersync.com)
2 points by ochiba 1y ago|0 comments
9.
by ochiba 1y ago
I am not sure about Turso but I've seen a few different approaches to this with other sync engine architectures: 1. At a database level: Using something like RLS in Postgres 2. At a backend level: The sync engine processes write operat
10.
by ochiba 1y ago
It's definitely quite a hard engineering problem to solve, if you try to cover a wide range of use cases, and layer on top of that things like permissions/authorization and scalability
11.
by ochiba 1y ago
There are niche use cases where the former (work for days to weeks offline) are useful and even critical - like certain field service use cases. Surviving glitches in network connectivity is useful for mainstream/consumer applications
12.
by ochiba 1y ago
Yes, exactly. https://www.gabrielgambetta.com/client-side-prediction-serve...
13.
by ochiba 1y ago
I would say this is why server-authoritative systems that allow for custom logic in the backend for conflict resolution work well in practice (like Replicache, PowerSync and Zero - custom mutators coming in beta for the latter). Predefined
14.
by ochiba 1y ago
Useful directory of tools here: https://localfirstweb.dev/
15.
by ochiba 1y ago
> Yes, they are fascinating and yes they solve real problems but they are absolute overkill to your problems (except collab editing), at least currently. Why? Because they are all about conflict resolution. You can get very far without a
16.
by ochiba 1y ago
> And 'synchronisation' as a practice gets very little attention or discussion. People just start with naive approaches like 'download whats marked as changed' and then get stuck in the quagmire of known problems and
17.
by ochiba 1y ago
I think that is where sync engines come in that allow doing arbitrary hybrid queries (across local and remote data) and then keeping the results of those hybrid queries in sync on the client. This is one of the ideas that appears to be cent
18.
by ochiba 2y ago
We are working on this: https://www.powersync.com/ We started with Postgres and added support for MongoDB after they deprecated Atlas Device Sync in September last year.
19.
by ochiba 2y ago
Not sure if you've looked at PowerSync yet: https://www.powersync.com/ (I'm on the team) For the read path it hooks into Postgres logical replication or MongoDB change streams (and MySQL binlog soon). It supports
20.
by ochiba 2y ago
Yes, using IndexedDB is common, and increasingly also running SQLite in the browser using Wasm, with its data persisted through a VFS that uses IndexedDB or OPFS. https://www.powersync.com/blog/sqlite-persistence-on-the
21.
by ochiba 2y ago
Local-first generally refers to apps that work with a local client database which syncs with a server database in the background. Reads and writes go to the local database first. This results in very low latency and not being dependent on t
22.
by ochiba 2y ago
There is a fairly comprehensive list of frameworks/tools here: https://localfirstweb.dev/ I work on PowerSync and we did a Show HN last year: https://news.ycombinator.com/item?id=38473743 Also see Inst
23.
by ochiba 2y ago
This made the rounds on HN recently: https://tonsky.me/blog/crdt-filesync/ A PoC of using Dropbox for a local-first app
24.
by ochiba 2y ago
> Now, that functionality with their rewrite is somewhat removed, as they expect you to handle clientside writes by yourself, which is what I believe PowerSync does as well, am I correct in that understanding? Yes, that is correct. >
25.
by ochiba 2y ago
Makes sense. FWIW, there are some more details here: https://replicache.notion.site/Introducing-Zero-8ce1b1f184aa...
26.
by ochiba 2y ago
Thanks, appreciate the feedback.
27.
by ochiba 2y ago
Sounds conceptually similar to Zero: https://zerosync.dev/ I haven't looked in detail yet — what are the main differences relative to Zero?
28.
by ochiba 2y ago
Co-founder of PowerSync here. Would love to hear what you would like to see improved in PowerSync :) Thanks!
29.
by ochiba 2y ago
I work on PowerSync which may be worth looking at too, for Postgres-SQLite sync https://www.powersync.com/
30.
by ochiba 2y ago
I work on PowerSync which does Postgres-SQLite sync, FWIW: https://www.powersync.com/

More ›