Yes.
>> ensuring the only people using it are the people who want it really badly
Not necessarily. People using it could just have more money.
61 karma · joined September 23, 2021
Yes.
>> ensuring the only people using it are the people who want it really badly
Not necessarily. People using it could just have more money.
It does help. Quite a bit.
Each layer (e.g. firewall rules that require that all internet access go through a proxy), adds non-trivial amount of work for the hacker to get anything useful done.
1. best case - hacker will give up.
2. good case - you have more time to notice and react.
How much layer cost you, how much does it cost for hacker to overcome it.
Things to remember:
1. Not all hackers are nation states. Most are not.
2. We must accept that no security measure is absolute even against script kidies. Given enough time and luck/misfortune js sandbox will do "rm /sensitive/file".
Recent Log4shell example shows that one can follow all best practices and still get bit in unexpected way.
One can say that it makes you explicitly state, which foreign key do you use.
"on a.foo = b.bar" can be a incomplete and/or incorrect join condition.
I get that it is not common now to care about FKs when writing selects. But it could be. Tooling can be improved to help here. (show fks, autocomplete)
Btw. Everybody seems to concentrate on conciseness, but keep in mind that this helps also with query correctness.
> Other than saving some typing,
I would like to point out the corectness aspect of the proposal.
Today foreign keys are enforced during inserts, updates, deletes. (you just can't violate fk. this is so good) But you can violate it in selects. (e.g. mistype column name, forget to include a column)
This proposal (or its adjustment) would allow to use fk also during select. It's like static typing for join conditions.
Reducing verboseness is nice, but the main perk is the correctness.
Oh.. if I got a cent every time I found a bug in colleagues sql, because of join accidentally multiplying/doubling rows... :-)
postgre, seems to not have it, but the proposal could include also "disabled FK" part.
teradata, oracle, sql server already have option for FK "disable/no check".
https://docs.teradata.com/r/eWpPpcMoLGQcZEoyt5AjEg/df1PvVh6e... https://docs.microsoft.com/en-us/sql/relational-databases/ta... https://docs.oracle.com/cd/B28359_01/server.111/b28310/gener...
1. Societal issues. Microsoft wanted Java they could control and change. C# it is then. Google is moving away from java to kotlin, because of disagreements with Oracle.
2. Wish of different trade offs. fast-to-learn vs feature-full vs ease-of-use vs configurability vs portability vs speed vs safety vs developer friendly vs user friendly vs admin friendly vs development-speed vs program corectness.
3. Low proof-of-concept cost. If some lib involves lot of boilerplate for my usecase, it is easy to create my own improved version and feel the sense of achievement (my version might be just a wrapper at first, but the gate have opened)
4. Reduction-of-programing-worlds-complexity is at the bottom of everybodies priority lists.
Or is remnant from religious generation? (parents programm kids that doing good is right thing to do because God says so. Certain generation starts omitting "God says so" part)
> This may seem paradoxical, since atheists and agnostics have very low levels of religious commitment and yet score very well on the survey questions. However, atheists and agnostics account for a relatively small share of the total number of people with low levels of religious commitment; 4% of Americans describe themselves as atheists or agnostics, while fully 35% have low religious commitment. Atheists and agnostics answer an average of 20.9 questions correctly, compared with an average of 15.4 correct answers among people with low religious commitment who do not describe themselves as atheists or agnostics.
Btw survey questions them selfs are a bit nitpicky.. (who cares if jesus realy changed water into wine or if that was just symbolic)
Original article: https://www.pewforum.org/2010/09/28/u-s-religious-knowledge-...
I know whos influence on Serbia I would prefer. (for my self (eu) and for Serbia)
We'll need a peer reviewed article to believe that.
As I see it, if there are no emotions/emphaty then field of ethics has no use.