why-el

Do you feel the same with food that is both sugar and fiber, such as fruits? My understanding is that the fiber slows down the metabolism, and thus the sugar is processed much slower.

I think both you and the parent post are correct. I heard similar advice playing soccer: when you drink water during a game, what you usually do is drink it fast (and in a hand wavy way where the bottle is in the air). So the speed allows for more water and air, and thus you feel cramps. If you were to drink it slowly, which will reduce the air most likely, then you have less risk, but as a kid playing soccer, the urge to go back to the field is is too great. :)

You can just ask them if they read it in your one-on-ones or in a direct email/Slack/whatever? Instead of tracking their habits?

Wonderful. Also note that psql can store settings in `~/.psqlrc`, so you can set settings there that survive sessions. For instance, in that file, you can have:

```

-- Extended display when it makes sense.

\x auto

-- Always time.

\timing

```

I also set `application_name` there. This lets others know I am connected.

GA (General Availability) just meant out of "Beta". If you don't see "Beta", you can assume GA unless they word things a bit weirdly and not mention "Beta" but a synonym, such a "limited availability". Just be careful and read the full page, which seems like it's your habit anyway. :)

It is probably just title bait as you said. An 8 time rejection seems extreme to me, usually it gets harder after a rejection by a consular officer, not easier, so my own speculative, possibly needless guess (having gone through my fair share of these across many countries including the US) is that his initial applications failed for bureaucratic reasons (like a missing document), not because it was a consular decision (i.e. the consular refused him and stated a reason for denial).

Nothing in core, but there are products that have good online karma (at least I haven't read horror stories, the lack of which is always good news). See https://en.wikipedia.org/wiki/Multi-master_replication#Postg... for some examples.

probably IP rotation by the ISP?

Edit: saw your Edit. :)

I think you are correct. I do everything personal in org-mode, but I switch to manual if the doc ends up being shared. Heck, I even elect to use google doc if I have at least one collaborator.

I suppose this is an ode to the famous "enough monkeys will write Hamlet?"[1] :p

[1] https://en.wikipedia.org/wiki/Infinite_monkey_theorem

I think this definition of success can be quite entrapping. Certainly, the pool of outstanding developers that do not fit these criteria is huge (in fact, the absolute dominant one, considering how narrow the definition is). As such, if you are a young developer, examine whether this definition suits your career aspirations (it seems to do so for author, which is OK of course), and know that there are many roads to "success".

I used to think the same thing for the better part of my 20s, but not anymore. I am also virtually non-existent online (in the author's sense), but I am quite satisfied with my career. I am of course one data point, but I have many colleagues and ex-colleagues in the same boat.

I didn't look into this one yet besides the home page, but I always thought Postgres would make a killer backend for ActiveJob, leveraging advisory locks for synchronizing jobs and such. Resque is Redis backed, but if you don't want to add that as a dependency and already have Postgres setup, then this would be a great fit.

You can also disable seq_scan and force pg to consider indexes, usually that's enough.

Note that AR's `explain` actually runs the query (effectively an explain analyze). This might or might not matter depends on what you are trying to achieve.

> and I hate how it creates this expectation that I’m online 24/7

Can't you just log off after 5?

Rob Pike discusses similar points in this section of his talk on Go Proverbs https://www.youtube.com/watch?v=PAAkCSZUG1c&t=9m28s.

I don't know why Aha! are being downvoted. I interviewed with them about a year ago and it seems like a wonderful company to work at based on that interview experience.

Are you sure this is not David Brent from The Office?

The logic is not poor at all, for quite mundane reasons. Giving up water will kill you, while giving up caffeine for enough time means it is no longer needed (and it is also, quite obviously, not needed for people who don't drink it already).

The deepemoji one is fooled by "was my flight delayed? no.". I feel for the computer when it meets that one "do I speak in questions?" person. chuckles.

On a more serious note, Hinton and other alluded to the need to restructure NLP studies as to focus more on the nature of recursion within language, which is basically what Chomsky has been saying for decades. It's interesting to see whether they converge.

Even more elementary that sibling comments, this also happens in gaming all the time. You are recording live results, say in Fifa, but if you unplug your device, your results are gone, since they were memory only. The game simply cannot afford to write to disk, the write is "non guaranteed" in the true sense of the word, but it is fast.

You then "checkpoint" when the game is over.

You might dissent that is not a "non-guaranted" write, because in fact the write did occur, but I simply want to allude to the concept of a "non-secured" write, in that it vanished without an fsync.

Yep, that's the one. Thanks.

You could, of course. But that would mean that you are effectively not using json anymore. You need to pull the data out of your json on each write, update in two places, and so on. And if you need to delete a json column, what do you do with the other one? You need to delete it also. You are then managing two things.

There is always a trade off. If the column is important enough, then you are right, it should stand on its own, but then you lose the json flexibility. I personally almost always only use jsonb if I know I only care about that overall object as a whole, and rarely need to poke around to find an exact value. As a the grandparent comment mentions, if you do need a particular value, then it might be slower if your JSON records are too different (if you think about it, how can you calculate selectivity stats on a value if you have no idea how wide or different JSON records are?).

Yep, I think (with 90% certainty) that Richard Hipp, the creator of SQLite, mentioned this in a Youtube Talk, but sadly I can't recall which one. :(

One of the great things one can learn from SQLite is the degree to which they unit (and integration) test their source code. It's honestly the best unit test document I have read in my career to date: https://www.sqlite.org/testing.html.

I was not commenting on whether one should use it or not, just that it is still used and picked as recently as Java 8. We are in agreement for the rest of your post. :+1:

The Postgres documentation on btrees is absolutely stellar if you can afford some extended time to study it [1]. From there you can read the actual code or watch some videos on how Postgresql indexes use them. You can even dump indexes locally to see their content! from root all the way to the leaf nodes [2] (this assuming you read and understood the above).

[1] https://github.com/postgres/postgres/tree/master/src/backend...

[2] https://www.postgresql.org/docs/10/pageinspect.html

> Nowadays even red-black trees aren't favored due to practical concerns like caches

Not sure if that's true. In addition to the main linux trunk using them, Java 8 included them also as an improvement to their HashMap (I found this by googling), so I don't they are not favored anymore.

Edit: language.

Reminds me of another great, Brazilian footballer Socrates, who was also a doctor: https://en.wikipedia.org/wiki/S%C3%B3crates#Personal_life.

TransferWise customer for over 5 years now, they are the best in the market.