Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
sagarm
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
29 ms
·
481.
▲
by
sagarm
4y ago
Documentation substantially longer than the implementation can mean the abstraction/interface is more complex than simply reimplementing for a specific use case would have been. Sometimes you want a library anyway in these circumstance
482.
▲
by
sagarm
4y ago
From https://help.kinopio.club/posts/how-your-data-is-stored/ : " Without an Account Your user and spaces data lives entirely on your own computer, in your browser localStorage. Because it is not sent to a ser
483.
▲
by
sagarm
4y ago
Get it covered under civil asset forfeiture somehow. If our rights are going to be trampled anyway, might as well be some social benefit.
484.
▲
by
sagarm
4y ago
I do drive. I can't remember the last time I used my horn. If someone is about to merge into me my solution is not to hope they suddenly drive competently in response to a honk, I avoid them. Or more likely, I've avoided them ahea
485.
▲
by
sagarm
4y ago
What are you trying to do, and why the C++ requirement?
486.
▲
by
sagarm
4y ago
Allow construction of undesirable housing, like SROs.
487.
▲
by
sagarm
4y ago
Oh, was your objection specifically to allowing references to following (not just preceding) select list items? Then we're in violent agreement. That would be complicated to implement and confuse users. Definitely not worth it.
488.
▲
by
sagarm
4y ago
What do you use recursive queries for?
489.
▲
by
sagarm
4y ago
It can definitely be misused, but SELECT * is pretty handy for ad-hoc queries and to succinctly get all (or almost all) of the columns for a subquery or CTE.
490.
▲
by
sagarm
4y ago
I agree that it's ugly and don't use it myself, but I find that I modify the last item in a list far more frequently than the first. Probably because the grouping columns tend to go first by convention, and these change less.
491.
▲
by
sagarm
4y ago
I've seen quite a few production queries that use indexes in GROUP BY and ORDER BY; it's quite common. Probably partially because linters/code review/etc are lightweight to nonexistent amongst the analysts/data scie
492.
▲
by
sagarm
4y ago
Many dialects already support using aliases in GROUP BY and HAVING too, btw. IMO it's most useful (though somewhat more difficult to implement) to be able to use the aliases with window functions or large case/when statements, som
493.
▲
by
sagarm
4y ago
Note you can already reference select list items in GROUP, HAVING, and ORDER BY so it's not that big of an extension. I've implemented the ability to reference select-list aliases before; it's not that hard to do if implement
494.
▲
by
sagarm
4y ago
I think you meant "pro forma" not "performa".
495.
▲
by
sagarm
4y ago
The article has over a dozen links to articles and quotes data from several studies, so this claim seems contrary to the evidence.
496.
▲
by
sagarm
5y ago
Presumably the Sacramento utility district doesn't serve high risk fire areas, so their customers don't have to subsidize people that choose to live on the wildlands-urban interface.
497.
▲
by
sagarm
5y ago
People who choose to live in the Wildlands urban interface should bear the cost for undergrounding the wires they rely on IMO. Probably politically infeasible, unfortunately.
498.
▲
by
sagarm
5y ago
> Changing an API breaks projects using it; you either do versioned APIs and/or coordinate changes with downstream consumers, the same as you would with an API with external customers. This is a ton of work relative to building/
499.
▲
by
sagarm
5y ago
The reality on the ground is that 1) pedestrians, cyclists, and drivers have to share space 2) speed limits aren't enforced on drivers 3) drivers that hit pedestrians at 40mph kill 50% of their victims; at 25mph, they only kill 10%.[1]
500.
▲
by
sagarm
5y ago
2-way stops often feel stressful or unsafe if there is any significant traffic. Roundabouts seem like an improvement with the much lower chance of being t-boned.
501.
▲
by
sagarm
5y ago
GP meant that you are paying $5.80 for a therm's worth of electricity, so therefore electric and gas are the same cost at a COP of $5.80/$1.60 = 3.65. At a higher COP electric is cheaper; at a lower COP, gas is cheaper. You can us
502.
▲
by
sagarm
5y ago
Most Americans don't live in rural areas.
503.
▲
by
sagarm
5y ago
That would require removing parking. The small minority of drivers in the city get VERY worked up about the possibility. It's a classic example of how policy changes with diffuse benefits and concentrated costs are hard to implement.
504.
▲
by
sagarm
5y ago
The set of jobs that require moving around a truck full of tools is tiny relative to the number of workers -- blue collar or not -- that don't need this. So who, really, is the common man? https://www.bls.gov/opub/
505.
▲
by
sagarm
5y ago
It might happen faster in NYC with the nudge from these fines.
506.
▲
by
sagarm
5y ago
Adding capacity enables/encourages more sprawl, resulting in more VMT without additional value created.
507.
▲
by
sagarm
5y ago
> That's not a bad thing, but it isn't true anyway, you literally login with your wallet. > Here's more geared towards your "genuine curiosity" of web3 apps I get that you weren't addressing my particular
508.
▲
by
sagarm
5y ago
I am genuinely curious on useful applications for a decentralized ledger, so I skimmed this linkdump. > https://github.com/OffcierCia/DeFi-Developer-Road-Map Background and development information, no applications.
509.
▲
by
sagarm
5y ago
The California requirements can be met with off-site solar, though this is currently being litigated.
510.
▲
by
sagarm
5y ago
The article notes that at least in California, infra costs are roughly 75% of real costs so the sounds about right.
More ›