HNHacker News
TopNewBestAskShowJobs

drittich

518 karma · joined October 11, 2012

submissionscomments
drittich··on A misleading open letter about sci-fi AI dangers ignores the real risks
This feels like a strawman argument. I suspect the person you are replying to would agree with your last sentence. Can you think of any ways the two things might be perceived differently?
drittich··on Your "simulation" might not need state
Please go on - I'm a novice at game dev and this kind of lore is gold and like gold, hard to find.
drittich··on Four book adaptations we want instead of more Lord of the Rings movies
I remember reading about that...does not seem available for streaming.
drittich··on Four book adaptations we want instead of more Lord of the Rings movies
A Gormenghast movie/series could be incredible.
drittich··on Ask HN: Why aren't SQL queries compiled?
Queries are compiled, i.e., a query plan is created and then executed. Depending on various things that plan may get re-used the next time the query is run. So what you are talking about exists. Databases can examine the plans, database statistics, and the resulting metrics from executing the plan and make recommendations about indexes.
drittich··on Self hosting in 2023
I use DDNS with Cloudflare, which offers free DNS. I built an open source Windows client for this (could be cross-platform, just haven't bothered yet).

https://github.com/drittich/DnsTube

drittich··on MS Teams 2.0 – trying to fix the issues
Formatting is annoying in Teams but I've mostly learned to work around the issues. My number one annoyance, that doesn't seem to be mentioned that often, is that there are many places where you can't get a direct link to a message. I get a huge volume of activity in teams, and there are many things I need to bookmark for later action that would be too challenging to find again. Most of the time, I can't right click and save a link, although sometimes in the web interface it's enough to copy the url. Providing deep links to any message in teams is my number one feature request.
drittich··on Modern SPAs without bundlers, CDNs, or Node.js
I really enjoyed reading that, it's always a pleasure to get a window into the thought process of other developers as they evolve their ideas. Just curious, did you consider using event bubbling so you can declare event handlers right away rather than doing them in the after render section? This is currently the approach I am taking, and I'm just wondering if there are some pros and cons here.
drittich··on GitHub Copilot’s Code Brushes
You learn something new every day! I have written JavaScript off and on for years and did not encounter that.
drittich··on GitHub Copilot’s Code Brushes
What interests me here is that both your version and the else if version perpetuate the error in the original code which is the case where a is greater than b, which is handled once by a "greater than" comparison, and then again by a "greater than or equal to" comparison, which is clearly redundant. Neither CoPilot, nor you, nor the article author I presume caught this error in the flow control. Catching errors like these adds more value then making it more readable, although making it more readable certainly did expose the error more clearly to me.
drittich··on CTEs as lookup tables
It's not necessarily about locking, it's a way to control what order joins get done in, which, at least in MS SQL, is up to the query engine to decide. By writing to a temp table you can override the query engine's plan, often with huge performance gains.

Less known is that you can get the same effect using a TOP N statement where N is a number larger than the rows you might get back. This presumably avoids the additional i/o penalty of the temp table creation, but I've never validated that. This trick likely is portable across db engines, too.

See https://bertwagner.com/posts/does-the-join-order-of-my-table... - Adam Machanic has some good videos diving deeper into this.

drittich··on Tell HN: Did you know that you can help restore a person’s eyesight for $50?
I've long been surprised at how pervasive bad eyesight is, and often at a very young age. It seems like an adaptive trait. Why is it so common to have poor eyesight? What other aspects of human development suffer so much that seem so important for survival?
drittich··on Easy, alternative soft deletion: `deleted_record_insert`
We do this in SQL Server by running a SET CONTEXT_INFO command every time we open a connection. This makes the current user ID available to any SQL that runs.
drittich··on 24-core CPU and I can’t move my mouse (2017)
Same experience here. I work my machine hard. It runs 24x7, hosts many sites, databases, Plex, and I do some pretty heavy development work on it daily. It pretty much "just works". The last time I had to routinely reinstall Windows was Windows XP. Ever since Windows 7 driver stability is significantly better. Despite all the bad press, the Windows 11 upgrade was smooth for me. Yes, the OS has some annoying features, but all in all it's been remarkably stable.
drittich··on Ask HN: Best board games of 2022?
Forgotten Depths sounds really cool - I can't figure out when it will be available though!
drittich··on Mangle, a programming language for deductive database programming
Yes - my only attempt was in the early 1980s when I started to develop a language implemented on top of interpreted BASIC. It was called MAL (My Attempt at a Language). I wish I still had it - I have no recollection what my design goals were, if any! The only thing I have left is the name, and I'm quite sure that was the best part about it anyway.
drittich··on Build the Modular Monolith First
I would add 4) documentation to that list. A wiki full of docs is the closest analog I've seen to a monolith ball of mud codebase.
drittich··on Turning music into a chore is how I became a musician
That's a wonderful definition, I'm still turning it over in my mind a day later. I like how it provides a "why" for culture, with a pretty grounded reason. I tried to locate the origin of it, but just found a bunch of paraphrasings without attribution. Any idea where it originated?
drittich··on Ask HN: What piece of code/codebase blew your mind when you saw it?
Here's the first that blew my mind, from the early 1980s: It was a BASIC "AI" program that would guess what animal you were thinking of just by asking a few questions. "That's crazy," I thought.

