Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
piaste
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
71 ms
·
751.
▲
by
piaste
7y ago
We're not talking about some absolute, metaphysical "safe strings" that guard against every possible flaw, but rather about better supporting an already existing safety check. If you never thought to write an escaping funct
752.
▲
by
piaste
7y ago
This is the one I use too. Tiny difference - I write select * -- delete from sales where customer = 1 so it's even harder to accidentally highlight the 'delete' part. Although I've switched to DBeaver for a
753.
▲
by
piaste
7y ago
Who will provide a guarantee that the caches are truly transparent and will not trigger any new bugs? Essentially, you would need to prove the statement "if a system works well with caches off, then it works well with caches on" t
754.
▲
by
piaste
7y ago
> If the behavior of search engine selection ends up exactly the same in Google-owned Android and in the best-case scenario for an independent Android, where's the problem? Do you really not see a difference between a company making
755.
▲
by
piaste
7y ago
I know mine by heart and I still get mildly surprised reactions every now and then when I give it to an office worker.
756.
▲
by
piaste
7y ago
Sweden's personnummer system is much more elegant - your code is your date of birth followed by a 4-digit unique identifier. Everybody knows their personnummer by heart, while in Italy most people carry their health card around with th
757.
▲
by
piaste
7y ago
The best experience I know of in this regard is from some packages in ML languages, where the string literal query you write gets sent _at compile time_ to a database engine for parsing, using the database's API to determine the query&
758.
▲
by
piaste
7y ago
I would format that as either: var myvar = foo < bar ? bar : bar < baz ? baz : 0 or: var myvar = foo < bar ? bar : bar < baz ? baz : 0
759.
▲
by
piaste
7y ago
Adtech ought to die. Ideally, I would want to pay for Google and Facebook the same way I pay for Netflix and Spotify. In exchange, I would want them to treat the data about what I do online with the same respect with which my doctor treats
760.
▲
by
piaste
7y ago
> We can all read our own code Six-months-ago-myself thought so as well. Turns out six-months-ago-myself is a goddamn moron.
761.
▲
by
piaste
7y ago
> You could say that hash is a very aggressive, lossy compression. You could but it would be about as misleading as a sentence could possibly be. The purpose of compression is to preserve content as much as possible: similar inputs shoul
762.
▲
by
piaste
8y ago
> contrary to common understanding, it is perfectly valid for more than 50% of people to be above average. Average != median For this kind of question ('is X above/below average?'), however, I would expect that people are
763.
▲
by
piaste
8y ago
There's no right that tech giants need to be allowed to exist in their current form, either. If a person doesn't break any pre-existing laws, then they must not suffer any legal consequences, sure. And nobody is suggesting that
764.
▲
by
piaste
8y ago
AKA the CCleaner clause. Did Piriform get sued over that incident? Although as TablePlus worded it, it comes across like they want to be able to intentionally add malware to their software and get away with it. I'm no lawyer so I
765.
▲
by
piaste
8y ago
> She's in the spotlight because she's an amazingly accomplished person. I refuse to believe that you honestly believe that. 54-year-old black women from the South Side of Chicago who go to Princeton occasionally get an intervi
766.
▲
by
piaste
8y ago
> In Paris I once saw an original print of Marie Curie's book on radioactivity, where her name is given as "Mme Pierre Curie". This probably shows how difficult it was even then to get something published under your own na
767.
▲
by
piaste
8y ago
In regular .NET you can instantiate generic types with a type parameter provided at runtime. Of course it's not something you should ever do in regular code, but it can be useful for deserialization and stuff like that, so you can crea
768.
▲
by
piaste
8y ago
> Except that Option<T> is a class not a struct There is ValueOption<T> now. It's a mouthful and you'll still have to deal with all the standard library, or other third-party libraries, which produces and consumes O
769.
▲
by
piaste
8y ago
https://fable.io/repl/ This is a F# -> Javascript compiler and environment, itself running in your browser (in Javascript, obviously). https://github.com/kjnilsson/fez This is a project running
770.
▲
by
piaste
8y ago
> A small sidenote: chats are shitty concept in general. They have had a reason in a past era when voice coms are expensive and limited, they have a reason in terminals to broadcast few messages, no more. Not at all. Voice chat is synchr
771.
▲
by
piaste
8y ago
A different, more offbeat sort of rebuttal: http://slatestarcodex.com/2017/04/01/g-k-chesterton-on-ai-ri... (Previous HN discussion: https://news.ycombinator.com/item?id=14017361 )
772.
▲
by
piaste
8y ago
The .NET Core runtime (for a specific platform) can be bundled with the application so the user doesn't need to install it, and every application can ship with the exact version it prefers. This wasn't possible with the .NET Frame
773.
▲
by
piaste
8y ago
More generally, statements should appear in the same order as they are executed, as far as this is possible. This nullifies some other common sources of confusion, such as which statements are executed before a GROUP BY and which ones after
774.
▲
by
piaste
8y ago
> There is no world where it makes more sense to write a copy of everything you do into an "everything I did" table, than it does to use an append-only / immutable / log-centric DBMS (where "Postgres with an ETL
775.
▲
by
piaste
8y ago
Two words: child rearing. Imagine if every pair of prospective parents had a couple dozen more hours available per week, because they don't need to spend more time at the office than what is actually needed to do real work. Parental en
776.
▲
by
piaste
8y ago
Almost certainly intentional. Caplan is very close to the rationalist community, and rationalists quickly embraced his idea of the ITT - and occasionally ran public ones: http://www.patheos.com/blogs/unequallyyoked/
777.
▲
by
piaste
8y ago
> There's a term for this but I forgot what it is and don't care to go spelunking to find it. Happy path?
778.
▲
by
piaste
8y ago
Really? HN is the only website I frequent where there is any significant opposition to the GDPR. All social media I frequent, all general-interested news sites I read are universally happy about a crackdown on ads and personal data sell
779.
▲
by
piaste
8y ago
> The fact that they pulled it of to break into not one, but two of those secrets is extremely impressive on it's own. Did they break into them? Stuxnet had government backing, most articles I've read assume American or Israe
780.
▲
by
piaste
8y ago
I've had it happen once, sort of, on a relatively small collection. Several seconds' delay due to the use of foreach, that were actually annoying production users. The issue was that the collection being iterated over was a non-ge
More ›