efxhoy · HackerTrans

há 24 diasdiscuss

Great job on getting the fixes merged!

há 29 diasdiscuss

How could an agent bypass file permissions?

há 2 mesesdiscuss

I came back from 6 months of parental leave in march 2026. When I left no one serious was using the tools for more than casual rubber ducking. When I came back my best colleagues were spitting out clauded PRs faster than I could review them, and they were all nice.

efxhoy

há 2 mesesdiscuss

Nice. Would you mind explaining your current config?

efxhoy

há 2 mesesdiscuss

> Enabled IPv6 autoconf (SLAAC) by default.

Sweet! I’m just about to replace pfsense with openbsd on my router. Smoothly setting up ipv6 is a bit of a headscratcher atm, mainly because i’ve never had to understand it before.

efxhoy

há 4 mesesdiscuss

Isn’t it just regular price discrimination? Profit maximizing firms with market power charge different prices based on willingness to pay in order to sell to people who won’t pay a higher single value monopolist price.

https://en.wikipedia.org/wiki/Price_discrimination

efxhoy

há 4 mesesdiscuss

I’ve only had their platforms explained to me by them (palantir) at a conference but the mental model that stuck with me was more of an operating system than a single tool. Think AWS managed services + databricks + whatever library of ready made intelligence software they have already built for others.

They also have “forward deployed engineers” to help organizations actually use the platform. It looked complicated enough to probably be completely useless without these specialists, even in a “self hosted” setup.

The managed hosting also seems like a major selling point so many deployments that probably should be self hosted probably aren’t because muh managed services added value.

And the backdoors of course. There is no way it isn’t full of plausibly deniable “metrics endpoints” that helpfully spew out all the internal data if the right key comes knocking. There’s no way it’s auditable at the level of detail you would need compared to the value of the data and the sophistication of the potential attacker (NSA).

efxhoy

há 5 mesesdiscuss

How is the output quality of the smaller models?

efxhoy

há 7 mesesdiscuss

It’s the clear OLTP winner but for OLAP it’s still not amazing out of the box.

efxhoy

há 7 mesesdiscuss

Maybe my brain is oversaturated with culture war nonsense from too much doomscrolling but that’s where my train of thought went too, even if it wasn’t directly implied.

By claiming our ancient predecessors had terrible taste you can make them look like primitive fools, and make our own modernity appear superior in comparison.

When boiled down to culture war brainrot the poor coloring in the reconstructions becomes a woke statement that the brutish patriarchal empires of antiquity have nothing to teach our sophisticated modern selves and that new is good and old is bad. A progressive hit-piece on muh heritage.

Anything you don’t like is a purple haired marxist if you squint hard enough.

Idk why my brain went there. I’m guessing the years of daily exposure to engagement-farming ragebait had something to do with it.

efxhoy

há 8 mesesdiscuss

I like it! We have a service with a similar postgres task queue but we use an insert trigger on the tasks table that does NOTIFY and the worker runs LISTEN, it feels a bit tidier than polling IMO.

efxhoy

há 10 mesesdiscuss

I had a few periods of doing the same in sublime text, I did use syntax highlighting though. It’s a really great feeling and very liberating, especially in a greenfield project.

Can’t really justify it at work though, projects are too big to and gnarly keep in my head.

efxhoy

ano passadodiscuss

There's nothing wrong with nullable fields when it's appropriate. When kids are born they don't have names. Not all users want to tell you their names. A null value is data too.

efxhoy

ano passadodiscuss

The best practice way to swap fullname for firstname, lastname would be to:

  1. Migration that adds firstname and lastname columns will all nulls
  2. Deploy application code change to start populating firstname and lastname alongside fullname, still reading fullname in the code.
  3. backfill the firstname and lastname values with a script/command/migration
  4. change app code to read firstname and lastname and stop writing fullname
  5. drop the fullname column

I don't think there's a safe way to do all that in a single migration unless all your app code also lives in the database so it can be atomically deployed. If you have multiple app servers and do rolling deploys with no downtime I think it has to be done in these 5 steps.

efxhoy

ano passadodiscuss

Looks great! Can I run it on my own bare metal cluster? Will I need to buy a license?

efxhoy

ano passadodiscuss

Testing strategy? What’s that? I kid, but just a bit. Our use case is a data warehouse. We use DBT to build everything. Each commit is built in CI to a CI target project. Each commit gets its own hash prefixed in front of dataset names. Each developer also has their own prefix for local development. The dev and ci datasets expire and are deleted after like a week. We use data tests on the actual data for “foreign keys”, checking for duplicates and allowed values. But that’s pretty much it. It’s very difficult to do TDD for a data warehouse in sql.

My current headache is what to do with an actually big table, 25 billion rows of json, for development. It’s going to be some DBT hacks I think.

God help you if you want to unit test application code that relies on bigquery. I’m sure there are ways but I doubt they don’t hurt a lot.

efxhoy

ano passadodiscuss

Timescale is definitely worth a look. Pg_partman gets you part of the way. We ended up going with bigquery for our workload because it solved a bigger bag of problems for our needs (data warehouse). It’s very hard to beat for big… queries.

efxhoy

há 2 anosdiscuss

Reuters really broke the site for me when they did what looked like a rewrite about a year ago. Glad to see this as I hardly read it anymore. bbc news is going downhill too, another prime candidate for a project like this.

efxhoy

há 2 anosdiscuss

That’s confusing. What DDL did it do? Create new partitions?

efxhoy

há 2 anosdiscuss

My preferred way of working is plain sublime text and the terminal. I use command line tools for linting, formatting and type checking, wrapped in “make lint”.

I find that sublime is just smart enough to go to the definition using only its “dumb” grepping based approach.

I think the hurdles of getting a nice LSP setup that works across projects in different languages and in a polyglot monorepo is a real determinant. I just really dislike spending any time configuring my editor past the basics, because I’m lazy, updates break them, I move between machines, etc. Getting comfortable with just the basic features means I have less pain maintaining my editor. It’s not a great excuse but for me it’s the path of least resistance.

I frequently pair with colleagues, some are vscode users that are heavy on LSPs and copilot. I have one greybeard colleague who runs a very sophisticated neovim setup, and spends a lot of time maintaining it. We’re all roughly equally productive at the “writing code” part of the job. What sets us apart is our skill in actual software development, which I find is completely uncorrelated to the editor setup. We all work in the tools that are most comfortable to ourselves.

comments