setr

30 ms·

91.
by setr 1y ago
They’re indexed in the sense that they’re already halfway to the structure of an index — which is why they’re happy to toss indexes on top arbitrarily, instead of demanding the user to manage a minimum subset.
92.
by setr 1y ago
Clickhouse isn’t fast at table scans, it’s just columnar. Indexes are basically a maintained transform from row storage to column storage; columnar databases are essentially already “indexed” by their nature (and they auto-apply some additi
93.
by setr 1y ago
Text editors progress one funeral at a time.
94.
by setr 1y ago
The game simulation will get more detailed/granular as aesthetics dial down in perceived value. You can always go bigger/wider/more procedural/more multiplayer. This is also why every hard problem eventually shows up — g
95.
by setr 1y ago
I’ve been of the opinion that every hard problem in CS shows up somewhere in gamedev. It’s a great space for inspo.
96.
by setr 1y ago
Because what was once an active decision became a default, what was a default became an expectation, what was an expectation became an effective-requirement. And lo, norms are made, the ratchet turns, culture solidifies, a new line written
97.
by setr 1y ago
The only correct syntax/format [ , a , b , c ] If only there existed a language designer intelligent enough to support it
98.
by setr 1y ago
I don’t think that matters that much; it’s still just a popularity contest, and if something manages to break through that threshold, it’ll be trivial enough to make the default. No one knew Reddit boards and 4chan boards either; you just k
99.
by setr 1y ago
One of the things I find most annoying about DBAs is they don’t understand just how utterly awful their tooling is. The error messages alone should be enough to throw a hissy fit, but as a group they’ve never dreamed of a life better than t
100.
by setr 1y ago
The main value of regexes is expressing a fairly convoluted ask in a fairly concise form. While I’d expect LLMs to eventually generate regexes correctly, I’m not sure how you’re going to prompt the thing in a way that’s not harder than writ
101.
by setr 1y ago
Isn't a circular array implemented with a modula to begin with? I don’t see how you bypass it
102.
by setr 1y ago
I’m fairly positive the answer is trivially logical equivalence for pretty much any substring operation. I can’t imagine bitwise equivalence to ever be the “normal” use case, except to the implementer looking at it as a simpler/faster
103.
by setr 1y ago
If you’re recording events as intent, then the event table is the source of truth and the state of the database is effectively snapshot of the state. In principle, you should be able to replay the events to produce the current state. If it
104.
by setr 1y ago
The original premise, from TFA, is Another is the Twitter-optimized “you’re a terrible engineer if you ever store booleans in a database” clever trick That is, universal application. My point is: doing that, for the most part, will
105.
by setr 1y ago
> Including timestamps on rows (including created_at and updated_at) are real bacon savers when you've deployed a bug and corrupted some rows and need to eg refund orders created in a certain window. But that’s my point. You’re maki
106.
by setr 1y ago
If you take the statement at face value — essentially storing booleans in the db ever is a bad smell - then he’s correct. Although I’m not even sure it’s broadly a good principle, even in the on_at case; if you actually care about this kind
107.
by setr 1y ago
If ptr is some kind of global, then it makes sense for it not to be deallocated by the destructor? It’s apparently not really managed by this class, so why would its lifetime be tied to it? I mean it’s psychotic to half-manage it like this
108.
by setr 1y ago
The missile knows where it is because it knows where it is not… https://youtu.be/bZe5J8SVCYQ?si=QrIlpJ6BuJADd_zF
109.
by setr 1y ago
I think the problem with this one is that LLMs are somehow both unreasonably effective as well as unreasonably ineffective. Letting the code editor llms do their suggestions, I’ve gotten a ton of useless boilerplate garbage suggestions, but
110.
by setr 1y ago
I suppose that’s what cobol copybooks are; untagged unions, everywhere, all the time, all at once
111.
by setr 1y ago
This article seems perfectly valid? They aggregated all of the blades, and it’s ugly, and it Sweetwater never actually gets to processing (eg bankrupts), it’s effectively permanent. Though I don’t see why sweetwater cant simply put up a fen
112.
by setr 1y ago
the issue isn't the value of i, the issue is that i is still available after the loop ends. in most other languages, if it was instantiated by the for-each loop, it'd die with the for-each loop
113.
by setr 1y ago
> I mean, trees don't get eaten alive by bacteria. Neither do I but I don’t think my natural antibacterial properties are sufficient for a hospital
114.
by setr 1y ago
The primary impetus is to enforce the constraint: a billing is either insured or uninsured. Insured has additional metadata X, Y, Z. Uninsured has additional metadata A,B,C. A billing cannot be both. If you separate them into different insu
115.
by setr 1y ago
Given that its India, I struggle to imagine any movement about 10mph
116.
by setr 1y ago
I mean this particular problem would be resolved if the database let you define/defend a UNIQUE constraint across tables. Then you could just do approach #2 without the psychotic check constraint.
117.
by setr 1y ago
If 95% of the data can be trivially modeled in a relational database, your recommendation is to switch databases or add a new system entirely?
118.
by setr 1y ago
Only the first strategy shoves it into the same table? The fundamental problem is record A can have type X Y or Z, with each type having additional metadata. You could flatten the model and have a table for each type X Y Z and query them in
119.
by setr 1y ago
You wouldn’t do what? Have polymorphic data to begin with? I don't see how you can choose to avoid the scenario that record A has one of several possible related metadata, other than just ignoring it and allowing invalid representation
120.
by setr 1y ago
I think the question is notable though — there’s having the challenge, and then there’s considering it as part of your identity. Personally I wouldn’t; my various issues are just things I’ve got going on, but I don’t think of myself in thos

More ›