AtNightWeCode

5 ms·

181.
by AtNightWeCode 2y ago
If you use it in the same way you use trailing commas. Fair. But the site says to make it easier to add dynamic conditions. Which is a terrible idea in maybe not all but many SQL engines.
182.
by AtNightWeCode 2y ago
Which is exactly what the site says. To insert dynamic conditions. I know that you can use 1=1 for the same reasons as trailing commas. But kinda obvious that this is not the case here.
183.
by AtNightWeCode 2y ago
Yes. "Use a dummy value in the WHERE clause so you can dynamically add and remove conditions with ease:" I don't know how to read this in another way.
184.
by AtNightWeCode 2y ago
In this case. A query that you build by adding different strings. 1=1 is for adding AND statements to the WHERE clause dynamically. In your code. I never seen it used for anything else. Adhoc is just the practice of running raw SQL queries.
185.
by AtNightWeCode 2y ago
Never use WHERE 1=1. It is both a security risk and a performance risk to run dynamic ad-hoc queries.
186.
by AtNightWeCode 2y ago
Maybe they could solve some of the core issues instead. It is like CF lost the source code and just pushing new more or less useless features all the time. Even though I think this is a fair change.
187.
by AtNightWeCode 2y ago
Different confs in the same repo. Many CI/CD tools will pick debug/dev conf by default if nothing else is set. It was just an example. Maybe they knew.
188.
by AtNightWeCode 2y ago
Could be as simple as no auth in debug builds and then deployed it by accident.
189.
by AtNightWeCode 2y ago
The exponent operator is just short for the POWER function in Excel. So from that perspective it is the correct behaviour I think even if it is mathematical incorrect.
190.
by AtNightWeCode 2y ago
For us, what QUIC solves is that mobile users that move around in the subway and so on are not getting these huge latency spikes. Which was one of our biggest complains.
191.
by AtNightWeCode 2y ago
Agreed. Another thing along the same path is expect. Needs to be disabled in many cloud services.
192.
by AtNightWeCode 2y ago
Some parts of Europe. But now when I looked it up the law was actually changed like 10 years ago. Damn I'm old.
193.
by AtNightWeCode 2y ago
Interesting. It is illegal in some western countries too to create your own maps. Another thing with maps is that online services have different maps depending on what country you access from.
194.
by AtNightWeCode 2y ago
But the entire API is an abstraction... So the benefits are: Audits Network/infra Time to market Single API Less code Risk (sometimes) The downside: 1. Slow or missing propagation of underlying features. 2. Hidden business logic. 3. Ri
195.
by AtNightWeCode 2y ago
Wow, that was a red pill. Everything suddenly makes sense. I always thought it only was machine learning that messed it up. How to replace Google as default search in your browsers (tested on Windows). Firefox -> Hamburger menu -> Set
196.
by AtNightWeCode 2y ago
Most benchmarks are wrong. I doubt this is correct. Final should have been the default in the lang I think though. There are tons of these suggestions. Like always using sealed in C# or never use private in Java.
197.
by AtNightWeCode 2y ago
My experience is that frontend devs mostly wants to write js and not css. The term they use for guys like the op is pixel pusher. Another annoying thing is when they use colors that are a bit different where is should be the same. For thing
198.
by AtNightWeCode 2y ago
NSA disagrees...
199.
by AtNightWeCode 2y ago
We recommend against ECDSA for internal accounts. I know several of our partners use it though. Hard to not be cynical about this even though this issue seems mostly harmless.
200.
by AtNightWeCode 2y ago
I think it is a more general problem. One can't see in GIT what tools have been used to create and validate the code. It is impossible to use most modern devtools completely without AI. I think it is better to regulate the usage and en
201.
by AtNightWeCode 2y ago
The UX is an important part of the trick that cons peeps that these tools are better than they are. If you for instance instruct ChatGpt to only answer yes or no. It will feel like it is wrong much more often.
202.
by AtNightWeCode 2y ago
I have Blazor apps running on Cloudflare pages. They download fast and the performance is great. The load time is terrible though. I think it is unsolvable with .NET. I think the core issue is how everything is entangled by design in oo lan
203.
by AtNightWeCode 2y ago
Difficult but not impossible. Some of the malware and ransomeware stuff is also created by experts.
204.
by AtNightWeCode 2y ago
I think it is a professional attempt. It does not have to be a goverment. There are other cyber criminals.
205.
by AtNightWeCode 2y ago
No small artists cares about this at all. Grow up.
206.
by AtNightWeCode 2y ago
The 1k streams limit will probably only financially effect "artists" that spams the platform with new tracks. It is not like it will make any difference for real artists.
207.
by AtNightWeCode 2y ago
The history. Every time something like this attack happens people think they can read the complete git history in the repo.
208.
by AtNightWeCode 2y ago
People think git is immutable. It is not.
209.
by AtNightWeCode 2y ago
My guess is that a ransomware group is behind this. Even if the backdoor had gone into production servers it would have been found fairly quickly if used at some scale.
210.
by AtNightWeCode 2y ago
Humans can always be compromised. This specific case can only be solved by improved tooling, workflows, visibility, runtime environments and so on.

More ›