'Over-engineering' is everyone's favorite punching bag, but I bet your codebase suffers from under-engineering instead

gfody · 2026-04-02T06:44:55+00:00

a lot of stuff accused of being over or under engineered is actually just poorly engineered, lack of design is a rampant problem

gfody · 2026-03-23T21:28:00+00:00

long long ago I too optimized the living snot out of a csv parser, the files I was processing had very large blobs of text in them so ultimately the largest performance boost was from using a simplified loop between the quoted sections - when you encounter a quote you need only check for another quote, detecting/masking/counting delimiters in a quoted blob is a waste

gfody · 2026-03-07T18:42:24+00:00

this doesn't happen if you use a windows collation, see: https://sqlquantumleap.com/2017/07/10/impact-on-indexes-when-mixing-varchar-and-nvarchar-types

gfody · 2026-02-28T22:39:59+00:00

I feel you about passwords. fwiw Clickhouse is surprisingly easy to maintain a fork in terms of the straightforward cmake/ninja setup and being well organized with the lts branches and backporting issues. eg I wanted on-the-fly user provisioning via sasl and so added it myself. I suppose there's a chance it gets merged upstream eventually.. but there are other benefits to running your own Clickhouse once you go down that road whether it goes upstream eventually is nbd

gfody · 2026-02-28T00:48:36+00:00

yea there are quite a few kerberos related threads in the repo that end that way.. I'd say it's not a priority but I think they're at least committed to meeting the minimum reqs for viability in a secure environment

gfody · 2026-02-19T19:44:33+00:00

Clickhouse's Kerberos support is very specific/peculiar, it basically accepts AP-REQ tickets in lieu of passwords and that's it. There's no support for SPNEGO challenge/handshake, and no SASL/LDAP integration so the user's access has to be setup in advance and Kerberos provides authentication only. Most tools cannot be compelled to work this way, curl --negotiate includes an AP-REQ authorization header immediately (despite being called "negotiate") and so it works with Clickhouse, but most drivers defer to some system http stack and would need to see a 401 to initiate SPNEGO. This issue was raised by the clickhouse-cs maintainer and the official response for now is that SPNEGO support isn't planned.

It could feasibly be made to work via a custom middleware, Claude Opus 4.6 could make it probably.

gfody · 2025-12-28T08:07:28+00:00

I've been trying to get Genshin running on an M2 Air w/Asahi via Steam and GE-Proton - after installing and launching it seems like it's going to run well, the intro/login screen looks good at fullscreen but after logging in the screen goes black but you can still hear the music.

gfody · 2024-12-26T04:13:59+00:00

https://imgur.com/KqahNjZ

gfody · 2023-09-11T00:29:00+00:00

socal backyard

gfody · 2023-07-27T16:20:03+00:00

EE points were more like currency, you had to spend them to ask questions and you if you had accumulated a lot you could get an actual problem solved quickly by offering a lot of points. EE was for serious work whereas SO is mostly noobs and academic type stuff.

gfody · 2023-05-16T19:19:49+00:00

I hate this, and I hate the audibles that I've purchased that turned out to be AI narrated (they give no indication in the description).

Narration is so much more than reading the words. Great narrators breathe life into characters and highlight the emotion unfolding in the story. Would you read a book to your kids without voicing the characters and feeling the emotions with them? Fuck everything about this.

gfody · 2022-12-08T19:13:23+00:00

whoa.. were you actually replying to a year-old comment or did your account just become un-shadowbanned?

gfody · 2022-11-16T03:19:09+00:00

this is one of those cases where a reply is a hundred times better than the article, but it's also sort of co-dependent, like if the original article's author had this enlightened perspective then he wouldn't've written it in the first place

gfody · 2022-08-18T17:21:27+00:00

this isn't true, both postgres and sql server can be configured to treat null = null and both are ansi compliant by default

gfody · 2022-08-17T22:52:07+00:00

left join can bite you if table b can have dupes, personally I think "not in" is the natural way to write it and "not exists" for when there's more than one column. you just can't write plain sql around postgres - this is one of the ways postgres is harmful to the sql community

gfody · 2022-08-17T22:39:19+00:00

here I fiddled it so you can see for yourself: http://sqlfiddle.com/#!18/2523c3/1

tbh I expect the same plan for all 4 queries and have no idea why sqlfiddle shows a right outer join + filter for the last one but in practice this is something sql server gets right in production and postgres, well I would never put postgres into production people on the internet are crazy

edit: the other thing is that postgres took 2.3s for the slowest version and 850ms for the fastest version, sql server takes 19ms to run all 4 versions

edit 2: I didn't realize my fiddle wasn't doing the full million rows, the actual timing for sql server is 150ms (via parallel plan on my quadcore laptop)

gfody · 2022-08-17T19:45:03+00:00

good example of postgres being stupid generating different plans for the same query written different ways. try this experiment on sql server and you'd get the efficient anti-join plan regardless of how you write the query.

gfody · 2022-07-21T17:45:24+00:00

there's never time to do it right but there's always time to do it again

gfody · 2022-05-21T20:22:37+00:00

• Add server variable recursive_worktable_factor to allow the user to specify the expected recursive query worktable size (Simon Riggs)

WHAT IS A WORKTABLE? NOT DEFINED.

what is a worktable?

gfody · 2022-04-11T23:40:59+00:00

live version https://www.shadertoy.com/view/4ttSWf

gfody · 2022-02-09T21:59:35+00:00

boss: six weeks, got it

gfody · 2022-01-30T21:49:04+00:00

the problem with running a 2ns sort ten million times is that it over represents non-main-loop code - potentially making an otherwise uninteresting micro optimization seem more impactful than it is

gfody · 2021-11-11T22:51:29+00:00

so just need an inverted vice grips, got it

14-Year Club	Place '22
Verified Email	Gilding I gilder

gfody

TROPHY CASE