mping

Performance, I guess. Also, a schema. Eg json has schema but most apis I know don't use json schemas.

Just read it as 1st or 2nd semester. Works in all hemispheres

Bear in mind that CTEs act as an optimization fence, so the filter (rn=1) wont be pushed to the CTE. The CTE will be materialized and only then the filter will be applied. I believe pg12 will change this behaviour.

This update will be welcomed. We use alot of CTEs for clarity of coding, building a kind of pipeline (think pipeline operator like in elixir). Sometimes we end up repeating filters just for sake of optimization.

Doesn't really apply because you need a good physical condition to be better at sports (besides knowing how the sports work), an ethicist doesn't need anything to be more ethical.

If the engineers have a track record/pedigree of previous employment (eg kernel maintainer, ex googler, etc), it can be used as a proxy. Same for open source contributions.

Good scores on the Joel test normally correlate with a mature engineering team IMHO (https://www.joelonsoftware.com/2000/08/09/the-joel-test-12-s...). The reverse may not be true. Just asked the team how they score on the Joel test.

Also, if the churn is high something is probably bad. Ask around why the last developers quit.

Bear in mind it's very hard to gauge from the outside, even for an engineer.

If you are specifically asking about unit tests and not testing in general, they don't save my day as much as give me confidence that my code is working as it is supposed, specially at the edge cases. I'm not a fan of mocking alot of stuff because it takes time to maintain, so in general terms I prefer testing higher in the pyramid (eg integration testing).

As for saving the day, I find that they are very helpful with refactoring, specially in dynamic languages. When the business rules change, first thing I do is rewrite the test, the just make it pass.

Feel free to downvote, but please present counterarguments so everyone can learn.

Rails is fine but didn't age well, specially the lack of strong functional programming support. Other nag is that it's hard to not do things the rails way - this monoculture reinforces the appearance that is fine because people looking to do something different just don't use rails. And when you "scale" rails is not really rails that scales as much as it is the architecture - it could be applied to other frameworks. Still if you are familiar you can write stuff really quickly.

Most of the time you use a wrapper that someone wrote and forget about it. If it's a itch you write your own.

Curiously, lots of wrappers are 1-4 years old and still work out of the box, which is a contrast with some other packages from other ecosystems (ahem node/js)

Correct me if I am wrong, but don't FaunaDB and CockroachDb implement strong consistency? I don't think they use CRDTs but maybe I'm wrong. I'm just a curious guy, by any means an expert

Ha! I did a webapp just for tagging observation videos. This is for my SO college students, they were doing it in excel. It's a big headache for maintenance, but it probably saved her students alot of time

There are niche apps that do it but they charge a high fee to the college. Case you are wondering:

https://observideo.com

Indeed; don't forget the follower databases (read replicas that can be upgraded to master).

It seems you hit a nerve with some users here. I have to say I agree with what you said, it's really simple. If anybody asked "do you wanna contribute to suffering"? If you answer no then basically you should either go ahead and do it or turn a blind eye.

There is an ethical angle you missed: no animal wants to die, with or without torture. I am vegetarian mostly because I chose not to contribute to the death of any animal, if I have alternatives. Yes, death is unavoidable but it doesn't mean it should be encouraged.

And your point 2 is discounting the animals that died to produce the food that cows and such eat. Besides, personally not all animals are equal to me. When I drive I squash insects, and if I would hit a dog I would feel worse.

In the videos, there's the Actions Per Minute metrics for both the AI and human players. AI average should be around 100, the human is much higher (300 or so) - although it's still apples to oranges, at least the AI isn't going full throttle on the APMs.

Datagrip looks ugly on my gnome3 with 4k and 2.0 scaling. Fonts are way small. Also, it's a bit on the heavy side.

For linux, dbeaver is the least ugly thing I found. DataGrip looks ugly in 4k with 2.0 scaling, and I dont like the electron based GUIs. Looks like heidi is windows-only, will check with wine.

Don't forget they track you in very ingenious ways, effectively eroding your privacy.

What makes you think that mental fortitude is not required for physical toughness? You got it backwards, it's the mind that says the body to quit.

Do harder things progressively. Personally I recommend a certain style of Chan meditation, but its not easy to stick to its training plan. To bootstrap, the easy way is to do it in group so you don't quit - MMA, stoicism whatever is OK but there is much more to mental toughness than that imho.

That's pretty cool! You implemented HLL and TDigest on top of FDB? Or are you storing some kind of blob and computing server-side? I did something similar for Hadoop and MonetDB a long time ago

You sound like you are playing your own advocate. People can find lots of ways to justify themselves. In the end, you know it brings suffering - you either go with it or not. The rest is just mental blabber.

The same reason people choose not to eat meat is the same reason some people choose not to rob someone or to treat someone kindly, etc - they see it as a good thing and they do it. And if I am aware and can avoid stepping on ants I will do it.

A probabilistic data structure comes to mind, such as Q-Digest. I wonder why it isn't used more for these kinds of problems

I have seen research in this problem area, where one is capable of knowing ahead if the query is legit or not. Anyway for internal purposes it's fine

Can you point that you had with spec? Isn't it a burden to define specs for everything?

Installed brave on Linux, the autocomplete is sluggishly slow which I guess is due to history search but makes it completely unusable. There's an open issue for that, but I wished they didn't market it with such a critical bug.

Always work with people smarter than you. Ethics are important. Don't stop trying to improve. There is money to be made in every IT area, follow what you like and you wont be poor or unhappy. Respect others' work no matter how crappy, specially open source/free work.

$50 gets you 25Gb according to their pricing page.

Agreed, it's not about the tools, but the process. I've worked with different agile coaches - most of them were crap, but one of them really struck a chord in how he would find flaws on the organisation that would reflect on the software side. He was really good at devising strategies to overcome this.

To address the specific question, I think most of the time there's a problem because there is no one that takes care of making sure everyone has the same vision and understanding of what needs to be done. And because sometimes words fail us, I think mockups are a great way of uncovering and sharing requirements.

Actually the JVM is one of the reasons I would recommend clojure. It's a fine piece of engineering; much more solid than most VMs out there. Lots of tools for perf/monitoring/debugging.

Why would you require an existing C lib? These days you have lots of JVM apps doing heavy lifting: from bigdata stuff (hadoop, presto, kafka, others) to webapp stuff (undertow, check techempower benchmarks). For those special cases you can wrap a C lib with FFI, but in my 10+ years of JVM experience I only needed to do it once, and it was because I was streaming video on a jnlp (java swing/java web start) app which worked remarkably well, considering I supported windows,linux and mac.