Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
jitl
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
24 ms
·
451.
▲
by
jitl
1y ago
place I work - Notion - does
452.
▲
by
jitl
1y ago
How do you monetize cutting edge ai tech? Sell it. Who has money? Businesses.
453.
▲
by
jitl
1y ago
Wow, Minecraft X Outer Wilds… I should really finish Outer Wilds. It’s incredible and super fun to explore the solar system but I find many of the challenges quite difficult to navigate with the zero g thrusters.
454.
▲
by
jitl
1y ago
This is mentioned in the article.
455.
▲
by
jitl
1y ago
Yeah my architecture problem is that Postgres RDS EBS storage is slow as dog. Sure our data won’t go poof if we lose an instance but it’s so slow. (It’s not really my architecture problem. My architecture problem is that we store pages as g
456.
▲
by
jitl
1y ago
macOS is a popular OS that has a fast and loose relationship to that syscall without F_FULLFSYNC
457.
▲
by
jitl
1y ago
Depending on your data model, LiveStore is a completely open-source, SQLite based approach for local first sync-y apps: https://livestore.dev/ It's oriented around event sourcing and syncs the events, which get materia
458.
▲
by
jitl
1y ago
We do see about 10x the database row corruption rate w/ WASM OPFS SQLite compared to the same logic running against native SQLite. For read-side cache use-case this is recoverable and relatively benign but we're not moving write-s
459.
▲
by
jitl
1y ago
Notion screenshot ;)
460.
▲
by
jitl
1y ago
On midrange and below Android devices, literally any local persisted data access can be slower than a network call. Even a point read from a small SQLite b-tree can be coming off a $3 microsd card and a CPU equivalent to a 10 year old iPhon
461.
▲
by
jitl
1y ago
I've been a bit put off by rxdb's lack of transactions (see https://rxdb.info/transactions-conflicts-revisions.html ) and the sometimes self-congratulatory tone in their docs. Notion is a very async collaborative
462.
▲
by
jitl
1y ago
Ah, I understood "native application in some targets" to mean you're writing application code in languages other than JavaScript/TypeScript; not that sometimes you're React Native and sometimes you're Web/
463.
▲
by
jitl
1y ago
IndexedDB is a standard and can be implemented however the user-agent sees fit. Chromium source tree has an implementation on LevelDB and an implementation on SQLite; I'm not sure how they pick the appropriate backend. Firefox and WebK
464.
▲
by
jitl
1y ago
But, does Replicache work for your native targets? Or you are okay with a different data layer for native (sqlite) vs web (boutique data model on top of IndexedDB). At the start of the article it sounds like the goal is to use the same abst
465.
▲
by
jitl
1y ago
I don’t think I’ve ever encountered a command line tool that makes this mistake, hooray for me. On the other hand lots more today support XDG_CONFIG_* and don’t litter ~ with random .dir stuff. I really like the new era of CLI tools that’s
466.
▲
by
jitl
1y ago
wat. a write to address in memory + a context switch is not going to beat a write to an address in memory
467.
▲
by
jitl
1y ago
In a cache context CAS is compare and swap, content addressable didn’t cross my mind
468.
▲
by
jitl
1y ago
I mean I love to see a 0.5% performance boost in my code at work. I would be all over a 5% boost, I think anything above 1% is significant!
469.
▲
by
jitl
1y ago
There may be an opportunity to switch from TRANSIENT to STATIC in sqinn but I didn't read deeply enough to follow what the current memory approach is. https://github.com/cvilsmeier/sqinn/blob/a88b3df6c89
470.
▲
by
jitl
1y ago
For a project a while back, I needed to turn many-gigabyte Postgres CSV table dumps into SQLite databases. I turned to Go as its a great language for easy parallelism combined with enough memory layout control to get relatively good perform
471.
▲
by
jitl
1y ago
The article you posted doesn't mention "offline" at all. We use SQLite as a cache in the browser when available and in iOS/Android/desktop apps, but we didn't have any guarantee that a page you want offline is
472.
▲
by
jitl
1y ago
Notion should enter "keyboard mode" as you start to type and fade out the header bar. You'll still need to close the sidebar since it's quite busy and we don't fade it automatically since it has an explicit toggle.
473.
▲
by
jitl
1y ago
use anytype instead (i work at notion)
474.
▲
by
jitl
1y ago
And yet is there a device maker with a smaller lineup than Apple’s? Samsung seems to have like a bazillion models in circulation at any given time. Large laptop makers like Lenovo or Dell have a flabbergasting lineup of very overlapping pro
475.
▲
by
jitl
1y ago
This is a core feature of Notion which is a pretty popular app (I’m biased tho I work at Notion)
476.
▲
by
jitl
1y ago
I want to build a fully round-tripable semantic HTML “microformat” for Notion data so both backup and take-out workflows can depend just on exports, but right now I’m too focused on scaling offline mode to work on it. Sigh. The first versio
477.
▲
by
jitl
1y ago
Didn’t they promise this with “Fluid Framework”? https://techcommunity.microsoft.com/blog/microsoft_365blog/i... I remember being a bit spooked when they announced this and their Notion clone Loop (I’d been at Not
478.
▲
by
jitl
1y ago
It’s great in TypeScript. In TypeScript your source can have inferred types returned, and then use a build step to produce resolved typings files (.d.ts) for distribution that have the fully specified type.
479.
▲
by
jitl
1y ago
i mean that's life with client computers, you make stuff backwards compatible and you avoid making it too brittle.
480.
▲
by
jitl
1y ago
You can use the same business logic code on both the client and server. With the Linear approach, the server remains the source of truth.
More ›