If you use Alternate Player for Twitch DDG privacy extension was preventing it from connecting with twitch servers and lose quite a bit functionality as you would always stay logged out. Not sure why it was doing that, but just a PSA regarding same extension
I think the issue with these massive scale apps is that people want better and fresher features which are not always well defined and get lost in the maze of product development of a huge company. They have to make decisions, do we go with web3 stuff or do we improve current NLP system etc etc. Making decisions is much easier for a small startup than a behemoth of twitters size. And yes, it takes many people. 1000 engineers? Maybe not, bloat has set in at that point, but a few hundred for sure.
With a lot of young people opting out of having kids and trying to find their own way in life, it would make sense that the anti-work and anti-hustler culture is much more prevalent in younger people (millenials being first). Its a generational shift first of all driven by oncoming climate disaster due to over population and will be felt through wars and hungers. Why should young people contribute to such a society and create more suffering in the process.
I am not an anti-natalist, but if we start talking multi-generational that's what it comes down to
Not a fan since proposal would do an implicit join on foreign keys rather than explicit join on the columns. If you know the schemas its great, but would add an extra step to check FKs on the tables otherwise
This is why we don't use `*` in production SQL. It's also why we try to avoid NATURAL JOIN. USING is OK if you only have two table sources, but you don't always get to have same-name columns on both tables.
This syntax seems pretty clear and explicit, but with an indirection. Indirection != implicit. The intent is quite explicit.
Using ON also is problematic in that you might think while reading a query that the JOIN is on FOREIGN KEY columns, but... maybe not -- without looking at the schema, you can't tell. JOIN FOREIGN has a similar problem: the intent is crystal clear, but now you have to go look at the schema if you want to know which columns that refers to. Normally one would write a comment on the ON, but comments can rot.
Now, making SQL more expressive isn't necessarily a good thing. SQL is already very expressive. But making it more expressive in ways that yield clearer queries is definitely worth considering.
One very nice aspect of JOIN FOREIGN is that because RDBMSes generally require corresponding indices on those columns to optimize ON UPDATE / ON DELETE constraint processing, seeing "JOIN FOREIGN" in a query instantly lets you know that there must be an appropriate index, while ON might be causing a full table scan or query materialization and you'd have to examine the query plan carefully.
> rewriting a repository to use a ORM, jOOQ in this particular case with Java8
> spend two weeks on this, write extremely meticulous tests, I am a junior/mid level engineer at this point in my career and this is a game changing ticket
> day of the switch approaches, sweating bullets
> switch happens, so far so good
> This was for a food delivery company so the volume of orders changes throughout the day (lunch, dinner, evening etc)
> at lunch time orders suddenly start disappearing, but eventually over time things go back to normal
> goes on like this for hours, at least a few
> tech team is confused ... why are these orders disappearing into nowhere
> senior engineer is suspicious and reviews my PR from the night before
> I forgot to remove `LIMIT 100` on the GET /order query when I was testing
You would be surprised how much bacteria can grow on fabric after an 8 hour workday assuming you have a customer facing job and need to wear a mask all day
Except the politicians will take that extra tax money and use it to bail out banks and wall street and spend it on shit that no one needs and impose policies that no one cares about and continue the corruption cycle, only now with a lot more money than they had before. We should trust the government a lot less, not more, with our hard earned dollars.
Greed is part of the human nature, and people in the government are no exception.
