Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
mdavidn
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
22 ms
·
241.
▲
by
mdavidn
5y ago
You can configure the start page to use the address bar for search. That takes the cake for the most-obfuscated-default-search-setting, but at least the start page will send queries to DDG.
242.
▲
by
mdavidn
5y ago
I don’t know about all that, but clearly there is a difference between a business that sells clothes and a business that has imposed itself as a middleman in private social interactions between friends and family.
243.
▲
by
mdavidn
5y ago
Mission Control and App Exposé change to 4-finger gestures after 3-finger dragging is enabled.
244.
▲
by
mdavidn
5y ago
The measurement will be dominated by network IO time. Does the driver wait for acknowledgement when writing? Does it wait for each read before transmitting the next query? These details matter. Postgres reads might be so fast because the te
245.
▲
by
mdavidn
5y ago
I’d recommend whichever one is available in a language the project uses already. Automatic tests for a database could simply be writes followed by reads with expectations for the returned rows. This is how Postgres tests itself. My personal
246.
▲
by
mdavidn
5y ago
I have an impacted Voyage and did not receive the message either. Perhaps they only notified customers that use 3G? I always have mine connected to WiFi to extend battery life.
247.
▲
by
mdavidn
5y ago
That's perhaps true of stored procedures, but SQL views, constraints, and triggers written in a declarative manner are far more maintainable and far less buggy than imperative application code, in my experience.
248.
▲
by
mdavidn
5y ago
Using a migration utility like ActiveRecord, Flyway, or go-pg, SQL definitions can also live in version control, have automatic tests, and deploy automatically. Who has a database in production without these things?
249.
▲
by
mdavidn
5y ago
This. My 36-unit building undertook a massive project in recent years to repair structural water damage under (shocker) a pool deck that wasn't properly sloped. A few owners would yell at the volunteer board and threaten lawsuits at ev
250.
▲
by
mdavidn
5y ago
I agree. The one thing that keeps bringing me back to ActiveRecord and ORMs like it is the Relation class. Being able to pass around and merge queries is great for organizing code and keeping concerns separate. For example, implementing pag
251.
▲
by
mdavidn
5y ago
So are criminal charges.
252.
▲
by
mdavidn
5y ago
The extinction event that wiped out dinosaurs was "just" 66 million years ago.
253.
▲
by
mdavidn
5y ago
Do it today, not “one of these days.”
254.
▲
by
mdavidn
6y ago
It also ignores differences in population. Several European countries have more deaths per capita than the United States. So far, the UK had 200 more deaths per million (11% more). The Czech Republic had 900 more per million (53% more).
255.
▲
by
mdavidn
6y ago
The alternative is to navigate 100 separate token reset processes if you ever lose your phone and all of its TOTP tokens.
256.
▲
by
mdavidn
6y ago
There are a variety of tricks to solve the over/under-fetching problems of REST. My default approach is JSON:API, which defines standard query parameters for clients to ask the server to return just a subset of fields or to return comp
257.
▲
by
mdavidn
6y ago
"Top of the sky" means equidistant from sunrise and sunset.
258.
▲
by
mdavidn
6y ago
Unlike YouTube, a business can replace many of these services transparently from the perspective of their customers.
259.
▲
by
mdavidn
6y ago
Obligatory reminder: Don't run your text editor as root. Instead, try sudo -e /etc/pam.d/sudo.
260.
▲
by
mdavidn
6y ago
These iterative queries convert hierarchical (not graph) data into relational data. That means queries can perform aggregations and joins against other relations, which is obviously useful in a relational database.
261.
▲
by
mdavidn
6y ago
Section 230(c)(2) explicitly protects service providers who remove content that they deem to be “otherwise objectionable.”
262.
▲
by
mdavidn
6y ago
Browsers can check "subresource integrity" to guard against hacks of third-party services. https://developer.mozilla.org/en-US/docs/Web/Security/Subres...
263.
▲
by
mdavidn
6y ago
I had a similar experience this month in New Mexico. After ice and numerous accidents closed I-40, Apple Maps sent me on a two-hour detour through the Pueblo of Zuni, which, of course, was closed to non-tribal members to halt the spread of
264.
▲
by
mdavidn
6y ago
The overlooked differentiator: Vaccine "bad news" is not highly contagious to your family, friends, and colleagues.
265.
▲
by
mdavidn
6y ago
It depends on how many samples. The odds that this specific drawing would yield this result should be one in 42 million, but the odds that a lottery somewhere would yield this result in our lifetime is substantially greater.
266.
▲
by
mdavidn
6y ago
It feels more like iterative problem solving. Once you get part of your factory working, you can entirely shift your attention to the next problem. Existing regions of the factory require surprisingly little attention until they become a bo
267.
▲
by
mdavidn
6y ago
To combat drugs, huge sums of public funds flow to public-sector union jobs and private industries. Both contribute significantly to political campaigns, whereas victims of the drug war cannot.
268.
▲
by
mdavidn
6y ago
Use a password manager like 1Password instead. Don't tie your accounts together.
269.
▲
by
mdavidn
6y ago
I have never "run encryption myself" when connecting to my bank's web site. Have you?
270.
▲
by
mdavidn
6y ago
Transport Fever is a very satisfying train game. The early game is all about making the business profitable. After that, resources are basically unlimited. The end game plays like a giant tabletop train simulator, with a focus on fitting to
More ›