Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
zac23or
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
9 ms
·
61.
▲
by
zac23or
3y ago
>Pg stats are messed up somehow. Try running explain analyze foo I did > Postgres doesn’t automatically create indexes Both fields have indexes (created manually). Postgres is incorrectly choosing the index in order by column, not the
62.
▲
by
zac23or
3y ago
> it sounds like you don't have a single index that covers both columns. Yes. But other databases (SQLlite, etc.) select the correct index, without the need to create an index with both columns.
63.
▲
by
zac23or
3y ago
My biggest problem with Postgres is the Planner/Optimizer. The worst example is a super simple query: SELECT * FROM TABLE FOO WHERE ORGANIZATION_ID = 10 ORDER BY CREATED_AT LIMIT 10 OFFSET 0; Postgres sorts by created_at using an index
64.
▲
by
zac23or
3y ago
Of course, there have been many bad things in the past. Floppy disks, cassettes and VHS were horrible technologies. Did you use tube radios? They broke all the time. The difference is that they weren't intentionally horrible, they were
65.
▲
by
zac23or
3y ago
> I always wonder why people want some of these items to last forever. My friend had a NEW Ford that went to the workshop more than 10 times in the first year of use. It's about trust that I will turn on the device and it will work.
66.
▲
by
zac23or
3y ago
Everything is bad these days, not just the sofas. 1. The new switches I bought broke before the old ones, which are over 20 years old. 2. LED bulbs last less than incandescent bulbs, even with a 20-year warranty. 3. The new cell phone'
67.
▲
by
zac23or
3y ago
HN and Zed are not friends https://www.zedshaw.com/blog/2018-03-25-the-billionaires-vs-...
68.
▲
by
zac23or
3y ago
> is the kind of thing that doesn't earn the respect of the people he's trying to convince For me, he's not trying to convince anyone, just complaining, venting about what he saw happening.
69.
▲
by
zac23or
3y ago
This reminds me of XGH: eXtreme Go Horse. https://medium.com/@dekaah/22-axiomas-of-the-extreme-go-hors... People here will probably criticize the programming, motherfucker. Zed doesn't like HN and HN doesn't
70.
▲
by
zac23or
3y ago
yes, don't! Thank you.
71.
▲
by
zac23or
3y ago
After years of lies from anti-drug and pro-drug guys, I simply don't believe this type of article with data to back it up. For example, the opioid crisis in America is very different from drug use in Portugal. Do opioids in America kil
72.
▲
by
zac23or
3y ago
In headache case, the link between illness and cure is instantaneous. But when it comes to vaccination, due to the time needed for everything to take effect (many people need to be vaccinated, it takes time) anti-vaccines are unable to link
73.
▲
by
zac23or
3y ago
This explains anti-vaxxers beautifully. If everyone is vaccinated and the disease disappears (and kills few people) anti-vaxxers think: “why do we vaccinate everyone? The disease didn't kill anyone... and it disappeared."
74.
▲
by
zac23or
3y ago
> But to lump "meetings" and "metrics" into a "hated" category is the mark of an immature dev To me, these things are normal occurrences in organizational theater. I ignore that. But after sitting in a few 1
75.
▲
by
zac23or
3y ago
“Jira is brilliant” I've never read that sentence before! My feeling is... developers hate Jira, managers love Jira. And that is expected. The tendency is for things loved by managers to be hated by developers, such as meetings, metric
76.
▲
by
zac23or
3y ago
The reason for the poor view of the NH community (outside NH) is clear from the opinions expressed here. From defending Amazon's right to pay low wages to “it's easy, just quit” demonstrates the disconnection of NH people with rea
77.
▲
by
zac23or
3y ago
Tim Cook, it's been a long time since I've seen you comment here.
78.
▲
by
zac23or
3y ago
Scrum is not the problem. I worked with waterfall, Scrum, Extreme Go Horse, etc. All the methodologies I was forced to work on basically didn't work, all the methodologies are just a play of “business theater”. Someone with the power t
79.
▲
by
zac23or
3y ago
Google needs some people to resign in addition to those who were fired. Closing the daycare will work perfectly. That's how psychopaths think. Do not fool yourself. Google has been the enemy of innovation for some time, losing good dev
80.
▲
by
zac23or
3y ago
Someone forgot to add a distinct in the SQL query.
81.
▲
by
zac23or
3y ago
In my experience, status pages are useless.
82.
▲
by
zac23or
3y ago
The problem is... the English accents are endless! I gave up on improving my understanding of English after watching a video of the Liverpool English accent... at some point the girl uses the R sound instead of the K sound. https:/&#x
83.
▲
Injust Games
(godsandlegions.com)
1 points
by
zac23or
3y ago
|
0 comments
84.
▲
by
zac23or
3y ago
When Google created Chrome, some people were very happy! "It's the end of Microsoft's monopoly." The monopoly has been successfully changed ... to another monopoly!
85.
▲
by
zac23or
3y ago
In my experience, 100% of the time, the use of NoSql (excluding Redis) has nothing to do with the RDBS not being good enough, rather its "solves" another non-technical issue. Examples: 1. In one case, developers hate DBAs and Mong
86.
▲
Interview with an Agile Coach – Sprint2 [video]
(youtube.com)
1 points
by
zac23or
3y ago
|
0 comments
87.
▲
by
zac23or
3y ago
A few years ago, working on a comment team, I created a function to do an AB test using an AB test team system. Someone else does the implantation, not me. Someone didn't like the function, as they didn't use the company's ca
88.
▲
by
zac23or
3y ago
I tried watching some American talk shows. On some talk shows, every minute is an advertisement. In addition to the normal commercials, the interviewee is usually selling something. And the host (Jimmy Fallon is the worst) is always trying
89.
▲
Saudade
(en.wikipedia.org)
1 points
by
zac23or
3y ago
|
0 comments
90.
▲
Zelda: Tears of the Kingdom was basically finished before its year-long delay
(gamesradar.com)
2 points
by
zac23or
3y ago
|
0 comments
More ›