lostjohnny
Joined 8 years ago
Joined 8 years ago
OR, another way to look at it, using MongoDB's ORM, which is quite bad if you ask me.
That query is not my invention, it comes directly from MongoDB documentation
If it looks bad, it means it is bad by design
https://docs.mongodb.com/manual/reference/operator/aggregati...
seriuosly?
db.orders.aggregate([
{
$lookup:
{
from: "warehouses",
let: { order_item: "$item", order_qty: "$ordered" },
pipeline: [
{ $match:
{ $expr:
{ $and:
[
{ $eq: [ "$stock_item", "$$order_item" ] },
{ $gte: [ "$instock", "$$order_qty" ] }
]
}
}
},
{ $project: { stock_item: 0, _id: 0 } }
],
as: "stockdata"
}
}
])
VS SELECT *, stockdata
FROM orders
WHERE stockdata IN (SELECT warehouse, instock
FROM warehouses
WHERE stock_item= orders.item
AND instock >= orders.ordered );Maybe it's about stereotypes still very strong against southern Europeans?
For example stop shadow banning people without warnings, make dead posts always visible but with disabled comments, unless vouched for, make moderation visible, I would like to know why something disappeared, create public spaces to resolve disputes between moderators and users: it's easy to misunderstand something when you are from 1% SV and the other person is from a developing country, for example, moderators are wrong too, hiding mistakes is not de-escalation.
Last but not least, changing the rules around "you're posting too fast" I share my public network connection (and public IP) with tens of other people and usually can't comment because it says I'm posting too fast.
Someone could be very frustrated by this behavior and become increasingly angry, this is not good de-escalation either.
I've never seen an "I've made a mistake" here on HN for example
or Franco and the regime of the colonels in Greece, because dictatorship is not a communist's only trait, as US like to think.
But I think Putin is different
He s not crushing only his own people, like those dictators did, he acts like the leader of an international terrorist organization with full power over an entire nation resources (from energy to army, from media to industry) and when he's not directly in charge, he puts one of his puppets there, changing the constitution or bending the law if he needs it, and that's why I think he's more dangerous.
Putin is a Trump who made it.
That's not been true since the 80s.
You're probably confused by the fact that some services shut down at lunch time (service facing offices like banks) for historical reason, we in Italy have a very rigid system of contracts that regulate each category of work in a very precis way, including work hours.
If banks want to stay open at lunch time, they'll have to change the national contract.
But if you go to an hospital or a bar or a restaurant or an IKEA branch, you'll find people working hard even at lunch time.
Source: born, raised and still living in Italy since 43 years ago.
> How do you get anything done??
I don't know, maybe We are smarter than the rest of the World... :)
Getting things done is not about the time you put in them, it's about the effort.
And I live in Italy.
They are not as strong as you think then.
In countries where there are strong work protections law striking is a right, you don't get paid for the time you don't show up at work but you can obviously convince an entire department or an entire company workforce to go on strike, without consequences.
Without it the protection is not strong, it means an entire company against the individual worker, which is obviously unfair (regardless of what you think about work protections law, Google against a single human being it's an unfair battle, that's why "strong protection" means that the worker deson't have to fight alone and can call other workers to join the fight).