skysight-inc/HackerNews huggingface dataset:
Here's our precondition, it expects a single row with precondition_result to be 0/1. You could add an error reporting string column to the return type, but that's about all we needed. Very basic:

SELECT
CASE user_version
WHEN ${schema.pragmas.user_version} THEN 1
ELSE 0 END AS precondition_result
FROM pragma_user_version() LIMIT 1

On extensions: Yes, JSON is included in trunk. Is the latest trunk included in your build? Or are you linking against the platform's sqlite3? At least for the built-in extensions, you can pre-build an amalgamation .c file that contains all the first-party extensions with `make sqlite3.c` and a few env vars. But maybe you're using a pre-built dependency ¯\_(ツ)_/¯.

One extension we like is LIMIT for update/delete. I believe (at least in the version of SQLite we build with), that we need to enable that one when producing the amalgamation.

On userspace transaction batching: our usecase is internal inside an app. When we built the second version of our SQLite bridge, we were replacing a safe but very rigid API, so we decided to build something with as few limitations as possible. The main use-case today is batching multiple transactions into a single IPC message/JSON request object. But, for our platforms, there's exactly 1 client of the JSON bridge at a time, and we know out of band if that client dies or resets -- so we can terminate hanging transactions appropriately. You could also add an assertion that a batch never leaves a transaction open.

For an HTTP use-case, perhaps not a great idea because of multiple clients, sessions, etc. Maybe something to consider for the web socket API, which would give you a protocol session concept to reason with.
Intermittent fasting in the prevention and treatment of cancer
When was Palestine a country?
> Even trashing your working ICE car to buy an EV is a net negative

Is anyone really advocating for 'trashing' working vehicles? I thought we proved how dumb that was back in '08...
“Every record has been destroyed or falsified, every book rewritten, every picture has been repainted, every statue and street building has been renamed, every date has been altered. And the process is continuing day by day and minute by minute. History has stopped. Nothing exists except an endless present in which the Party is always right.” - 1984
> You can pre-compose your longer thought/question. Then paste it once any pleasantries are over and you have the other person's attention. They don't need to wait for your typing and you can take your time to compose the right message, if you need it.

Exactly. This is what I do, and advise people to do when they say "argh the web chat was so annoying". Plan your requests, but be cordial.
> That had a lot to do with it. Consumers were not used to getting cheap electronics yet nor was collecting media normalized except LPs and Cassettes (mid-80s). Stuff was expensive and people just didn't buy as much of it.

Not quite - the movie studios hadn't figured out they could sell way more tapes to consumers than video rental stores, so they lowered the prices to $19.95-24.95 in the late 80's.
The same way our esteemed fact checkers are unsure if being part of a bombing organization and getting convicted for possession of hundreds of pounds of explosives merits calling the person a terrorist.
Great writeup on `never`, love to see it!
There are also differences between Israel and a South African Apartheid. Israel is in a constant state of war and danger of losing its sovereignty. No such justification existed in South African Apartheid.

> but I think it is deeply unwise and immoral to further entrench the current policy of legal apartheid. The Israeli-Palestinian conflict will end in either ethnofascism and ethnic cleansing or some form of reconciliation, and this is a step towards ethnofascism.

I agree it's unwise. My point is that these policies should be gaged in terms of probabilities. I take you believe the probability of this ending in an ethnic cleansing instead of reconciliation has increased, I do as well. I also think the probability of Jews becoming a minority in Israel and being persecuted has decreased. Whether this was good/bad/worth it it's a different issue.
Systemd timers only work on one platform.
For me, collection things that you do not really need, is just a waste of scarce resources.
Judging from how this evolved for SmartTVs, you won't be able to buy a car anytime starting in the near future.
>It is also true that since WW2 USA bombed dozens of countries back to stone age

Many of those countries were already in the stone age.

>It is focusing exclusively on the CO2 footprint of the US war machine, which is never accounted in the US national emissions (therefore skews any discussion on curbing emissions).

