skysight-inc/HackerNews huggingface dataset:
> Real parameterized queries exist and can be had today

/s/today/30 years ago: SQL-92 describes them in chapter 4.18 - which at the time was just standardizing something almost all vendors already had in some form or another, for example, I'm pretty sure even the first release of ODBC in the late 1980s also had parameters.

Disclaimer: My pontifications below derive from my life's experiences starting with Access/JET Red as a sprog, to my current professional work with MS SQL Server, Postgres (and MySQL, I'll admit - but I'll say MariaDB instead) built over the past 17 years - but I have absolutely zero experience with Oracle and Db2, so I honestly don't know what cool language features they have (and they must be way ahead of the ISO spec, otherwise why else would people pay so much for it?... Hmm, then again, Oracle still doesn't have a bit/bool column type, does it?).

Anyway:

However, the expressiveness of parameters hasn't changed much since the original design of ODBCS - at least as far as I'm aware: Query parameters are still mere scalar value placeholders instead of hardcoding literals inside queries and statements: with limited exceptions like T-SQL's ceremony-laden table-valued-parameters and Postgre's array types, it's still not possible to parameterize database object identifiers or even have a true variadic `WHERE IN ( ... )` predicate without resorting to Dynamic-SQL, nor can we use parameters to conditionally enable or disable query predicate clauses: yet these are all essential features for any kind of ORM or language-integrated-query system built today (the canonical example being Linq/EF in .NET and TypeORM or Prisma for TypeScript/JS.

Why isn't anyone meaningfully advocating for a "SQL/2"? I know backwards-compatibility is 100% essential, but that's the easy part (because relational calculus and relational are isomorphisms, hence why semantic-preserving query translation between different SQL engines is a solved problem), but lack-of backwards-compatibility is usually the reason most good-ideas die in committee - so how come Google was successful in pushing HTTP/2 and even HTTP/3, but we're still using 1980s-level SMTP and SQL? Are all of the major RDBMS vendors so afraid of change that they're willing to forgoe winning-over millions of new customers if they can ship a usable, flexible, expressive, and safe query (and query-building) language?

I'm just blabbering at this point. Forgive me, but I need something to distract me from the outside world right now.
Movies are often shot with anamorphic lenses which are lenses with a sort of vertical cylinder shape. This lets wider aspect ratios be shot using the full frame of a more square aspect film or sensor.

https://www.bhphotovideo.com/explora/amp/video/buying-guide/...
You have deep experience with viruses, via your biology. Science knows very little about virology, if you learned nothing but that from the pandemic. Your intuition is actually quite strong, as your whole body is a fractal complex of nature itself.
You see this with appliances in general. Appliances are tools. They need to be maintained to some minimal degree and used properly.

I've rescued Dyson hand held vacuums where the only problem is that the previous owner forgot to give the removable filter a rinse. I see people shove plates in a dishwasher with food solids that end up caking on, or placing bowls upright so they rerun the cycle.
That’s 10% more steaks for me then.
The day will come when products with stickers saying things like "non-connected" or "non-smart" will sell more.
Yes, imagine, you only need to remember 12 words!
Yeah, you're right. The arms embargo started in the 60s but sanctions didn't really hit broad buy-in until the 80s.
> sleep above 9 hours is inversely correlated with negative health

So positively correlated with positive health?
You didn’t say anything about a state you talked about “an unwilling people”. States and peoples are different things.
Indeed. Interestingly, egg washing involves some tradeoffs. If they are washed, they are safe to handle but the cuticle is eroded so they must be refrigerated. Unwashed eggs can be kept unrefrigerated for some time, but the shells must be treated as a raw food item.
I don't think you read my original reply?
> Thankfully San Francisco was never turned into https://www.davidrumsey.com/luna/servlet/detail/RUMSEY~8~1~2...

I'm definately not one for more highways, but this map doesn't look _that_ different from SF today?
There's a chance that this triggers EU, NATO, and partner countries to ban or heavily regulate cryptocurrencies.
> Yes we should defend our allies in NATO as that's the agreement.

We had an agreement with Ukraine as well.

The Budapest Memorandum on Security Assurances comprises three identical political agreements signed at the OSCE conference in Budapest, Hungary on 5 December 1994 to provide security assurances by its signatories relating to the accession of Belarus, Kazakhstan and Ukraine to the Treaty on the Non-Proliferation of Nuclear Weapons (NPT). The memorandum was originally signed by three nuclear powers: the Russian Federation, the United Kingdom and the United States. China and France gave somewhat weaker individual assurances in separate documents.[1]

The memorandum included security assurances against threats or use of force against the territorial integrity or political independence of Ukraine, Belarus, and Kazakhstan. As a result of other agreements and the memorandum, between 1993 and 1996, Belarus, Kazakhstan and Ukraine gave up their nuclear weapons

Presumably if Ukraine still had those nuclear weapons they wouldn't be facing an invasion right now. If we fail to defend them, the lesson for every country is "Don't give up your nukes, because you're going to need them when you get invaded. And if you don't have nukes now, get them as soon as you can."

https://en.wikipedia.org/wiki/Budapest_Memorandum_on_Securit...
sqlite3 con.execute() appears to prepare and execute a statement, with bound parameters.
> if a road has over two lanes in each direction, the route is busy enough to sustain trains/light rail.

That's necessary, but not sufficient. Rail requires enough commonality or at least linearity of both source and destination. If it's an octopus on either end of said road, rail doesn't work.
I'm guessing that reporting car thefts to the police is a standard industry practice, I know that any such discrimination process carried out by humans has some nonzero probability of both type I and type II errors, and I'm amazed that the number of thefts they report is so low. The very low number of theft reports suggests to me that, despite the apparently ridiculously slipshod procedure described in the article, Hertz's process may actually be heavily biased in the direction of type II errors.

I'm not sure what you mean about ignoring calls. Why would I have any particular belief about police stations ignoring calls? Police stations ignoring calls isn't mentioned in the article or my comments. Is there a logical entailment from something I said that isn't obvious to me?
The technological case against Bitcoin and blockchain
0 links provided, point dismissed
I had to go bug people I knew who had worked on QuickTime frameworks BITD to get anything done when I worked at Apple the first time, in 2004. It's not and never has been simply an external problem.
That’s also true of a decent JS library. The problem here being that the library wasn’t decent.

A library in a strongly typed language would still need to use parameterised queries or escape the strings just like a JS library. And it would be just as easy or difficult to have an incorrect sanitising function.

In fact, the specified string is not invalid input, it would be perfectly valid to store backticks in a string field in MySQL. They just need to be correctly escaped before being submitted to the database.
Dead Hand “fail deadly” automated nuclear weapon launcher
> Well if everyone agrees to stay on their side of the line refugees wouldn't be an issue. Clearly some people want to walk over the line. Why do you think their wishes are less valid?

I think that because they want to enter the country of other people who have the fundamental human right to self-determination, i.e., how they are governed, including the administration of their borders.

> The main argument for your position boils down to "their ancestors had less military power, so they should live less desirable places". You can justify that with some logical systems, but not the one you're using (self-determination).

That's not the main argument for my position. If you don't believe people should have the right to self-determination, or at least that your wishes should override if they are unable to provide a reason that you deem sufficient or "logical" then fine. That's authoritarian though, and many more people would consider it immoral than those who consider self-determination (including borders) to be immoral.
What point was it that you think I disproved?
exactly lol
I love Matt Yglesias, but he is very savvy when it comes to riding the waves of Twitter interest.

I chalk this up to that; he’s seeing how interested people are, he wants to talk about it, but his most interesting take is marginally conspiratorial.

My reaction to this is, “Oh, Matt…” and moving on. I hope this doesn’t become his norm, and I really think he’s too grounded generally.
On the other hand, I hear stories that VA has difficulty hiring doctors in rural areas, and ends up hiring bad doctors who harm patients.
Gcc is doing the right thing. You can't blindly assume malloc() never fails. That is up there with assuming int is always 32-bit and painting yourself into a corner with unportable code.
You say that

1. Pigs and dogs frequently transmit diseases to humans.

2. SARS-CoV-2 was "very likely" carried to the Wuhan market by humans, since only humans are "known" to catch the virus among species present at the market.

I don't understand why you are so confident in #2 given #1? If animals frequently transmit diseases to humans, why would we assume this did not happen in the Wuhan market case? Have all species present at the market been exhaustively tested and proven not to contract or transmit the virus? That would be news to me. All I know is it's been reported that many species traded at the market are known to harbor coronaviruses.

And what exactly is your theory of the origin? Surely the virus came from somewhere, and didn't just suddenly appear in humans without a source?
Apple takes 0% of your Mac app sales, because virtually nobody distributes on the App Store.
I've always wondered if the fluorescent markers are visible to the fish and whether that might change their behaviour during experiments especially if it is a group interaction with other specimens who are not similarly modified.
That's an instance of the prisoner's dilemma though. They can't really arrest every single person who is against the war. They can't even arrest 1% of population - detention system can't handle that.
I agree. If we get to that point I feel like the world won't be worth living inside of.
It’s a common tactic, partly manipulative, to take advantage of moderate groups reluctant to condemn extremist groups aligned with them.

Think peaceful protestors refusing to condemn violence in their protests.
There’s absolutely a male equivalent. Almost every male “real estate professional” I know makes money mainly through nepotism.

They do tend to have the same thing in common: flashy IG posts and the constant refrain of “work hard, play hard”.
> You don't seem very open to changing your perspective, but if you care to peruse a subreddit dedicated to reporting defensive gun use in the news, it contains a ton of stories that you've likely never encountered[0].

Of course there are cases of defensive gun use. But there are also cases of idiotic gun use:

> Deputies with the Escambia County Sheriff’s Office arrested three people after one man was shot. Investigators said the shooting victim was shot after an argument about the victim’s alleged littering.

* https://www.wkrg.com/northwest-florida/escambia-county/man-s...

> Houston man accused of shooting restaurant workers over BBQ sauce

* https://www.click2houston.com/news/local/2022/02/26/houston-...

> A Utah father was taken into custody after police said he told his 4-year-old child to fire at officers following a dispute over an order at the McDonald's drive-thru in Midvale.

* https://kutv.com/news/local/suspect-in-custody-after-shootin...

Examples taken from:

* https://twitter.com/well_regulated_

Right across the US border Canada manages to have a safe society without everyone packing heat. And it's not like gun ownership is unheard of in Canada, given it's 7th in per capita ownership:

* https://en.wikipedia.org/wiki/Estimated_number_of_civilian_g...

For tracking mass shootings, the US has a separate Wikipedia page for each calendar year:

* https://en.wikipedia.org/wiki/List_of_mass_shootings_in_the_...

Meanwhile the list of massacres (not even all being shootings) fits on one page for Canada:

* https://en.wikipedia.org/wiki/List_of_massacres_in_Canada

The idea that firearms make one safer, either at home:

* https://www.acpjournals.org/doi/10.7326/M13-1301?articleid=1...

or in public:

* https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2759797/

does not seem to be borne out by the statistical data.
The Mayo Clinic started in the middle of no-where.
I'm in the UK, and suffering censorship of RT.COM by various western powers. Even using TOR (as I would in an oppressive dictatorship like the USA) is getting me nowhere.

I have deleted BBC news from all of my TVs in response, since it is the propaganda channel for the UK government.
seconded that your website copy doesnt do a very good job of telling me what it is you guys do. i have no idea who to send this to in my company whether its the sales person or customer success or PM or developer. just giving feedback that it needs work. i know this is hard. good luck.
Dramatiq is great.
Related: “Who Wrote The ‘Death Note’ Script?” – https://www.gwern.net/Death-Note-script
My parents used to buy a huge bag of potatoes that came in a brown paper bag.

https://www.newworld.co.nz/shop/product/5045696_ea_000nw?nam...

Like this but I believe it was 10kg
And kept in that bag in the pantry. They lasted forever (few months minimum).

The ones I would buy in Singapore were washed in clear bag I had to keep in the fridge that lasted like 2 weeks :(

Edit: bug > buy
In practice, this looks like Dugway Proving Grounds in Utah.
One would think that question would answer itself after reading it, and noting the various sections it has.
> I would give specific examples here but

but then people would be able to assess your claims based on the evidence, and your hyperbole might not work out?

You've alluded to discussions you claim to have had, and made claims about the people you argued with. (I bet I was one of them.) Are you able to at least link those?

Your repeated refusal to say what you're talking about gives the impression you're blowing smoke.
I grew up in and around Christian fundamentalists who believe precisely what the parent was referring to.

If you want to “not all Christians,” that’s fine - but Armageddon fetishists absolutely do exist in fundamentalist Christianity. Start with the “Left Behind” book series if you want an introduction to the way that group thinks.
How does it know you're wandering in and out of your lane?
America Was Wrong About Ethanol – Study Shows [video]
When they took Chernobyl, I almost expected him to have a Bond villain plot to use it for something that clearly wouldn't work in real life.
Yes. I hear you. And it's awful.
editors trying this on WP:RSP get reverted in short order
It’s a bit more complicated than that. First you need to dump the unencrypted app from its IPA (you can do this on an M1 Mac when SIP is enabled, or a jailbroken iOS device). Then, take the resulting IPA and resign it with a valid provisioning profile and you can then double-click to install it. I’ve been using Slack and Discord this way for months and apart from some minor bugs it’s a great experience.
> MasterCard/Visa cards issued in Russia will not work abroad, cards issued abroad will not work in Russia.

So it does nothing then. So russians will be able to use visa/mastercard within russia? They just won't be able to use it outside russia. And foreigners can't travel to russia and use visa/mastercard.

How many russians are going to travel to another country and use visa/mastercard in the near term? How many foreigners are going to travel to russia to use visa/mastercard in the near term? Now compare that to russians using visa/mastercard in russia. I'm guessing that's 99.99% of russians with visa/mastercard.

Just like with SWIFT "ban", it's all for show. The SWIFT ban doesn't affect russian banks tied to oil/gas trade. How convenient.
> OpenSearch is a registered trademark of Amazon Web Services.

Hidden away at the bottom of the page. It's too bad there isn't an Open Source License that protects smaller business from the tech Goliaths.
Perhaps, though I doubt it. Modern software may have more features and functions, accumulated over time, but what it so often lacks is a good way to encourage discoverability (and can make it much worse — e.g., the Office Ribbon) while making things work better through internal consistency (though that internal consistency was often at the expense of being applicable application-to-application). It's funny how much paid software is so much worse than FOSS options when it comes to actually using it — the FOSS stuff may not look as nice, but it does the job, gives more and better options, and has something resembling documentation. Old software is much closer to FOSS tools than modern paid software in spirit, and much has been lost in the quest for paid-but-cheap.
It's sad that it's virtually impossible to find medieval food like this. All "medieval" restaurants (even in Europe) I know of either serve modern food in old digs, or random barbecue as a sideshow to jousting knights and whatnot.
> God no please stop with getting the government involved

God no please stop with the anti-regulation BS.

> The answer is don't buy the damn house it's that simple.

If you're already several months into building, with partial payments having been made, when the builder tells you that this is the only option allowed, they have you over the barrel. They've violated the social contract of providing options, and expect you to pay the cost of it. That cost is either a reduction of your choices, or needing to forgo incremental design altogether while maintaining an antagonistic relationship with your builder.

> Pay more build what you want and be happy.

The parent post already tried to pay more to build what you want. The general contractor did not allow for any other options. The free market does not work with this sort of bundling.

> People want cheap houses and this is that.

First, nowhere did the poster state that they were unwilling to pay a higher price for a functional oven. They stated that there was no other option available. Second, the term you're alluding to is "revealed preference" [0], which is a load of economic bollocks. It implies that you can entirely ignore what people state they want, the circumstances in which choices have been made, or forms of market failure (e.g. [1]).

Overall, the appropriate response to market failure, including anti-competitive deals between builders and appliance manufacturers, is to change the environment in which that market exists. Introducing regulation in order to avoid unfavorable Nash Equilibria is the role of government, in order to fix these market failures.

[0] https://en.wikipedia.org/wiki/Revealed_preference

[1] https://en.wikipedia.org/wiki/Tyranny_of_small_decisions
I actually think it’s fine to do string sanitising here. The string formats for the databases are well specified, and writing a function to that spec shouldn’t be difficult. I believe there’s no need to parse to AST for postgres as you can just wrap the string in quotes, replace any existing quotes in the string with two quotes and you’re done. If other databases have funkier string formats then you may have a point.

at least that’s true for Postgres, I can’t speak for MySQL.
The VA and the government in general underpays doctors and white collar workers in general.
Two days ago I was trying to convince somebody who was very anti-war and sceptical of the mainstream media narrative on Ukraine, that Russian propaganda targets people like him, and that it's moderately effective. I posted these two YouTube videos [1] [2] of a journalist described as an "Independent Canadian Journalist" which got close to a million views between them, and proved that they were not independent and affiliated with RT by linking to RT [3]. RT.com has also been banned by Reddit [4].

Banning .ru sites doesn't actually undermine Russian military interest. It just undermines people like myself who want to link to Russian sources to expose Russian military propaganda. It drives sceptics towards unreasonable echo-chambers where they're more prone to and less aware of foreign influence. It causes Russians to host their propaganda on .com's where people will be less sceptical of it which is just correcting your enemy while they're making a mistake. If you were going to censor them, a targeted blacklist would at least have the benefit of letting through anti-war .ru's, it's not as though everybody in Russia supports this war. A .ru ban fails at the very goal it's trying to accomplish.

Banning 5 million .ru domains [5] is also just so destructive. The vast majority of websites blocked with have nothing to do with politics or news or the war. Fuck the people who run and use those websites, I guess?

The Russian perspective is also valuable to listen to, even if their government is horrible. If a Ukrainian war criminal in Ukraine rapes and murders a bunch of people, by censoring Russians who are uniquely capable and motivated to expose such war crimes. We're going to help war criminals get away with and continue perpetrating their crimes. War criminals regardless of country benefit from wartime censorship. Hearing the Russian perspective and engaging with Russians also helps to end war diplomatically and peacefully. It's the best situation if we hear the Russian perspective, but we're AWARE it's the Russian perspective, so as not to be misled by bias and to be sceptical of potential slanders.

A .ru ban totally fails at its intended goal, it hurts a lot of bystanders, and it undermines the goal we should be aiming towards.

[1] https://youtu.be/g1VNQGsiP8M
[2] https://youtu.be/Z9F-cHc5Qog
[3] https://www.rt.com/op-ed/370618-syria-sources-bartlett-rt/am...
[4] https://variety.com/2022/digital/news/reddit-bans-links-to-r...
[5] https://statdom.ru/tld/ru/report/domainscount/#8:date=202202...
Except that, like Trump during his Presidency, there is no shortage of true believers in his propaganda so the question is how much more likely it is. Are we talking about an infinitesimal technically true increment, or will Putin be out within the decade?
Read before attempting:

https://newyorkerbagels.com/bagel-safety-dont-be-an-er-stati...

Seriously. As any nurse about a "bagel injury" and they will know exactly what you are talking about. It is so common that it is addressed in some military first aid courses.