Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
paperplatter
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
7 ms
·
61.
▲
by
paperplatter
2y ago
Keeping employees they don't need/want is an inefficiency.
62.
▲
by
paperplatter
2y ago
Ok, I still doubt they have a better idea about that. Plenty of outsiders know more about my workplace than I do simply because they bothered researching, and the internal comms are more a distraction than actually juicy.
63.
▲
by
paperplatter
2y ago
I doubt the SWEs have useful insider info at a company of this size.
64.
▲
by
paperplatter
2y ago
This is a distinction without difference.
65.
▲
by
paperplatter
2y ago
Probably means someone who thinks there's a moral obligation to follow a union-requested boycott.
66.
▲
by
paperplatter
2y ago
Yes being gay is illegal in some countries, but those governments don't have the ability to raid a German citizen's home for it.
67.
▲
by
paperplatter
2y ago
It's not even a shift, it's the original meaning. There are/were physical picket lines that you would literally cross to enter a business.
68.
▲
by
paperplatter
2y ago
There's no need to justify how you do business with the NYT, whether it's playing a crossword game or accepting a job. But either one is referred to as crossing the picket line.
69.
▲
by
paperplatter
2y ago
Postgres has it, but it didn't used to, and it's still got caveats. Beyond Postgres, indexing random values is fundamentally harder than indexing sorted ones, whether you've got a hashmap or btree or something else. The often
70.
▲
by
paperplatter
2y ago
Because we keep telling people the opposite in academic settings, where the pkey is usually some actual data field(s) you expect to be unique. There's some point to teaching 3NF this way, but it shouldn't be taken literally.
71.
▲
by
paperplatter
2y ago
Yes, if a client gives a UUID and you want to look up relations to that table, you'll have to join with that table. And the index on the UUID has its own costs. It's still better this way. If for some rare reason this join is too
72.
▲
by
paperplatter
2y ago
It's not just about the data size. There are reasons your sequence can increment without a row actually being inserted.
73.
▲
by
paperplatter
2y ago
Yeah, Spanner is also clear about this. It doesn't even have sequences, and their docs say to use random pkeys rather than time-dependent things like uuid7.
74.
▲
by
paperplatter
2y ago
Whenever I write a backend, it's a thin layer on top of the RDBMS like you said. I don't know if a lib or framework could help with this. It's more about designing the schema well, avoiding excessive tooling (ORMs, query buil
75.
▲
by
paperplatter
2y ago
I feel that. Postgres has dump/restore at least, though that's less portable than a unit testing fake. And the thing I use at work lacks a dump/restore feature somehow :/
76.
▲
by
paperplatter
2y ago
Right, I know at least 3P apps get the "memory warning" and have specific rules about background execution, but wasn't sure about Safari since it's special.
77.
▲
by
paperplatter
2y ago
If you're doing very basic things, the same exact syntax will probably work on multiple. But even then, implementation details like isolation level come into play.
78.
▲
by
paperplatter
2y ago
Because RDBMSes are still an unsolved problem, and new features keep coming along that are actually very useful but not easy to standardize.
79.
▲
by
paperplatter
2y ago
Last time I used a query builder, I accidentally used its orderBy in some invalid way that it didn't complain about. Just silently didn't ORDER BY the cols I wanted.
80.
▲
by
paperplatter
2y ago
Maybe they're use Google AppEngine and don't want to deal with storing config secrets the right way for it.
81.
▲
by
paperplatter
2y ago
I prefer just using SQL without the query builder. If I'm ever concerned about type safety, I could wrap it in a function. Guess this tool does it for you, but separating your queries into .sql files seems like more effort.
82.
▲
by
paperplatter
2y ago
Should be theoretically possible via swap. Like, my MacBook can have a thousand browser tabs open without reloading any of them, and I'm sure it doesn't all sit in physical RAM. Is your phone low on storage, or are iPhones just le
83.
▲
by
paperplatter
2y ago
Yeah, on an iPhone 12. Once you enable FaceID, the option to require passcode only after X minutes is removed, leaving only "immediately," which makes it a lot more important for FaceID to work reliably. It fails more often than T
84.
▲
by
paperplatter
2y ago
It's weird how they pick unrealistic use cases when there are real ones. Last week I saw a nice plant and wanted to buy the same one, so I used Google's image recognition feature.
85.
▲
by
paperplatter
2y ago
Yeah but unfortunately I really needed more space than what I bought, and I figure at some point my cell carrier will drop support like they did with my 5. Also the 6S has that infamous battery design flaw. So the battery repair cost is som
86.
▲
by
paperplatter
2y ago
The notch is ok, but FaceID is a downgrade, and so is not having a home button or a headphone jack.
87.
▲
by
paperplatter
2y ago
I'm just glad it makes the slightly less new ones a bit cheaper. My iPhone 6S needs to either get a new battery or get replaced.
88.
▲
by
paperplatter
2y ago
I know it's algorithmic, not manual, but the "Armenian folk" one plays Persian language music.