Citation needed. The US military is mostly stationed in the US. Iraq and Afghanistan wars are over.
The fact that it only shows America is, perhaps, the most obvious tell ;)
My feedback:

I think what you're doing with Breeze seems interesting, but the value-add of making it a commercial offering isn't clear; what does it offer that anyone else can't easily replicate with Google Custom Search? I'm not saying that there isn't a value add, I'm only saying that it isn't obvious as a user.

Something has to be a scarce resource; my guess is that the resource here is "labor" in building the CSE parameters and finding the sites to add to collections. Perhaps the effort that went into this should be emphasized.

Are there plans to move things server-side? Making client-side requests to Google has privacy implications.
Sony would want to use their proprietary Memory Stick format
I see there are a lot of questions/doubts in the comments about the usefulness of such research. This type of research is the precursor to gaining the ability to generative photorealistic 3D worlds. What is that useful for? Anywhere we currently generate 3D environments, including movies, games, VR/AR.
At least they are not threatening to leave him outside the ISS, as in "Ghost Fleet"...
Same with Google Images. All the results are from local sources although I have selected Language: English and Region: United States in the settings. This is indeed infuriating.

By the way, I just went to https://www.google.com/preferences and the page is totally broken (Google Chrome with disabled ublock/privacybadger), when I click on Languages or Appearance or Region: Show more (at the bottom), nothing happens. "Uncaught ReferenceError: google is not defined" in the console.
> I guess that telemetry will help manufacturers validate or invalidate warranty claims.

I have a feeling this will be one of those one-sided advantages, the manufacturer will review the telemetry and only use the data if it assists them in denying a warranty claim.
Do they allow call for violence and death threats to these people ?

https://en.wikipedia.org/wiki/Abu_Ghraib_torture_and_prisone...

https://en.wikipedia.org/wiki/Mahmudiyah_rape_and_killings

Asking for a friend
I'm tired of the tech hustle culture.
FWIW a lot of other host languages are more DSL-like, and have similar libraries:

https://github.com/oilshell/oil/wiki/Internal-DSLs-for-Shell

It looks like this particular one relies on method chaining

