Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
rodw
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
10 ms
·
31.
▲
by
rodw
4y ago
> my friends taking them while we were growing up had pretty negative outcomes. Or - hear me out - maybe severe ADHD, the kind that leads to diagnosis and treatment with stimulant medication at a very young age, is correlated with negati
32.
▲
by
rodw
4y ago
> I have observed very poor outcomes for people who started on ADHD medication when young Relative to the outcome for those same people had they remained untreated, or a "control group" of people with ADHD who were untreated, o
33.
▲
by
rodw
4y ago
Given the context (especially other quotes from Dr. Dodson) I think it's reasonable to assume that the word "not" was dropped, i.e. "Cardiologists know that these medications are NOT dangerous".
34.
▲
by
rodw
4y ago
It's certainly possible that you're just more frugal than most, but I'm not sure if those numbers add up right. Even if you (1) ignore the cost to purchase and furnish the van in the first place and (2) assume you obtain 100%
35.
▲
by
rodw
4y ago
I don't think this fully explains the phenomenon, but I do think there are a couple of factors you're overlooking here: 1. Control over the "distribution channel" is a major factor at least part of the time. The fields w
36.
▲
by
rodw
4y ago
Not only is the work extraordinarily financially valuable in many cases, software is actually pretty hard to do _well_. It's based on highly specialized knowledge and experience. It requires sustained, high levels of discipline and eff
37.
▲
by
rodw
4y ago
That's fair. It's what I was trying to acknowledge when I wrote "I can imagine a scenario where you want to know _when_ a record was logically deleted". That said, I'm genuinely curious about how often and in what w
38.
▲
by
rodw
4y ago
> I’m absolutely repulsed at the thought of turning the users table into a view. What’s next? No code and we only use triggers? Assuming there's a justifiable need to apply the logical-delete idiom to the users table, what's th
39.
▲
by
rodw
4y ago
I agree `deleted_after` is a more appropriate name than `deleted_at`, but it starts to run into naming conventions again. For example `published_at` is often used in editorial systems (newspapers, blogs, etc.) for things that "embargoe
40.
▲
by
rodw
4y ago
> The main problem with views for this use case in practice is that they ossify your schema. Views and matviews are effectively a dependency tree, and many common types of schema evolution become substantally more difficult when the sys
41.
▲
by
rodw
4y ago
I can see that use case and I guess if that's a popular idiom within a particular dev community it's not indefensible, but from a first-principles code-complete/pragmatic-programmer kind of lens, that seems to me like a reall
42.
▲
by
rodw
4y ago
If any non-null value for deleted_at indicates a logical delete, it seems like TIMESTAMP is the wrong data type for that column. I mean I guess I can imagine a scenario where you want to know _when_ a record was logically deleted in additio
43.
▲
by
rodw
4y ago
Seriously. That "Downsides: Code leakage" point is nonsensical. ``` CREATE OR REPLACE VIEW active_customer AS SELECT * FROM customer WHERE deleted_at IS NULL OR deleted_at <= NOW() ; ``` There, I fixed it. Just use
44.
▲
by
rodw
5y ago
Isn't this a pretty typical bring-your-own-device policy? I.e., if you want to use your personal device to access the organization's private network or resources, they are going to insist on having control over that device, or at
45.
▲
by
rodw
5y ago
Ack'd. That makes more sense. I guess I took the comment too literally.
46.
▲
by
rodw
5y ago
I don't know of any "open-source" tab sharing sites (i.e., sites specifically dedicated to CC or other permissively-/share-alike-licensed transcriptions) but for what it's worth there are a large number of "f
47.
▲
by
rodw
5y ago
Can you expand on what you mean by "song recommendations" in this context? Do you mean recommendations like "if you like X you might also like Y"? Assuming the answer is "yes", I'm not sure if I follow the
48.
▲
by
rodw
5y ago
I've also spent a fair bit of time on this topic and for what it's worth I agree with you. It is a harder problem than the monophonic case (and more sensitive to problems like noise under real-world conditions) but you don't
49.
▲
by
rodw
5y ago
I can't quite figure out if your response is meant to be sarcastic or not - i.e., if you're "amazed" at the completeness here or maybe mocking the specialized/exotic chords it came up with in this case. I apologize
50.
▲
by
rodw
5y ago
It is absolutely possible (and effective, depending on what you consider to be an adequate ROI) to apply this sort of heuristic to this domain. The "holy grail" of a universal AMT that works with any number of instruments of any t
51.
▲
by
rodw
5y ago
Automated music transcription - the process of generating a musical score from an audio recording - is a pretty active topic in signal processing (and has been for a couple of decades at least). The monophonic case (one note at a time) is f
52.
▲
by
rodw
5y ago
Also, while I imagine Google probably has (or at least easily could have) code-specific heuristics at play, it seems like it may be harder to reliably apply duplicate content penalties to source code listings, especially short code snippets
53.
▲
by
rodw
5y ago
Funny, it was the "lots of internal linking" bit that felt wrong to me. Not that these low-quality sites don't do that, but I'm surprised to hear that the new algorithm rewards internal links. I'm certainly not a fu
54.
▲
by
rodw
6y ago
Mine was Hoe Cakes ( https://www.youtube.com/watch?v=rNB5eIiIsUc ) at #4. I was a little surprised how much DOOM I listened to on Spotify in 2020. I two tracks from MM...FOOD in my top 20 (the other was Guinnesses (feat. Ange
55.
▲
by
rodw
6y ago
On second thought I do think Paul Westerberg has a strong melancholy streak. At first I had stuff "Waitress in the Sky" or "Tommy Gets His Tonsils Out" or "Alex Chilton" or whatever in mind, but now that I thin
56.
▲
by
rodw
6y ago
> I'm a huge fan of the Youtube recommendation algorithm, and I find it works extremely well for me. This fascinates me. I'd guesstimate that roughly 60% of the recommendations I get from YouTube are for videos I've alrea
57.
▲
by
rodw
6y ago
What's moody about the placemats?
58.
▲
by
rodw
6y ago
Lol. Mine was LCD Soundsystem.
59.
▲
by
rodw
6y ago
Yes, I've seen that a few times. What non-technical management sees is an engineer at the center of efforts to fix an issue in the midst of a crisis. What they don't see is that the work done by competent engineers doesn't bl
60.
▲
by
rodw
6y ago
AMP makes images a PITA [1], often it's much easier to omit the image than deal with the extra production cost and effort. [1] https://amp.dev/documentation/components/amp-img/
More ›