And, it learned more each time you ran it - even more crazy! It was only when I looked at the source code and realized that it was using self-modifying code that I went, "Wait a minute - THAT'S A THING?"

I had so many of those moments. The very first was realizing you could use an iterator variable to do other things within the loop. That's the exact moment when programming clicked for me. My perception of it changed from being a glorified way to write out steps (like a hair-washing algorithm on a shampoo bottle) to realizing it could be very expressive and flexible.

drittich··on My dad's resume and skills from 1980
This is exactly how I first learned to program. Waiting a whole day to find out you had a bug was just way too frustrating for me so I completely wrote it off, as much as I enjoyed writing code. Once the first PCs came on the scene, though, everything changed and I was all over it. Still am.
drittich··on A chill driving game with procedurally generate scenic landscapes
If you read "slow and chill" as an imperative, not adjectives, then it works just fine.
drittich··on The Mystery of 355/113 (2010)
>The fraction 355/113 is incredibly close to pi, within a third of a millionth of the exact value. This level of accuracy is far beyond its rights as a fraction with such a small denominator, and it causes various oddities elsewhere in math.

On the other hand, from a purely practical perspective, the answer is only accurate to six digits, which is the number of digits in the fraction you must remember. So, you're not really getting much of a free lunch.

drittich··on The Collectors Who Save Video-Game History from Oblivion
Yes, but if you DO lose a byte or two, it may render the whole thing unreadable, at least without getting into forensics.
drittich··on The Collectors Who Save Video-Game History from Oblivion
I joined a group of vintage computing enthusiasts recently, dedicated to a specific platform. During a recent online meetup, I watched as one of the members attempted to archive newly discovered cassette tape copies of previously unavailable commercial software applications from the late '70s. These may well be the only copies in existence - at least as far as we know now they are.

During the meeting, there was a hairy moment where the tape broke and got tangled up and likely ruined. This happened because of an old splice, but fortunately was at the end of the tape just as everything got successfully archived (at least one copy of it anyway).

It was a cool moment to observe, and I now have copies of these applications in my possession.

drittich··on IMDB deleted all negative user reviews for The Rings of Power
Perhaps I'm an outlier. But, I thought I'd post my thoughts in case others get dissuaded from trying the show based on all the negative feedback. Note, I've only watched the first episode.

I watched the show with two other people, of very different interests and ages. We all enjoyed it immensely.

- The sets, costumes, and cinematography are fantastic and at times breath-taking. The level of detail in the costumes is amazing, and I can't really imagine them being better. - The acting is first-rate. IMO it's better overall than the acting in LoTR, or at least as good, and better than in most shows you'll watch. I did not see an actor that was not all-in for their role, and the many accents are beautifully done. This is the most important quality of any show for me. - The language in the script is elevated, and there are some beautiful lines. Scenes are allowed to develop, without the need for the rapid cuts many shows feature/rely on. - Plot is fine! I have not seen where it will go yet, but there are some big plot points, and subtle tensions developing. I had no problem here.

I love LoTR, but am not a dedicated Tolkien fan with rules about how things must be. I am fine with spin-offs, re-imaginings, alternate worlds, whatever! IMO the goal here is to entertain, to capture the imagination, and to do work that shows dedication to the craft and I think the show easily succeeds in all of those. I would probably watch a full season just for the production value alone.

Also, the whole race thing: What? To me it's a complete red herring and everyone in the show belongs there. This is not just gate-keeping, but racism plain and simple. If countering that racism is your only reason to watch the show, that's a good enough reason.

drittich··on A Simple Entity Component System (2019)
I agree - I have looked into a 2 or ECS implementations, and they either seemed awkward, or brought in a bunch of other concerns I did not care about, and in the end decided to roll my own for some games I was building. It was pretty simple in the end. Dependencies definitely became a bit lengthy in some cases, but I didn't hate that, in that it makes the coupling explicit.
drittich··on A Simple Entity Component System (2019)
I have a similar feeling, but have not converted that feeling into building production code that way yet, partially because it conflicts with a large amount of existing code that I work on in terms of design. It definitely has tradeoffs, but I found a large class of problems went away when I used it.
drittich··on YaCy – your own search engine
Even as a media server I personally find it too expensive to buy one that can handle 4K transcoding, frequently needed for subtitles. I just use Synology to server the files and run Plex on a separate machine.
drittich··on YaCy – your own search engine
I like Synology a lot but mainly use it for storage/backup. It's a very expensive way to host containers IMO. I would look to a Mac Mini for something like that.
drittich··on Flight Simulator 2022: Ultra Realism on RTX 3090 with $100 Graphics Mods [video]
I played many long hours with that. I still have the original disk it ran from, a single 5 1/4" floppy.
← PreviousPage 4 of 7Next →