setr

6 ms·

1.
by setr 7d ago
The problem is setups like in slay the spire, if we imagine there was no path selection, you can run into scenarios that are functionally unwinnable (I recall someone finding a seed in StS that was literally unwinnable, but ignoring that).
2.
by setr 7d ago
Roguelikes are the ultimate in procgen technology, and should be the basis of any design. (DF is the ultimate simulation but uses procgen as a tool to achieve it; a different vein than NMS trying to explore the procgen and its direct outcom
3.
by setr 8d ago
I’m not sure you have to squint; an mview is just a cached query. The only difference between an mview and a cache is the “incremental” part of the equation. That is, my only disagreement is the lack of gusto
4.
by setr 14d ago
TFA links to PixelPie as a GPU implementation https://www.cs.umd.edu/gvil/projects/pixelpie.shtml
5.
by setr 15d ago
Also Casey, but his much cooler/deterministic solution to grass placement, to avoid lines https://caseymuratori.com/blog_0011
6.
by setr 15d ago
Ignoring aesthetics, there’s simply significantly more detail produced by max
7.
by setr 16d ago
I feel like the baseline teaching is trivially necessary, and should simply be assumed in these kinds of assessments. Getting someone to invest themselves emotionally into a subject is both infinitely harder and valuable, and should always
8.
by setr 18d ago
Per the article, the replicas are configured the same. MIXED is just dynamically selecting the format automatically, and it seems to be the case that AUTOINCREMENT has fundamentally broken semantics under replication. And instead of errorin
9.
by setr 23d ago
It’s hard to imagine someone creating these for PRs? Unless it was auto-generated, but even then it’d only be relevant for fairly large/novel PRs — and then it’s functionally the same as documentation use case. You’d also probably need
10.
by setr 29d ago
The thing I’ve never understood is why SQL itself is not the target of attack. There’s already an inherent language abstraction with the planner; Postgres in theory could be the JVM with any number of languages implemented on top. Including
11.
by setr 29d ago
PL/SQL is cursed and the unstandardized library system means every DB’s ecosystem is anemic. Instead of smashing strings, you can code with all the affordances of C90 and still get the chance to smash strings together if you need to do
12.
by setr 29d ago
Learning SQL doesn’t absolve you from the fact that, from the perspective of your PL, you’re smashing arbitrary strings together like a Neanderthal, and you can be offered all the support otherwise given to your string smashing problems (ex
13.
by setr 1mo ago
That’s just how all Diablo clones work; basically consider it asset reuse… Power fantasy during leveling / campaigning always comes from being “ahead of the curve” gear/build wise — the subject of your combat is rarely meaningful
14.
by setr 1mo ago
> It's true they don't HATE people, but it's also true they absolutely have no conscience in negotiations and have zero concern about relationships. Sure. Like a lawnmower.
15.
by setr 2mo ago
For that purpose, you’re perfectly well off just leaving it as an opaque blob; compress, base64 encode and stuff it into a string/varbinary column and call it a day. You don’t even need to store it in pg itself; stuff it into a cheaper
16.
by setr 2mo ago
Idk how big of a market pure city driving would be; I imagine most city traffic sources from the suburbs Unless this is meant for like taxis, similar to auto-rickshaws in Southeast Asia. Or maybe short distance car rentals like zipcar?
17.
by setr 2mo ago
For these agentic AI systems, like a human operator, the LLM needs to have a wide variety of operations available to it, gated by permissions and authentication. They should be calling APIs. They should be making DB queries with RLS. The re
18.
by setr 2mo ago
The problem with ORMs are 1. They pretend SQL is standardized, and support a heavily reduced featureset for any given database as a result 2. They leave awkward holes in their abstraction, leading to psychotic behaviors like N+1 and implici
19.
by setr 3mo ago
The smell is 50% the asset packs available in the respective stores. The other 50% is the default character controllers and the default lighting settings
20.
by setr 3mo ago
The issue I find with this pattern in docs/tutorials is that the prefix makes it very obvious which functions are from this library. It's particularly worthwhile when looking at the bigger examples that might involve another libra
21.
by setr 3mo ago
Wait TFA is like 90% a copy of whatever the PDF is on this website. It just prefixes it with a small story
22.
by setr 3mo ago
Both are hosted by nature.com though...
23.
by setr 3mo ago
> It takes just as much work to delete a row as it takes to insert a row. Why wouldn't it? Obviously you have to do almost all the same operations: write a log, write the deletion, update indices, replicate it, etc. It takes far mor
24.
by setr 3mo ago
Apparently AI models have gotten decent at geoguessr... Might be worth a shot? https://news.ycombinator.com/item?id=43724935
25.
by setr 3mo ago
If my understanding is correct, the use of palantir by creatures leads to their own downfall, both for evil and good characters. So following through, it's very useful for it to be in evil hands
26.
by setr 3mo ago
honestly I dont want plan hinting so much as being able to ban table-scanning / nested loops / etc on specific tables, and be able to set that independent of actual table-size so I can coerce its failure in dev environments
27.
by setr 3mo ago
> literally save like 20 seconds in some cases because 1 HUGE query becomes 8 straightforward ones with maximum index usage. I don’t understand how splitting a query up would have any relationship to index utilization; the planner shoul
28.
by setr 4mo ago
> I covered that in my talk, which will be eventually published on YouTube. Any idea how I get myself notified once it’s up? Or a YT account to poll
29.
by setr 4mo ago
> This is because taking up 100% of the CPU effectively captures 100% of RAM Isn’t that only true though specifically at 100% CPU utilization? If it were at 90% CPU, then you have no RAM capture, and then you can’t say anything about whe
30.
by setr 4mo ago
If you take out ordering, then lookups on your SoA are now a search, and n-field lookup on an entity is now a JOIN operation. The smarter you get about it, the closer you get to an OLAP db Which leads to my theory… I feel like Bevy could be

More ›