HNHacker News
TopNewBestAskShowJobs

JohnDeHope

539 karma · joined December 3, 2009

submissionscomments
JohnDeHope··on Troy Hurtubise testing the armour suit he invented
This is terrible.
JohnDeHope··on Ask HN: Name 3-5 books that had the most impact on your career and knowledge?
The Mythical Man Month by Fred Brooks

Professional SQL Server 2000 Programming by Robert Vieira

Programming BASIC for Tandy Computers by David A. Lien

JohnDeHope··on Ask HN: Do you use foreign keys in relational databases?
I do app databases for a living, so I thought I'd dump my 2 cents here. I am very much not on a high horse about it. I'd be perfectly happy to use FK if somebody felt strongly about it. I myself have never found them helpful. My databases are small enough and I write all the SQL access code by hand, so nobody is touching the data except me, and the SQL that I write myself. Things being half-deleted isn't a problem. In fact I can't ever remember where that has happened. I have lots of other problems, but that's not one of them. PKs, indexes, views, etc. I use all of that stuff, but not so much FK. YMMV. Prohibiting joins is throwing the baby out with the bathwater.
JohnDeHope··on Why I quit using SwiftUI
I think a lot of hackers in general, not just on Hacker News, feel like a lot of UI concerns are just bikeshedding.
JohnDeHope··on Wren is a small, fast, class-based concurrent scripting language
"It wasn't a mistake, just a deliberate compromise."

This might describe 80% of all the disagreements people have.

JohnDeHope··on I Implemented Nyströmformer
I thought it’d have something to do with tech author and Dart programming language guy: Bob Nystrom aka @munificentbob.
JohnDeHope··on Ask HN: What are the best programming tricks you know?
Yes. There's some nuance to it, but at the end of the day, yes it is just a function call. Usually the input and output are complex types which express the desired behavior or parameters of the process. There's some conceptual distance between a function that takes two integers and returns an integer, and one that takes a complex series of mutually related arguments, some possible business objects with child objects attached, etc.
JohnDeHope··on Ask HN: What are some reasonable right-leaning news sources?
AntiWar.com is always reliable. As political fashion changes it goes from left-wing to right-wing. At the moment I suppose opposing war is more of a right-wing "isolationist" position. Wait a few years and it'll be left wing again.
JohnDeHope··on Ask HN: What are the best programming tricks you know?
The command design pattern never ceases to amaze me. Package up a complicated process in an "input, process, output" package. Turn it into a black box. The input should be as small as possible, just the details and data you need to "do the needful". The output should be as little as possible to explain how things went. I usually let my code grow organically, but once it gets to a certain point, using this technique really helps clean things up.
JohnDeHope··on Stop Drinking Now
> Stop drinking now!

Start screwing yourself, now! With this line of reasoning, there is no behavior that people who think like this will not justify themselves in managing.

JohnDeHope··on Apple Silicon is an inconvenient truth
> how much faster would a non-Windows machine have to be

Until Macs run games, it's a pointless comparison. If Steam did for Macs what they did for Linux, then we'd have something interesting to talk about. But a PC without games is about as attractive as... a Ferrari, I guess. If somebody handed me a free 200K$ sports car, I'd just sell it. It's useless for my lifestyle. A PC that can't play games is equally useless to me.

JohnDeHope··on Midwestern Teachers Reveal Why They're Leaving the Classroom
I hope a few of my students stayed in the field. If they did then maybe even a few of them are here? You guys were the best. Thanks for the memories. It really was a good year.
JohnDeHope··on Midwestern Teachers Reveal Why They're Leaving the Classroom
My suggestion… put 2 teachers in each room, a SME who covers the core material, and a disciplinarian who is good with kids. You’d get experienced professionals lining up in droves to teach deep dives into their favorite material if they trusted they wouldn’t be on the hook for managing the classroom, too.
JohnDeHope··on Midwestern Teachers Reveal Why They're Leaving the Classroom
I lasted 1 year in the classroom. The rowdy, disaffected students were 100% the problem.
JohnDeHope··on Ask HN: Which book are you reading, since when?
Mere Christianity, by C.S. Lewis, for the second time, since a few days ago, about 90% of the way through.
JohnDeHope··on Ask HN: What are some cool but obscure data structures you know about?
I always thought the relational calculus was awesome. There’s only one place I’ve seen it in a real world use case, outside of college, and that’s in a database called Suneido.
JohnDeHope··on 40% of Americans believe the Earth was created within the last 10k years (2019)
If a person "believes" something, but there is zero effect of that belief on any meaningful aspect of their or anyone else's lives, then what relevance does it have? If I "believe" the Earth is flat, but still fly on airplanes, and use a cell phone empowered by satellites, etc. then who really cares what I say I "believe"?
JohnDeHope··on Scorched Earth: The Mother of All Games
Any similar iOS games with multiplayer?
JohnDeHope··on _hyperscript – a small scripting language for the web
I'll admit those aren't my circles, so if I'm wrong to say the older project never hit critical mass, I'm sorry.
JohnDeHope··on _hyperscript – a small scripting language for the web
I think if your project goes dormant for years, and was never really that big of a thing to begin with, that you kind of give up naming rights, don't you?
JohnDeHope··on Ask HN: Developer Workstation Backups
My workstation backup is a word document that explains how to quickly reproduce a configured workstation, given the usual sort of Windows fresh install we get from IT. This is useful because, far more often than needing a backup restored, we have new people starting, and established folks needing fresh clean Windows images because theirs are trash from 12 months of development. It's just a side benefit that if somebody's machine were to fall into a bathtub, we could deal with that, too.