script.Args().Concat().Match("Error").First(10).Stdout()
To say more: I have sometimes had to resort to writing a wrapper script just for the purpose of gatekeeping what stdout/stderr a task in cron does (and ensure the exit code is properly (non-)zero.

At one former job where I had a lot of cron jobs, I even wrote a re-usable wrapper utility for it.

Many unix command line executables are pretty bad at it (especially if you deal with anything proprietary), so I get why people resort to just throwing away output from cronjobs, although it is a problematic lack of observability, true.
People do that?

What an appalling way to conduct work.
Good point, but guns are legal in NYC. If you have a dangerous job like a security guard, you can get an open carry permit. If you have no special circumstances, you can own a gun in your home. The gun can be transported to other destinations like a shooting range, your business, or other homes, as long as the gun is locked in a container during transit. Until recently you could only carry the gun between your home and a shooting ranges within the city, but the law was expanded due to a current lawsuit against the City.

edit: Most gun crimes in the city are done with illegal guns, 74% of which come from out of state. https://www.vox.com/policy-and-politics/2016/10/26/13418208/...
Don't forget the invasion of privacy. These ads include tracking.
Interesting article; C++ as “C and then some” was clearly an irresistible marketing term for many of the programmers from that time that I’m sure Bjarne indulged himself in saying once or twice too.
No surprise coming from Israel.
What are you on about? Do you just randomly smash the keyboard?
Just an FYI,

All RTO/ISOs in the US have a variety of dashboards to describe realtime and historical information, as do the Canadian entities. So you can see the same thing for CAISO, ERCOT, SPP, MISO, PJM, ISO-NE...etc on their websites.
News in that era was "unbiased" mostly because the US government had a soft censorship regime in the form of the FCC and corporate ownership of TV spectrum. Walter Kronkite calling out the government on Vietnam was the exception rather than the norm. What people are remembering isn't "objectivity", it's one particular bias[0] everyone was required to have in journalism - i.e. the illusion of objectivity.

Today's "biased" news is just regression to the American mean. When people got their news from newspapers, almost a century ago, you had similar levels of editorialization, bias, closed-mindedness, clickbait, misinformation, and so on. The "unbiased" era was largely a product of technical limitations that went away with cable, and later the Internet.

[0] Or, more specifically, what Noam Chomsky called the "five filters". See: https://en.wikipedia.org/wiki/Propaganda_model
... And with that women said "eff that!" nailing the coffin of the FAV
Thanks so much for sharing, their website has just helped me to better understand the horizon of my city.

https://www.peakfinder.org
And beware that markedness is pronounced as three syllables like mar•ked•ness[1]

Is marked pronounced as two syllables, mar•ked, in the context of linguistics? I am guessing it would definitely be in British English[2].

[1] https://m.youtube.com/watch?v=vrZpjr44c1w

[2] https://www.reddit.com/r/linguistics/comments/dwo5gj/is_it_a...

Sorry for the poor source links, I only did a quick Google. Disclaimer: I am from New Zealand, and sometimes how we say things is special, and sometimes how I say things is even specialer.
I just noticed yesterday that Postman has functionality like this, with over 20 options for the language or language+framework used.
Seems to be mostly doing text-replacement and not actually understand what it's handling and what it can't actually do: https://github.com/icing/blog/blob/main/curl_on_a_weekend.md (not my article, saw the link on twitter today)

E.g. it turns curl ftp://host.com into response = requests.get('http://ftp://host.com')
> Billboard reading "Will the Last Person Leaving SEATTLE — Turn Out the Lights" appears near Sea-Tac International Airport on April 16, 1971.

https://www.historylink.org/file/1287

I heard of it.
They are where they came from. What do you mean?
I think there was a release of docs about using humanized migratory birds to carry disease to specific places. Possibly as a blurred line between studying such mechanisms for defense as opposed to offense. I can’t speak to accuracy of such claims but it does appear that info is being released.
Think of all the attention you could monetize with a captive audience in a self-driving car. I fully expect it to be exploited by ad companies. And subsequently by hackers.
There was some news covered about a proposed bill stop US military training for the Azov, but pretty quiet after it didn't pass
> When I was a young man, I was told the world will freeze, and within five years we will all die. (Good times for fur trade!)

You should have listened to Tiny Tim then:

https://youtu.be/uAZgTKsdJsc

Because he thought The Ice Caps are Melting

(Oh-ho-ho-ho-ho)
An ingredient of the sandwich, which consists of more than only the bread.
I think it's fair, considering the sky-high salaries at the top end of our industry are almost solely due to ad revenue. We'd all see significant downward pressure on wages without that—we're basically accountants by social status already, but losing ad revenue would put us in the same area pay-wise, too.
There were a few attempts, slotMusic is one that comes to mind.

They kind of all were doomed. Why buy a digital music player that couldn't manage music as well as the cheapest MP3 players? These products also felt like an attempt by the flash storage makers to dump older inventory since an album would fit on smaller cards than most consumers wanted. Then the iPod steam rolled the market. The convenience of iTunes, even over poor Internet connectivity, was hard to beat.
I'm wondering why pedestrian accident prevention isn't standard equipment already. We have sensors all over, adaptive cruise...everything is in place except the junior-developer grade software routine to stop instead of hitting shit. Shows where the priorities are.
Russia will ban Instagram in 48 hours
I stopped purchasing ebooks and am buying hardcover or paperback, even if it costs more.

I want to physically own my purchases, not just have some entitlement to some file on a server.
It's not like advertising companies have very high ethical standards ...

In fact, does ethics even exist as a concept in business, other than when it's used to sell more products?
Robert Freitas was still in college when he started “Xenology”
[This comment was dumb, and I've opted to remove it.]
Flamewar comments like this are not ok here. Personal attacks are particularly unwelcome. I realize emotions are understandably high, but you can't post like this to HN and we ban accounts that keep doing it, so please don't do it.

https://news.ycombinator.com/newsguidelines.html
Because the US locks people up for decades for drug offense that may not even be felonies in other countries.
Isn't this just reputation and word of mouth? Far more reliable than an interview.
> It leads to a theocracy

And yet it hasn't. It's a democracy. Has been since the founding.

> run by religious extremists

It's run by whomever people of Israel elect. The purpose of this country is to protect the Jews from various pogroms and genocides that keep occurring to them with a disturbing regularity.
Aren't you consenting to it when you are browsing the web? If it bothers me so much ("mind rape") and I know a website has ads, why would I go there?
Don't people actually marry because they love each other, and not as a way to gain a favourable citizenship?

How the naturalization law prevents a marriage?
Not only did I not know this was a list, I also didn't know it was super easy to add new list to uBlock Origin, thanks!
Honestly I'm not convinced. I understand the need of a so-called "real" programming language ready available, that's what all classic system have had, from SmallTalk workstation to LispM, but for them there is not just the language, there is the complete ecosystem build with the same language, so an user made script have no difference than a system part of the user desktop.

Unix decide to "simply" creating a system with a system language and an user system with an user language, the shell. I do not like much unix approach after having used Emacs a bit, but I do understand it. On contrary I always fails to "craft scripts" in "real" programming languages no matter what. I've tried in the past to "go Perl", "go Python", "go TCL", yes I can write scripts with them, I have written some etc but if I need something quick I go for the shell, zsh to be more precise (tried others, all failed at a certain point, from bash to elvish passing through oil shell and few others) or being in Emacs (EXWM is my WM/DE) Emacs itself depending on the case.

I read various similar article for a language or another but in the long run see no colleagues really choose a programming language behind shell itself...
> This is coming out of the belief that the Jewish people need a Jewish refuge state based on the constant past consequences of not having one.

It's funny how the experience of being subjected to a racist, human -rights-disregarding ethnonationalist regime that engaged aggression based on a desire for historic ethnic territory and a desire for buffer space has provoked the creation of a racist, human-rights-disregarding, ethnonationalist regime that engages in aggression based on a desire for historic ethnic territory and buffer space.

Well, not “funny” as much as “tragically ironic”.
Check out ElectricityMap.org, they scrape the independent dashboards (CAISO, NYISO, ISO-NE, ERCOT) for generation mix data, anything else (in the US) is pulled from EIA’s balancing authority API with a 6-12 hour lag (ElectricityMap uses machine learning to provide real time estimates based on historical data for data delayed zones, and it is spooky how accurate it is [Chile in particular] when the data backfills and “catches up”).

https://app.electricitymap.org

https://www.eia.gov/electricity/gridmonitor/dashboard/electr...

Edit: (can’t reply, HN throttling) @mardifoufs https://www.cbc.ca/news/canada/montreal/hydro-quebec-could-l...

https://www.cbc.ca/news/world/maine-vote-hydro-quebec-1.6233...

(NIMBYs in Maine sandbagging export of clean hydro to New England ISOs)
What if you're asleep and the car is in the drive-way? How would you be able to accept/decline in 60 seconds?
Re-using curl's C code and compiling to WASM is the dream.

libcurl does stuff like open files for reading, so you would have to at least modify the code to just pass the file name, you also have to modify the struct.

libcurl parses an array of strings, but curlconverter gets a Bash AST (or a list of strings if you use it from the command line). When there's a bash variable in the command, we want to generate code that gets that environment variable at runtime, e.g. `os.environ['MY_VARIABLE']` in Python so the struct needs to store pointers to AST nodes instead of strings/booleans/ints. Though to be fair curlconverter doesn't work this way either (yet), we convert AST nodes to strings/booleans/ints after command parsing and store that, then when we're generating the code if we see a $ in a string we assume that was a variable in the input AST.
If you relax laptop to mean functionally portable, then reasonable commercial variations existed since the early 80s. Not with a clam-shell form factor, but designed to travel with you. By late 80s you had things that looked a bit like current laptops, e.g. NEC ultralight.
> I still don't understand why Firefox, champion of privacy, doesn't make a uBlock native.

That's the best technological solution but there are inherent conflicts of interest since Firefox depends on Google for money.
The topic of programmable money aside, Why centralise the ability to freeze an account? If I deem someone (or some organisation) to be a bad actor I would like to block the ability to make payments to them and put that account number on a publicly visible register.

Now this organically created list can be consumed by other people or organisations effectively excluding them from receiving payments.
> The fact that we don’t any more was a catastrophic policy decision

One effect of this is that the US and China are economically interconnected. It makes war a lot harder. It's why the EU is dragging its feet on oil and gas from Russia because that's the one Russian export they need.
Curl-to-Go also understands JSON payloads and will even generate the struct definition for you to fill in, so you aren't working with opaque JSON strings.
The law says that agreeing or disagreeing should be equally easy. Companies are breaking that law.
And at the right time of year there are tarantulas everywhere. Awesome spot.
I would not own a car that was steer-by-wire because of the risk of electrical failure.

I've had electrical failure in a car before. The alternator died and wouldn't produce enough power at under 2000 rpm. My stereo and lights were flickering and engine was sputtering. In a steer-by-wire system, I'd have lost my steering. I'm just glad I was driving a stick shift, giving me more control over engine speeds so I was able to make it home and not have to get a tow.
If you use YouTube and search for “LG Oled 4k” you will find fantastic looking streaming videos that look better than anything streaming from Netflix, HBO max, Disney plus, Apple TV etc…

It is very frustrating that Blu Ray is the only way to get high quality Hollywood content. The technology is there for streaming
Please stop perpetuating flamewars on HN. It's not what this site is for, and it destroys what it is for.

We've had to ask you this more than once before.

If you'd please review https://news.ycombinator.com/newsguidelines.html and stick to the rules when posting here, no matter how wrong others are or you feel they are, we'd appreciate it.
While I see the benefit of this approach, I’m often baffled why people want to go either 100 % POSIX builtins or 100 % scripting language.

The biggest benefit of the shell is its clearly defined input and output (and error) interfaces. Most programming languages can read from and write to stdin, stdout, and stderr.

Why not use it and stick to KISS, replacing one cumbersome POSIX utility at a time, suites for the task? Then you don’t need to chain methods using less idiomatic code. But then you wouldn’t need these kind of libraries either.
Italy builds six new wind farms in a bid to move away from Rusian gas dependency
PiHole is not awful. It greatly enhances the blocking provided by browser plugins. Most valuably, it blocks an enormous amount of ads in non-browser apps. If I'm using e.g. the BBC app on my phone, PiHole blocks most of the ads (or at least it used to; I haven't checked recently). It also blocks ads in smart TVs and other places where you can't install uBlock.
> and are overtly hostile to Judaism, as prescribed by their religion.

What does the Talmud say about the Goyim?

>is it really so wrong for a nation to implement laws to preserve its culture, particularly when it's people constitute a tiny fraction of the global population

It's ok, natural and healthy for Israel, but not for the rest of the world, where that is nationalism and equates to ideologies of the 1930s.
Making a science out of convincing people to buy things they don’t need is not only not important, it’s fundamentally dishonest. No amount of apologies or hand waving will change that fact. Marketing is a pox on the human mind that we’d all be better off without.
All true except for one thing. DVDs and Blurays are very susceptible to the slightest damage, even invisible damage. Every time I play one, I wonder if it is going to play or hang halfway through. Many also make it hard to actually get to the movie, inserting several minutes worth of various delays.

At least CDs don't have that last problem, just insert and they play. CDs can also be pretty beat up and still play fine.
Why should you do this in Java:

httpConn.getResponseCode() / 100 == 2

instead of:

httpConn.getResponseCode() == 200
They could have build new nuclear power plants instead of voting for decommissioning them and sucking every last drops of cheap oil. Future generations will be the judge, in the meantime get ready for a few cold winters.
However fun and flavorful these may be, they don't actually solve the problem being articulated, which is sending a greeting with no substantive message attached.