setr

4 ms·

1.
by setr 5d ago
Sometimes in business you ultimately and unavoidably have to eat shit, so it is what it is. But you should strive to be someone who doesn’t have to eat shit, and until then, if you still gotta eat shit, then try not to make a habit of it.
2.
by setr 9d ago
With query hints finally being added it’d probably be doable as an extension
3.
by setr 17d 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).
4.
by setr 17d 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
5.
by setr 18d 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
6.
by setr 24d ago
TFA links to PixelPie as a GPU implementation https://www.cs.umd.edu/gvil/projects/pixelpie.shtml
7.
by setr 24d ago
Also Casey, but his much cooler/deterministic solution to grass placement, to avoid lines https://caseymuratori.com/blog_0011
8.
by setr 24d ago
Ignoring aesthetics, there’s simply significantly more detail produced by max
9.
by setr 25d 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
10.
by setr 27d 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
11.
by setr 1mo 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
12.
by setr 1mo 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
13.
by setr 1mo 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
14.
by setr 1mo 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
15.
by setr 2mo 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
16.
by setr 2mo 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.
17.
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
18.
by setr 3mo 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?
19.
by setr 3mo 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
20.
by setr 3mo 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
21.
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
22.
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
23.
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
24.
by setr 3mo ago
Both are hosted by nature.com though...
25.
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
26.
by setr 4mo ago
Apparently AI models have gotten decent at geoguessr... Might be worth a shot? https://news.ycombinator.com/item?id=43724935
27.
by setr 4mo 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
28.
by setr 4mo 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
29.
by setr 4mo 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
30.
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

More ›