All documentation and non-code files are in OneDrive, SharePoint, Teams, or good old fashioned shared network drives. IT handles backing that up for us. $Deity bless them, we've never lost anything from a database or file storage.

JohnDeHope··on Why I’m Leaving the University
Is the idea that they're going to use the lack of tenure to get rid of the woke folks, or the non-woke?
JohnDeHope··on Ask HN: First-time dad-to-be. What do you wish you'd known back then?
Nothing. You’ll do fine.
JohnDeHope··on Ask HN: I’m 41 and still unmarried – what should I do?
Find and join a church, they're great places to meet people. If you're an atheist or agnostic, you can still join a Unitarian church. Although at this point, picking and engaging fully in a religion (whichever) might not be such a bad thing to try.

(Warning, possibly discouraging? ... If the original post is true, then you really must already have a clue about what's up. It seems impossible to me that you could be all that, and do all that, and still really have no idea why it's not working. If none of your friends can possibly fathom what's up, then maybe you need more honest friends. There's something they're not telling you, or that you aren't letting yourself recognize.)

JohnDeHope··on V 0.3
I think a version number of 0.3 conveys "alpha".
JohnDeHope··on It's worse than you think
Oh and the Bhagavad Gita hits this too. "Thou hast power only to act, not over the result thereof. Act thou therefore without prospect of the result, and without succumbing to inaction." Really this is a universal that every philosophy has to speak to. It's really interesting.
JohnDeHope··on It's worse than you think
This reminds me of Candide. I can't find a quote that perfectly lines up with TFA. But this comes close. Read the book if you're piqued.

  "You are right," said Pangloss, "for when man was first placed in the Garden of Eden, he was put there "ut operaretur eum", that he might cultivate it; which shows that man was not born to be idle."

  "Let us work," said Martin, "without disputing; it is the only way to render life tolerable."
The author of the post here is coming at this idea from one specific angle: it's worse than you think. But this is a specific instance of a larger insight. None of it makes any sense, nor has any meaning. He could go one step further with all of this. yes, it's true that your to do list is a complete f-up. No doubt. But it's not just your to do list, or your imposter syndrome, or etc. It's all of everything. The whole of existence. It's all just one complete cosmic joke of a guy slipping on a banana peel joke.

I think the Hitchhiker Guide Galaxy books by Douglas Adams captured this. When I was a kid I didn't realize the existential dilemmas that kept cropping up. I just thought it was funny. Now in my mid-40s it's still funny, but it feels a lot more true, too.

I'm also getting vibes of this from Jesus.

  John 18:36 Jesus said, "My kingdom is not of this world. If it were, my servants would fight to prevent my arrest by the Jewish leaders. But now my kingdom is from another place."
My angle being, this world is not what's important. Sure it's important because you're here now. There is that. But don't get too caught up in it. It's all going away soon. It doesn't really ultimately matter if you're late to your daughter's orthodontist appointment.
JohnDeHope··on Ask HN: How do I learn real-world COBOL?
TL;DR; find a way to work in a mainframe environment. I think this is true of a lot of things, but starting in 2022, it's definitely true for learning cobol. The thing is, cobol is not just a programming language. Living and working in a mainframe environment is it's own whole thing. There is so much you'll have to learn. It's like the difference between linux and windows, but I'd argue is easily x2 to x5 as jarring. Just learning ebcdic instead of ascii is a thing. And navigating a green screen is as foreign to a modern pc user as, say, going from being a programmer in a high level language (like say java or c#) to using assembly language. It's not that you can't learn it, but it's that your whole brain has to be tilted to the side just to understand what's going on. A mainframe is a completely different world from modern pcs. The cobol programming language is 1/10th of it.
JohnDeHope··on Show HN: PRQL 0.2 – a better SQL
"What do you think should happen if there are multiple foreign keys connecting the two tables? Should this also work for many-to-many relations with an intermediate table?"

If it's not ambiguous, then let me do it. If I rely on ambiguity then throw an exception. In the case of multiple foreign keys, throw an exception, as there's no way to know which one I mean. It'd be nice if I could disambiguate the situation though. Normal SQL allows the `on` clause.

  from TableA
  inner join TableB on <expression>
What if I could specify a foreign key constraint just as easily...

  from TableA
  inner join TableB by ConstraintC
Where ConstraintC is the name of a foreign key constraint between Table A and Table B. It'd be nice to specify the constraint without having to specify the column name details.

The same goes for the many to many relationship with an intermediate table. It could look something like this...

  from TableA
  inner join TableB through TableC
I wouldn't introduce TableC into the scope of the statement. It's not in the FROM clause. It's used in the query but is not available for selecting from. If you want to bring in columns from it, join on it the usual way.

As applications grow, and initially simple lookup table semantics get more nuanced, it might be nice to be able to constrain the join on the lookup table like this...

  from TableA
  inner join TableB through TableC where <expression>
That way if my TableC has some extra columns, such as effective dates, or deleted flags, or that sort of thing, then I can filter out some of the joins that might usually happen.
JohnDeHope··on Tech Companies Won't Say If They’ll Give Cops Abortion Data
Tech companies also won't say if the sun will rise tomorrow. Hint #1: it will. Hint #2: they will.
← PreviousPage 5 of 8Next →