HNHacker News
TopNewBestAskShowJobs

jasonhansel

9,140 karma · joined February 2, 2015

Website: https://jasonhansel.com
submissionscomments
jasonhansel··on For Want of a JOIN
I'm a fan of relational databases, but I think we should concede three points:

1. Databases should accept queries in a structured machine-readable format rather than a plaintext language.

2. SQL in particular is a poorly designed language: it isn't very composable, it has lots of annoying edge cases (like NULLs), and it has a number of annoying limitations (in particular, its historically limited support for structured data within fields).

3. Given how most RDBMSs are designed, you often need to handle denormalization and caching manually. This requires doing a lot of excess data management in a middleware layer--for instance, querying a cache before accessing the DB, or storing data in multiple places for denormalization. Some of this can be done in SQL (e.g. denormalization through TRIGGERs), but since SQL is not a very good language (see (2)) that can be tough.

jasonhansel··on All 1,400 Google Chrome CLI flags
This makes about:config look elegant.
jasonhansel··on Musk wants to do a “total rewrite” of Twitter
Aka "the single worst strategic mistake that any software company can make": https://www.joelonsoftware.com/2000/04/06/things-you-should-...
jasonhansel··on Repairing Your Car in Your Own Garage Is Considered Illegal in Sacramento, CA
How is such a business necessarily illegitimate? I don't think it's always illegal (except in Sacramento, apparently).
jasonhansel··on Repairing Your Car in Your Own Garage Is Considered Illegal in Sacramento, CA
> can always go and rent a dirt cheap plot in an industrial zone

Huh? Where? I don't know of any industrial zones near me that would rent out land to amateur mechanics. Maybe there's one far away somewhere, but you would want your shop to be reasonably accessible to customers.

jasonhansel··on Repairing Your Car in Your Own Garage Is Considered Illegal in Sacramento, CA
Housing is a good investment because it is a place you live in. When you own (and live in) a house, you ideally make both a short-term profit (by having a place to live) and a long-term one (from reselling it later). These aren't mutually exclusive.
jasonhansel··on More than 100 new designs discovered in Peru’s ancient Nazca plain
It's not really a mystery. The geoglyphs are visible from surrounding hills and other vantage points on the ground. They're essentially just giant works of art.
jasonhansel··on Ask HN: Are there valuable insights from the Twitter files?
You do know that most of this happened during the Trump administration, when Trump was ultimately in control of the FBI, right?
jasonhansel··on Sen. Warren's new bill to regulate crypto, combat money laundering [pdf]
In that case, shouldn't we get rid of money laundering regulations for all financial institutions? That would (presumably) provide even more privacy; there's no reason to make crypto an exception.
jasonhansel··on Elom Musk Suggests He Lost “Should I Resign” Twitter Poll Because of Fraud
Unsubstantiated claims of voter fraud? He really is a Republican.

(Yes, this comment will probably be flagged and removed. I stand by it.)

jasonhansel··on Sen. Warren's new bill to regulate crypto, combat money laundering [pdf]
Why should crypto be exempt from the regulations applied to other financial institutions?
jasonhansel··on Sydney CBD is bringing back pedestrian “beg buttons”
So:

1. At intersections with "leading pedestrian intervals" or "exclusive pedestrian phasing," walk signals provide unique safety benefits that reduce the risks posed by oncoming traffic.

2. This can be important: due to road geometry or other obstructions, it can be hard to see oncoming traffic from a distance, especially for the visually impaired.

3. Blind pedestrians can hear audible walk signals, but cannot see oncoming traffic at all.

4. At sufficiently complex intersections, it can be impossible for you to tell whether stopped cars are about to come towards you when a light changes.

5. Most importantly: walk signs usually tell you how soon a light will change, so that you don't start walking just before a light change.

This is why walk signals reduce car-related fatalities, particularly at night, when people are most at risk.

jasonhansel··on Amazon Ring cameras used in nationwide ‘swatting’ spree, US Justice Dept. says
Honestly, showing up with a SWAT team as a first step suggests a certain lack of courage, particularly if the officers know how prevalent SWATting is.
jasonhansel··on Amazon Ring cameras used in nationwide ‘swatting’ spree, US Justice Dept. says
What you do is: you get someone's password from a hacked website that did store passwords in plaintext. Then you try using that same username/password combo to log into Ring.
jasonhansel··on Amazon Ring cameras used in nationwide ‘swatting’ spree, US Justice Dept. says
Obviously the answer is to buy a smart fire extinguisher, so you can remotely put out the flames from your hacked smart printer.

