HN user

tracker1

13,943 karma

tracker1.at.hn

My opinions are my own and do not necessarily reflect those of my employer.

* X: [@tracker1](https://x.com/tracker1) * Email: tracker1 at gmail * Website: [tracker1.dev](https://tracker1.dev/) * Keto Blog: [Keto Playhouse](https://medium.com/keto-playhouse)

-----

``` [ my public key: https://keybase.io/tracker1; my proof: https://keybase.io/tracker1/sigs/DAQeHW19H-HCUr1ZBXVK7v0QEKqyv4J40IU227AiCVg ] ```

Posts16
Comments12,743
View on HN

Would be kind of a cool experiment for a mud-style interface, where each npc/avatar was backed by a lower-cost LLM... similar rules for the npcs in the game, but a background feed, and history of interactions with other players as background.

Maybe limiting npc's to only a certain number of moves that aren't a response to other users per day...

It could be a lot of fun.

Not to mention, physical limits to lithography are slowing down significantly... so tech will continue to evolve more slowly... it'll never be the jump from 1080-1990 again, for example, even though 1990-2000 was pretty close, 2000-2010 much slower and since 2010 slower still.

What's as or more weird is how much hardware is backordered, and how much live hardware is allocated, but waiting on facilities for operation. And how many facilities are years behind at this point already... all on various credit and dept swaps between all the involved companies... it's not just a balloon, it's a house of cards balanced on a balloon.

That's the split between skilled and unskilled labor... I'm talking about trades for skilled labor. And no, it's not for everyone...

But using your own example, how many people with bachelor's degrees are asking if "you want fries with that?" Not every, or any path is guaranteed success... I've worked with plenty of degreed programmers who aren't able to function at all.

How do you handle schema changes after your project is in production?

I mean, sure start with a unified schema file until you have a production release... deploy, populate with placeholder data, etc... but once released, having a file for each set of changes isn't a bad thing.

Also, the management tools you can have single files for each view/sproc, etc... it's just schema migrations you need to take care of.

Yeah, I don't mean maintenance staff for like a rental company, but just running your own repair business, or working with a more established one.

Just being able to do basic drywall and paint along with simple wiring for electronics (hanging/wiring a wall mounted TV, for example). Can do pretty well, ex: $100+/hr .. though you're not going to be 100% productive.

On migrations, there's a .Net tool called Grate that I tend to use for schema migrations... I don't use all the features, but it works well... using a migration stack in a repository for deployments and a similar tool is IMO more reliable than magic comparison tools or hand migrations in practice. You should defensively write your migrations as much as possible so that re-runs are relatively safe, though the tool helps to handle this.

One bit not mentioned, and particularly useful in more modern RDBMS with JSON binary expressions in the database are to leverage JSON columns and avoid joins altogether for a lot of use cases. There are a lot of times where you have variance of sub-information, or other data where table normalization and joins work against you. Even with indexes, joins are costly, especially under load at scale with millions of simultaneous users. You can avoid a lot of this by simply having that sub-table information inside a JSON field with the row in question.

For example, logs and notes related to a specific field. Variable transaction data (paypal vs amazon vs google payments), where the logs/details from the API aren't something that really needs to be in a separate table but related to the transaction.

Another would be something like a classifieds site where many fields are repeated, but sub-fields can vary dramatically by the type of item or category.

Knowing how/when to leverage denormalization and JSON can be one of the most impactful things you can do in terms of performance in practice, short of falling back to a search database (Elastic, Quickwit, etc), which can also be practical depending on your needs, but adds complexity.

Similarly, knowing how your datagase uses certain types of data/serialization... for example UUIDv7 if you don't mind storing creation time (utc) of a record, or COMB if using say MS-SQL in particular... the serialization of said field in practice helps in terms of understanding how indexes update and impact performance.

I do wish the guide was expanded a bit with lots of specific examples and details... a lot of it is hand-wavy blurbs.

Kind of cool to see.. that said, there's more to a tooling experience than benchmarks and specific models. Cursor, Claude Code, Codex, etc. add to the mix. Things like Open-Router and backend options make it easy enough to test.

The tools, libraries and languages you are using can also dramatically affect results. Even on state of the art models, I find, for example, the output of SQL for complex interactions, or C# for that matter to be sub-par, where I find Rust results to be pretty great, with JS/TS falling in between.

At the best, it can feel amazing and productive, at worst, time consuming and annoying that you could have done it faster yourself. YMMV in real world use.

Note: I'm a proponent of human in the loop gatekeeper/reviewer usage of AI, and I'm not able to even consider Chinese models for my own use, and not able to use anything at my day job.

Qwen 3.8 1 day ago

I'm not saying that nobody can use it or consider it... I'm only saying a lot of people literally cannot/should-not.

For example, I'm currently working for a local government office on elections management software... It's a no-go from the get-go for me... AI, in general is not allowed, though a couple groups in the city do have copilot access.

Even if it's running on US hardware, without Chinese comms, that doesn't mean it's completely safe... there are complex attack paths that have and do happen. StuxNet was a long time ago, and it's only gotten worse and escalated from there. Not every job/position/application needs this level of paranoia, but don't completely discount it because you don't have to worry about it.

There's also plumbing, a/c and electrical work... general repairman stuff, etc. Assuming you're okay working hands on and potentially in more stressful environments (weather).

I'm largely with Mike Rowe on this one... it's been a shame the level that people have not been directed into more vocational fields and the level of skilled labor shortages as a result. Higher education has largely been self-serving, not community serving.

It definitely takes a certain personality type to be good at it. Empathy, discipline, self-control and infectiously friendly.

On the plus side, men do have an advantage regarding size/strength in terms of being able to help disabled people move. I think this is probably part of why a lot of men become EMTs (similar field/training).

Never said any such thing... China is willing to abuse anyone and everyone including its own people to get ahead in global markets and to leverage any position of dominance possible. They have an absolute history of competition as a fascist economy. I have never, not once, denied such a reality.

You're just an idiot who assumes everyone that doesn't agree with you is the same. I'm surprised you're able to reply with Xi's penis in your mouth... even if it is kind of spacious in there for his limited size. How is the poo bear these days? Does he like it when you gargle his testicles in your mouth?

At this point, I'm kinda meh on it all... Today's Disney, Amazon/MGM and Netflix productions, not to mention Apple, Sony and others are far from the old guard in terms of competition... Paramount-Warner would be relatively huge, but there's still competition and room for something more/new.

Paramount is more of an also ran as far as streaming media IMO... HBO/Max under Warner is far more established in terms of forward looking/facing and the Paramount catalog and broadcast systems can only enhance this. I think they should be required to divest in the actual cable and broadcast stations though.

What we really need are more fair licensing requirements for older content under copyright, but nobody is really pushing for that.

Are you being paid by China? First you accuse me of simply speaking as a financial benefactor, then you totally shift the conversation into something that doesn't refute what I said.

If you let a model spin too much, you get worse results... that's a fact, even for the best models. Nothing you've stated since actually refutes that and acting like a paid bot doesn't mean anything.

I mean, if you want to felate Xi Jinping, have at it... that's all on you bro. I don't have a horse in this race.

I have an 18yo bill for a medical lab, and I still get my regular bloodwork there... It gets brought up now and then on current visits, and I just say, "I'm not paying that bill."

As to the why, it's because I switched jobs and got my regular labs done and apparently was between coverage that week... they tried to charge me a large multiple of what they charged insurance for the same labs, so I refused to pay.

I also had several bills that were never paid from a week long hospital stay in my mid 30's... Most of them got paid if they'd agree to reasonable payments or settle for lower amounts when I had the money (tax return time, bonus, side work). After 7 years, they were all off my credit and I stopped bothering...

Giving a literal monkey the ability to press more keys faster doesn't get a good joke from it.

A model will often come up with worse results given more cycles of compute, only because it will tailspin from second guesses, rethinking and literal flip-flopping on concepts.

--- edit: to those following the thread below... if you look at the comments from the account replying, it's pretty obviously a pro-China account and all replies are antagonistic against anything other than a total submission to the Chinese state. My responses are intentionally antagonistic as every point I've brought up is completely ignored in favor of insults, so yeah, I've been insulting back.

Qwen 3.8 2 days ago

It's a western site in English where a bulk of users are in the US, which has an adversarial relationship to the US... where many working in IT aren't even allowed to consider Chinese services or products directly (even if what you're getting was half made in China or controlled spaces).

I can't even consider Chinese AI tools for my own use on my own time on my own hardware without potentially risking firing or worse. Yeah, it's cool on a technical level.. but the "open" part of this and K3, etc. is of limited use depending on how/where you can actually use it yourself. Trust is another issue entirely.

I wish that rather than the closed govt medical programs we have... we simply funded a public, non-profit health insurance provider that is motivated by fiduciary responsibility, but not profit driven. While this may seem heartless as some would fall through the cracks, such as cases like tfa that wouldn't be covered, at least there would be more competition against the private insurance companies.

I'm not a fan of fully socializing medicine, but having a non-profit with negotiating power in the mix could only help.