Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
setr
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
9 ms
·
61.
▲
by
setr
6mo ago
more specifically, the bug is due to a buffer overflow during paused chat, and presumably deviant undefined behavior between the original execution and the replayed execution. and most importantly, it has nothing to do with the non-determin
62.
▲
by
setr
6mo ago
In that case, animation belongs to the same category as audio — it exists outside the simulation state. But I’m not 100% that’s even true; in the context of replay, I imagine it’d be more appropriately part of the sim for it to scrub prope
63.
▲
by
setr
6mo ago
the notion of using time directly in gamedev has always confused me; it feels like the correct answer should be to simply have a notion of turns, and a real-time game simply iterates over turns automatically. And then so many turns are exec
64.
▲
by
setr
6mo ago
if its deterministic lockstep, then all you need to do is record inputs and replay the inputs, since the engine itself is guaranteed to behave the same. If it's client/server and non-deterministic, then you need to record the enti
65.
▲
by
setr
6mo ago
That’s the compression, same story in factorio. Before/after compression it’s static, so you can avoid having to update any value. The main difference from factorio belts I think is actually in the insertion — if there’s no room in th
66.
▲
by
setr
6mo ago
By making the roads single-direction and roads owning the movement, I think it’s been made equivalent to a conveyer belt… which means factorio’s conveyor belt optimizations might be relevant. Eg storing the delta between items rather than t
67.
▲
by
setr
6mo ago
> further disincentives to having more than 2 kids. I feel like it’d push for the return of station wagons over SUVs/Minivans, over fewer kids outright > further inceitive for rich people to buy bigger cars, as they will be bigge
68.
▲
by
setr
7mo ago
I don’t know if it anyone was really making bets around it… it’s just kind of individually meaningless to implement support for until it’s already popular, because you still have to support IPv4 in full until the day you can remove it entir
69.
▲
by
setr
8mo ago
Per the article, it’s new to browsers, not compression generally, due to the lack of standardization. the future is already here, just not evenly distributed.
70.
▲
by
setr
9mo ago
Isn’t that also like having two watches? You’ll never know the time
71.
▲
by
setr
9mo ago
I mean daemon was the previous winner before agent, and that had a solid mystical-djinni element to it. Monkey would have naturally gone the way of the daemon, as software development “matures” and undergoes corporate sterilization
72.
▲
by
setr
9mo ago
If you discard the human-readability component of it, JSON is an incredibly inefficient choice of encoding. Other than its ubiquity, you should only be using JSON because it’s both human and machine readable (and being human-readable is mai
73.
▲
by
setr
10mo ago
The SQL standard defines more of an aesthetic than an actual language. Every database just extends it arbitrarily and anything beyond rudimentary queries is borderline guaranteed to be incompatible with other databases. When it comes to pro
74.
▲
by
setr
10mo ago
From-before-select has nothing to do with composition as far as I can think of? That’s to solve the auto-complete issue — put the table first so the column list can be filtered. Things like allowing repeat clauses, compute select before whe
75.
▲
by
setr
10mo ago
That page has a reasonable re-creation, with trivial usage at call-sites, of each missing feature though? The only one that looks a bit revolting is the large pipe example
76.
▲
by
setr
10mo ago
They’re used by OLAP workloads because columnar properties fits better — namely, storing data column-wise obviously makes row-wise operations more expensive, and column-wise operations cheaper; this usually corresponds to point look-ups vs
77.
▲
by
setr
10mo ago
I’m not clear on how you’re deviating from a normal columnar/OLAP database? > I found that these columnar stores could also be used to create regular relational database tables. Doesn’t every columnar store do this? Redshift, IQ, Sn
78.
▲
by
setr
10mo ago
Afterwards, you can run into a theater and yell “fire!”
79.
▲
by
setr
10mo ago
Because getting any hardware out of infra-team on premise is utterly miserable, across the board.
80.
▲
by
setr
10mo ago
I always just used it to confirm your last action on a POST —> GET sequence. Eg confirming that your save went through/rejected (the error itself embedded & persisted in the actual page). Or especially if saving doesn’t trigger
81.
▲
by
setr
10mo ago
It’s a tax. You could describe any beneficiaries of a tax in the same manner; we’re paying taxes to at least partially cover group X - homeless, scientists, military, retirees, veterans, etc. There’s no debt being paid; money is simply take
82.
▲
by
setr
10mo ago
Given that they made no apparent use of such information in practice, the unfortunate thing is that they had the idea to begin with.
83.
▲
by
setr
10mo ago
I don’t know what kind of psychopath would provide a problem with the expectation that you already know the problem by heart
84.
▲
by
setr
10mo ago
Messages uses it too on Mac; was using it to do some convoluted text search on my history
85.
▲
by
setr
11mo ago
> You do not need an ID ti fly within the USA As far as I can think of, you always need an ID to get through security, just before entering the baggage scan?
86.
▲
by
setr
11mo ago
You don’t lose the message though, so it’s infinitely less annoying
87.
▲
by
setr
1y ago
I’m not saying columnar databases don’t have indexes, I’m saying that they get to have indexes for cheap (and importantly: without maintaining a separate copy of the data being indexed), to the point that every column is indexed by definiti
88.
▲
by
setr
1y ago
Even if you guaranteed the calling code would always logically continue running the function till completion, you wouldn’t have the guarantee the code would actually resume — eg the program crashes between the two calls, network dies, etc.
89.
▲
by
setr
1y ago
Zonemap / skip indexes don’t require sorting, still provide significantly improved searching over full tablescans, and typically applied to every column by default. Sorting is even better, just at the cost of a second copy of the datas
90.
▲
by
setr
1y ago
A row-based index is a column-wise copy of the data, with mechanisms to skip forward during scanning. You maintain a separate copy of the column to support this, making indexes expensive, and thus the DBA is asked to maintain a minimal subs
More ›