Until someone hacks the fire extinguisher and makes it spray chemicals at you. Then you'll need to add a smart fire extinguisher extinguisher.

jasonhansel··on Amazon Ring cameras used in nationwide ‘swatting’ spree, US Justice Dept. says
Careful about that printer: https://arstechnica.com/information-technology/2011/11/hp-pr...
jasonhansel··on How to Surrender to a Drone
> the "I want to live" surrender hotline

Genius.

jasonhansel··on Free TikTok Growth Course
Free? It costs $89.
jasonhansel··on Sydney CBD is bringing back pedestrian “beg buttons”
The issue is that people won't "wait awkwardly for nothing" forever. If someone can't see the label and is used to having it change automatically, they're likely to assume that the signal just "isn't working," causing them to cross without a walk signal.

IMHO the biggest problem here is that the label doesn't meet the usual standards for road/pedestrian signage. In particular, "real" road signs are retroreflective so that you can see them easily under streetlights (or in car headlights). This is particularly important for signs that are only relevant at night. (Semipermanent signs should be made of a sufficiently durable material, which this...is not.)

jasonhansel··on Sydney CBD is bringing back pedestrian “beg buttons”
This is really dangerous.

People used to not using the buttons during the day may not remember to use them at night. They may not even be able to see the labels at night, since (unlike any actual road sign, at least in the US) they aren't even retroreflective. This is likely to cause confusion, leading people to cross without a walk signal.

So this will disproportionately endanger people walking at night--which is already the peak time for driver-inflicted fatalities.

jasonhansel··on Why Silicon Valley is applauding Elon Musk’s brutal crackdown at Twitter
HN title is misleading. This isn't "Silicon Valley" as a whole, it's "tech executives," as the article states.
jasonhansel··on Facebook employs at least 115 people that formerly worked at FBI/CIA/NSA/DHS
So they...hired people with relevant experience? How is this a scandal?
jasonhansel··on Did insurance fire brigades let uninsured buildings burn?
> People should be able to augment basic services however they wish, to they extent they can afford.

Here's the problem with such schemes. Often both the providers and the customers of "augmenting services" will have an incentive to hollow out the state-provided service until it's substandard.

For instance, let's say the government provides "basic" health insurance but allows private plans. Then the providers of private plans will lobby the government to keep the "basic" service as low-quality as possible, so that people are incentivized to buy the private plans. Furthermore, those who purchase private plans will not personally benefit much from the state-provided scheme, so they will have little interest in its success and little desire to subsidize it.

In the worst case, the result is that the state-run service becomes permanently low-quality. Then people attribute this to public-sector inefficiency and say that "obviously" the free market would do a better job. Then the state-provided service gets abolished when it never had a chance to succeed.

jasonhansel··on Did insurance fire brigades let uninsured buildings burn?
I would hope, at least, that firefighters would always prioritize saving lives over saving property.
jasonhansel··on I’ve been battling cancer last 2 years, but now only have a few days left
As applied to medical decisions, this even has its own name--"Daughter from California" syndrome: https://en.wikipedia.org/wiki/Daughter_from_California_syndr...
jasonhansel··on Should I step down as head of Twitter? I will abide by the results of this poll
Kanye?
jasonhansel··on Twitter suspends pg's account [fixed]
"Free speech, but dissenters will be exiled."
jasonhansel··on Argentina Wins the World Cup
Congratulations on all the hard work that made this possible!

I mean the work of the quasi-enslaved migrant laborers who built the stadiums in 100-degree heat, of course. But I'm sure Argentina put in plenty of effort too.

jasonhansel··on Apple 'created decoy labor group' to derail unionization
> In a memo issued in April, National Labor Relations Board General Counsel Jennifer Abruzzo asked the NLRB "to find mandatory meetings in which employees are forced to listen to employer speech concerning the exercise of their statutory labor rights, including captive audience meetings, a violation of the National Labor Relations Act.

You can read the memo here--I find its case very compelling: https://apps.nlrb.gov/link/document.aspx/09031d458372316b

Normally I'd say "call your congressperson," but this is in the executive branch, so I'm not sure how to best support it.

jasonhansel··on Investigating Logan Paul's biggest scam [video]
A youtuber best known for monetizing the corpse of a suicide victim.
← PreviousPage 7 of 34Next →