Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
conradev
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
18 ms
·
391.
▲
by
conradev
1y ago
2005 world series (chicago) https://x.com/michaelschwab13/status/1920656687045685562
392.
▲
by
conradev
1y ago
My favorite FoundationDB layer is per-user SQLite databases: https://github.com/losfair/mvsqlite It's hard to tell if it's running in production, but the author works at Deno!
393.
▲
by
conradev
1y ago
I was referring to both the lower memory bandwidth and lower FLOPs. The GPU can just do… more at once? For now. Or is that changing? I had also assumed that loading a chunk from the cache was not free because I’ve seen cache eviction on my
394.
▲
by
conradev
1y ago
Oh, yes, I misread! It’s great for that
395.
▲
by
conradev
1y ago
It essentially never makes sense to run on the CPU and you will only ever see enthusiasts doing it. Yes, hammering the GPU too hard can affect the display server, but no, switching to the CPU is not a good alternative
396.
▲
by
conradev
1y ago
My understanding is that model throughput is fundamentally limited at some point by the fact that the ANE is less wide than the GPU. At that point, the ANE loses because you have to split the model into chunks and only one fits at a time.
397.
▲
by
conradev
1y ago
Yeah, that’s a bummer. It does appear to be in nixpkgs, though: nix-shell -p sqlite-rsync
398.
▲
by
conradev
1y ago
SQLite has an official tool for this, fwiw: https://www.sqlite.org/rsync.html It works at the page level: > The protocol is for the replica to send a cryptographic hash of each of its pages over to the origin side, then
399.
▲
by
conradev
1y ago
SQLite tosses out the SQL once it is parsed into bytecode. Using text is just going to take longer, even though I’m sure it works great. You can modify the database before vacuuming by making a new in-memory database, copying selected table
400.
▲
by
conradev
1y ago
I'd recommend folks watch the video – it's fascinating. The truck gets OTA updates through your phone and not some LTE modem. It doesn't have one. They moved all car management including OBD-like functionality to the phone,
401.
▲
by
conradev
1y ago
> Why require the client to be locked down? It is hard and likely expensive to require every single reader in every single city to be networked: > Because Clipper operates in multiple geographical areas with sporadic or non-existent i
402.
▲
by
conradev
1y ago
Attesting that a closed source device meets arbitrary closed source standards is a necessary evil. One real world problem is that some existing systems are built relying on the integrity of the components within, i.e. BART in the bay area r
403.
▲
by
conradev
1y ago
I used to have that as a shirt, but I think I lost it: https://philkast.com/2013/10/30/spying-tshirt.html
404.
▲
by
conradev
2y ago
I got it to work with a shortcut: https://www.icloud.com/shortcuts/d4793e08d64d4ff1b7ea725b944...
405.
▲
by
conradev
2y ago
Many of those also run their own gTLDs, too: .apple, .google, etc
406.
▲
by
conradev
2y ago
Better security! A malicious actor only needs to change a few bytes in either the source or binary of OpenSSL to break it entirely (i.e. disable certificate checking). Reproducible builds remove a single point of failure for authenticating
407.
▲
by
conradev
2y ago
Doesn’t even have to involve project managers. Just someone who isn’t an enthusiast and/or doesn’t care at the helm.
408.
▲
by
conradev
2y ago
Are the protocols compatible enough such that someone could proxy JMAP to CalDAV?
409.
▲
by
conradev
2y ago
Totally. The march continues with userspace drivers and exclaves[1]. I think it's fair to say that security is a big driver for their kernel evolution. [1] https://www.theregister.com/2025/03/08/kernel_sa
410.
▲
by
conradev
2y ago
The routing decision that an MoE model makes increases its chances of success by constraining its future paths.
411.
▲
by
conradev
2y ago
SQLite has an experimental change, "BEGIN CONCURRENT", which uses optimistic locking to allow concurrent non-overlapping writes: https://www.sqlite.org/src/doc/begin-concurrent/doc/begin_co...
412.
▲
by
conradev
2y ago
That makes total sense! Beyond the efficiency of no servers, the other aspect of CBS that is appealing to me is its simplicity. Graft introduces a lot of new concepts, and while they might be necessary to achieve the more ambitious goals, i
413.
▲
by
conradev
2y ago
> After a client pulls a graft, it knows exactly what’s changed. It can use that information to determine precisely which pages are still valid and which pages need to be fetched Curious how this compares to Cloud-Backed SQLite’s manifes
414.
▲
by
conradev
2y ago
No, it should be there. From the link: > Lastly, in the final blog post we’ll explore the iPhone’s host isolation mechanisms, research the ways in which the Wi-Fi chip interacts with the host, and develop a fully-fledged exploit allowing
415.
▲
by
conradev
2y ago
The Secure Enclave is nowhere between the AP and the Broadcom chip. The application processor has an IOMMU and the kernel uses it to restrict what the Broadcom chip has access to, and the linked article series discusses exploiting the IOMMU
416.
▲
by
conradev
2y ago
A total stranger can send radio waves at you and your phone will process them on a processor close to the kernel: https://googleprojectzero.blogspot.com/2017/09/over-air-vol-...
417.
▲
by
conradev
2y ago
Yes! I have a pair of "on-ear speakers" and they support the broadcast API: https://nwm.global/products/one but I have not found a single place in the US that uses it
418.
▲
by
conradev
2y ago
Labels in public health are absolutely problematic for exactly that reason. But I will also say that ADHD, if you have it, is an essential part of your identity regardless of your awareness of the label.
419.
▲
by
conradev
2y ago
The maintainer would just change the sandboxing constraints to weaken the software. Just like they did in the first place. You can try to make obfuscation difficult, but it’s always possible.
420.
▲
by
conradev
2y ago
Bluetooth devices can already read Messages from your iPhone with no degradation to E2EE: https://developer.apple.com/library/archive/documentation/Co... This is just about sending.
More ›