tantaman

10 ms·

61.
by tantaman 4y ago
Solaris starring George Clooney
62.
by tantaman 4y ago
I was mock interviewing ChatGPT for a few hours yesterday with application and system design + coding said application. My conclusion was it was a no hire for even the most jr positions because it required considerable amounts of direction
63.
by tantaman 4y ago
Beautiful. I've been noodling on exactly this same idea. So far I've explored using SQLite but it would be ideal if there was no SQL between me and my relations. Another direction I've taken is adding STM to JavaScript and im
64.
by tantaman 4y ago
It'd depend on the network topology and rate of syncing. For a simple case of two nodes, they'll be divergent until each node sends the other their current state. For client-server, the "whole system" wouldn't be in
65.
by tantaman 4y ago
Yep! That was one plan for deploying cr-sqlite to "the cloud." D1, unfortunately, doesn't support loading extensions into SQLite. fly.io, and their sqlite solution, does however! I've been using fly.io to run cr-sqlite i
66.
by tantaman 4y ago
:( I'll try to get to that.
67.
by tantaman 4y ago
In a client-server sync setup you can drop a client's deletes (for certain crdts like observed-remove sets) once they send their changes to the server. The server, of course, needs to retain them. Other GC research unrelated to this pr
68.
A Gentle Introduction to CRDTs(vlcn.io)
278 points by tantaman 4y ago|39 comments
69.
Conflict Free Fractional Indexing in SQLite(youtube.com)
2 points by tantaman 4y ago|0 comments
70.
by tantaman 4y ago
SQLite WASM uses SharedArrayBuffers and Atomics to turn async OPFS apis into blocking APIs (really just _one_ api -- getSyncAccessHandle) Given the use of SharedArrayBuffers and that SharedArrayBuffers can't be used in a shared worker
71.
by tantaman 4y ago
What's wrong with many tabs? The DB handles getting hit by many tabs correctly -- it's just as if many processes were hitting the db in a non-browser environment. Example of syncing your app across tabs with SQLite here: https:&#
72.
by tantaman 4y ago
If it helps, I detail some of the pros/cons of using the official SQLite build vs unofficial builds (wa-sqlite, which is similar to absured-sql) here: https://vlcn.io/docs/guide-persistence#persistence-options
73.
by tantaman 4y ago
> Application can tolerate stale data... Projects like https://readyset.io/ , https://materialize.com/ , https://github.com/mit-pdos/noria can keep your materialized views up to date
74.
by tantaman 4y ago
This is an incredibly common thing. The worst I've seen it is when people drop their SQL DB for a No-SQL thing (for no good reason) and then end up implementing all the joins they lost in the application :(
75.
Outlandish Recursive Query Examples(sqlite.org)
1 points by tantaman 4y ago|1 comments
76.
by tantaman 4y ago
lmk if you need any help getting things set up.
77.
by tantaman 4y ago
I know that DiamondTypes does write to disk and acts much like a db itself. I was thinking it could be possible to expose that library as a virtual table in SQLite.
78.
by tantaman 4y ago
np. Gives me a good reason to finish up those usage docs and example apps :)
79.
by tantaman 4y ago
yeah, not yet. yjs and automerge have rust ports so _maybe_ (big maybe) sequence crdts can be added by creating a virtual table interface to those projects. TBD.
80.
by tantaman 4y ago
There's different strategies for solving conflicts but CRDTs wouldn't be a good fit where you need a total ordering of all transactions -- such as bank deposits.
81.
by tantaman 4y ago
I'd originally done a sidecar route but ultimately went the extension route for portability.
82.
by tantaman 4y ago
There's libsql, a fork of SQLite, that intends to be an "open contribution" version of SQLite.
83.
by tantaman 4y ago
Project author here (although not OP) I like the idea of moving the syntax to inserts and had not seen https://www.sqlite.org/fts5.html#special_insert_commands Will give it a shot & thanks for the resources. > I pers
84.
by tantaman 4y ago
related -- an Ent inspired ORM in TypeScript: https://aphrodite.sh/ , although with a focus on local software.
85.
by tantaman 4y ago
> What I really want to see next is an eventually consistent sync system between browser and server Another CRDT + SQLite project as a native extension: https://github.com/aphrodite-sh/cr-sqlite Should have a releas
86.
by tantaman 4y ago
sqlite is lightweight, cheap, easy and faster than fopen :) https://www.sqlite.org/fasterthanfs.html
87.
Show HN: Transactional memory in JavaScript(github.com)
2 points by tantaman 4y ago|0 comments
88.
by tantaman 4y ago
Hits the nail on the head. Client side frameworks are still missing it, however, when it comes to: 1. Supporting persistent client side state 2. Syncing local state to the server and back 3. Variation of (2) but collaborative state Aside --
89.
by tantaman 4y ago
although looking at the latest google results today, it seems like none of the top results agree on anything that is going on anymore. Hopefully I can track down my original source.
90.
by tantaman 4y ago
I think it's that Russia is pegging the Ruble to a fixed value of gold and requiring all nations importing from Russia to use Rubles to buy their Russian exports. The only way to get Rubles to buy your imports is to give Russia gold at

More ›