skysight-inc/HackerNews huggingface dataset:
Hey thanks for sharing!

Re infering schema of input JSON: That would be slick! Though SQLite does have some limitations here with table-valued functions vs virtual table. I won't go into the specifics, but something like this isn't possible in SQLite:

select name, age from lines_json_read('students.json')

The "name" and "age" dynamic columns aren't possible when using the "table function" syntax, but something like this is possible using traditional "virtual table" syntax:

create virtual table students using lines_json_read(filename="students.json");

select name, age from students;

It's a small difference, but definitely possible! Though parsing JSON in C is tricky, but would definitely accept contributions that figure it out.

And re benchmarks - thanks for sharing! Yeah, they're pretty basic, so would love to add more complex ones. With the books.json example, I think what's happening is that in SQLite's JSON function, it parses the JSON each time in each json_extract function - so it parses twice for each row in that query. I also suspect that the long strings in "reviewText" might slow down, but can't be sure. Once I get some free time I'll add OctoSQL to the benchmark suite and this new books dataset
> We eat a credit card's worth of microplastic every week, mostly coming from our water supply apparently

There ia a lot written about this online but they always skim over the detail of how humans actually ingest this.

Do you have any source that explains that the source is mostly via our water supply?
All that housing, food, water and internet cost money. I don’t think it’s as easy as you’re making it seem.
I think the statute of limitations on “confusing name” when Mac OS Carbon was removed from OS X 10 years ago has passed.
I put Mr Wizard into the same category
Your workplace is not your social circle, even if you do become friends with some of your co-workers. Until you can internalize that fact, you're going to continue to be unhappy.
My father told me that you should never tear yourself down, there are plenty of other people to do that for you.

My advice is to listen to the parts of the critic that serve to improve your ability to heal the world (including yourself) and discard much of the rest.
Political nimbyism is what put the waste where it is. It ended up in the back yard of the least powerful political force in America. Curating nuclear waste for longer than any human can actually comprehend isn't something to just brush off. You'd be trading one climate catastrophe for another.

And that doesn't even account for securely transporting the waste across the country. Imagine scaling nuclear to the size of coal. What does waste transport look like then?

Maybe this waste belongs precisely in the back yards of those of us who create it. Then we'd be truly careful.
I believe most waste isn’t spent fuel but rather other contaminated stuff, which isn’t going to be helped by breeder reactors.
Oh wow! I wonder how hard it would be to load that module into https://github.com/simonw/datasette-lite

Hah, turns out I have an issue for that already, which I'd forgotten about: https://github.com/simonw/datasette-lite/issues/30
That was my position too, but I was recently told there's a tool called waypipe that is supposed to solve this. Haven't tried it yet, though.
I never said it can't be done. I did write this in a hurry, so I may have muddled my central thesis.

I'm arguing two things:

First, Clojure has missing or rotting libraries, requiring re-implementing logic we've all done at least once because people are fixated building the Rails for Clojure.

Second, that the business case for using Clojure becomes weaker because the lack of open-source efforts on this front (due to the 'Rails Vacuum') causes either interal library building (extra time) or, more likely, interop. Interop, to _some_ management, sounds an awful lot like using Java, but with very expensive Clojure developers to do it.
"The SSD storage engine stores the data in a B-tree based on SQLite." XD
https://apple.github.io/foundationdb/architecture.html#stora...
>> "Microsoft operating systems have always strived to make that impossible."

That's the one thing I've never seen someone accuse Microsoft of. They're famous for their obsession with backward compatibility.

It sounds like you've had a different experience, and now I'm curious. Care to share?
25 years of evidence for repealing the Prison Litigation Reform Act
I have tried plenty of times, and seen not so happy train travelers with the same ticket for the same place on the same train, hence why bring it up all the time.

It is obvious it is a subject that is irrelevant in the Rust community.

Who needs consistency in distributed systems when multiple threads from the same process are accessing the same external data without coordination.
I think revenge probably evolved first and foremost as a deterrent. While it might feel satisfying to cause pain to someone who has hurt you, the damage has already been done and you can’t undo whatever damage you suffered. But you can show that there’s a cost to messing with you, which could prevent future aggression. I’d guess that’s why we feel the desire to punish in the first place.
I think Onyx and Cortex always were redundant. You have Kafka and Spark/SparkML and Storm, you can use them from Clojure without problems.

If Onyx had been the first, it could have become what Spark is, possibly.

My point being, I don't really think every language needs a distributed compute, just need one and have bindings from your language to use it. Clojure being Java has access to many bindings for many of those popular libraries.
Unfortunately this could only work on desktop.
Do everything you can to introduce TS incrementally. JSDoc simply isn’t enough.
rt.com works for me too.

sputniknews.com does't.
> When there was a woman working with us, she was often put on a pedestal, given unequal room to talk but otherwise ignored and generally had lower expectations on her projects.

We have very few women. But the one we have, she earned her pedestal. I was there when we interviewed her. In an interview, you ask questions to see how much the candidate knows. We started there, but with her we switched. Halfway through the interview, we started asking questions because we wanted to learn things. That was different - that's never happened with anyone else we've interviewed.
I tend to agree when talking about men, in general. But for women the meaning of hair can be much deeper. So it's good this is being researched.

For balding men, it's a great idea to accept it and work on yourself in other ways. It's also a great idea not to judge people based on their hair. I sort of agree that if you want to get a transplant you're probably making up for insecurities.

But if it makes you feel better, go ahead. No pun intended!
This comes up a lot and, I think, Laravel provides a great model for competing with rails. Stripe integration - https://laravel.com/docs/9.x/billing
I really think the most exciting feature of Carbon (indeed, it's justification for existence) is its backwards compatibility with C++, followed closely by it's more modern and flexible governance structure. Even the docs in the repo say you should avoid Carbon unless you have lots of C++ code you need to interact with.
I wish source code editors were much more AST-oriented rather than row-column-oriented. Sure, it’s more difficult when your grammar is more complex than s-expressions, but most editors these days maintain an AST of the source in real time anyway.

Features such as selection that grows "inside out" (or bottom-up) rather than line by line, moving a selection around to the next/previous valid position, moving various delimiters around to next/previous valid position, enclosing whatever’s under the cursor in a new block/pair of parens, and so on.

Unless we’re talking about FORTRAN or COBOL circa 1960, source code is a tree natively and text only incidentally.
My experience is that Nitter is faster than the official Twitter frontend
Yeah there will. We're like rats: easy to kill as individuals but pretty hard to stamp out en masse.
This is the sort of news that keeps me coming back to Hacker News...
I came upon this today and thought you might enjoy it.

> An absolute perspective, one of unconditioned objectivity, would, as Nietzsche says, have us “think an eye which cannot be thought at all, an eye turned in no direction at all, an eye where the active and interpretative powers are to be suppressed, absent, but through which seeing still becomes a seeing-something, so it is an absurdity and nonconcept of eye that is demanded.”
How long did you serve? When you say "never had a single problem", are you being literal?

I'm abstractly aware that nuclear technology is reliable, but your anecdote somehow makes it more relatable. You've piqued my curiosity :)
I feel like the biggest benefit of small nuclear is that it can be put anywhere and you don’t have to build extremely costly transmission infrastructure. Just dot these things around. It surely isn’t cost-effective enough for the first 85% or whatever of a state’s needs, but for that last mile problem? Sounds good.
I'd love to get my hands on the driver, I still have virtual machines with MS-DOS and WFWG but the standard drivers aren't that good.
> Community management is bad, even worse that RH nourishes this elitist aura around himself.

That's a weird take, considering it's consistently called out as one of the most positive aspects of Clojure on surveys.
Yup, if it hits https://httpbin.org/delay/10 then the entire script will delay for 10 seconds (unless you have a custom lower timeout setting). Which means you can only make HTTP requests in serial requests, which sucks, but much simpler than coordinating with other tools

It'll come out in a week, but lmk if you want to play with it beforehand!
Creating a Zelda style game in Python
Oh don't get me wrong, it _is_ transparent to call an Erlang library from elixir.

It's just that there are even _less_ library to call :P
Seems similar to JetBrains

https://news.ycombinator.com/item?id=32286209
Because, to pick just one example from many, Gmail will automatically route your email to the spam folder of your @gmail.com recipient.

There are many hoops you have to jump through, and you don’t yet know what they are. So, read up on it and drive in. You’ll learn soon enough. It’s not impossible, and your newsletters aren’t business critical, if they get lost.

BTW, “I wish” and “I would think” don’t work with email in the 21st century, as others have explained.

P.S. you might just get a $50 Fastmail account and send via their servers. But, be sure to give your readers a way to unsubscribe, and be diligent about keeping the unsubscribe actions current. FM has generous limits on amount and frequency.
Is the disposal of coal, gas and oil emissions a solved problem yet? At least nuclear waste is contained.
Does anyone have sources to cite on the negative impact of “wokeness”? Hard numbers. Could find any quantifiable impact. Perhaps I am not looking properly.
What, it's not the 27547th blog post about Rust being good at something?
Definitely! I found this in Waugh’s letters, which are fantastic. He is more wryly sardonic, and less bleak than Larkin.
The documentary "Won't You Be My Neighbor" was even better than the movie, highly recommend it.

https://www.youtube.com/watch?v=FhwktRDG_aQ
Just improve decentralized energy storage and micro-grids.
Tor was developed by US military and is funded by dept of state. It should not be trusted. Better set up your own tunnel/vpn on a host you control.
Exactly that, all banks here in Brazil are exporting transactions with this kind of format (Its called CNAB file over here and they are probably using COBOL systems). You have different kinds of CNAB files, CNAB 200 where you have lines with 200 characters, CNAB 400...

Inside those files you have multiple chunks and every line contains information about a transaction. So if you wanna get the transaction amount you would look for all characters between character n10 and n20 for example. (Those positions are fixed and follow the bank template).

We had success parsing it with python/node, but i think spinning up a sqllite instance, reading straight from the file and doing some calculations would be much faster.
Yes. But if we're going by possibility it's also possible the chiefs sold out their own people and misrepresented their desires to the Canadian government.

After all in many treaties the financial compensation of the chief was drastically more than the common member. For example in treaty 11 chiefs got 25000 while lay people got 5 dollars. That is a pretty clear disincentive.
Not compared to the lifetime energy intensity of driving a gasoline powered car.
I hope they picked that name for the same reason Apple picked it: because all life is built on carbon.
I disagree - I think you are conflating 1. "how to punish someone" vs 2. "whether to punish someone".

You are arguing that we should change 1. by allowing violence. But in the examples you gave, it's not an issue of _how_ those acts are punished, but whether they are punished at all.

In other words, maybe we need to enforce current punishment more strictly rather than increase the pain of currently loosely enforced penalties.
You should look up the cost (in whatever metric you like: dollars, lives, cancers, etc.) and compare it to coal. Don't forget to normalize, since coal is much more common than nuclear power.

The results will likely surprise you.
Another recommendation I'd add is appending "_optout_nomap" to your SSID name. That will let you opt out of both Microsoft and Google's access point data collection.
Whatever your definition of "hate" is, if it doesn't capture teaching people to believe Black people are inferior, it's an unproductive definition, one that will just lead you into constant unproductive semantic debates. A lesson that Black people are inferior is a lesson reasonable people will consider hateful. Some beliefs people hold are simply hateful; we are not bound to respect them.
Interesting, thanks, I didn't know that they call it "perpetual fallback license". I guess this makes it sound more like a benefit than "paid updates".
Kids have the freedom to go to school without fear of being shot.
Mothers have the right to take 6 months paid maternity leave.
Workers generally have more rights and protections, although this is getting worse.
It's always other governments who are authoritarian and for whom censorship circumvention is a good thing. Of course they surely are relatively more authoritarian but everywhere has censorship that the locals want because it's their country with their culture and their rules.

New Zealand imprisons people for sharing the video of the Chirstchurch mosque shootings. I'll bet Tor is doing a good job helping circumvent that censorship too.
There seems to be a recent development:

Quote: "A novel version of opencog"
https://wiki.opencog.org/w/Hyperon

And a video of OpenCog Hyperon in use with explanations:
https://www.youtube.com/watch?v=Unryt6XH2FE
Its been a while, I remember some strange behaviour of generic functions on sets* that differed from the behaviour in lists and bug reports about it.
Only the most naive people think that "punishment as a deterrent" is dead.

It only takes a simple thought experiment to see why that idea is stupid. How many additional murders do you think there would be if the punishment for murder was a day in prison instead of 10 or more years? How many aggrieved ex-spouses, neighbors, and coworkers would turn to violence to solve their problems?

The answer is: a lot.
History may not repeat, but it rhymes
Xi and Putin would be toppled instantly without censorship because the reality of their oppression, out in the commons, without constant, total suppression of other ideas would expose them for what they are.

Why do you think it's illegal to even refer to the War in Ukraine as a 'War'?

They've threatened 15 years in jail with anyone who even hints at something that is 'not true' - in their purview - meaning - if you publicly say something against the ridiculous propaganda - you dissapear. Watch interviews of regular Russians on the street as the 'avoid answers' or 'struggle to find ways to say something, without actually saying it' because they obviously live in a system of fear, where just a few wrong words ends their lives.

Without the power to make sure that Russians do not talk about the war, about Putin's corruption, and how to 'get rid of him', Putin (and Xi) would be gone very quickly.

The #1 thing in our modern constitutions is 'freedom of assembly' - basically so that people can convene and have ideas. 'Rulers' don't like that because it's how they are overthrown.

On the other side - RT is a propaganda outlet that can hugely affect popular opinion and discourse, especially in a realm where people generally do have free access to information.

Most of Putin's lies are laughable, but most people aren't in a direct position to dispute them either, and so its' pretty easy for him to convince, say 10% of the population of the legitimacy of whatever genocide he wants to do.

Which is why we absolutely do not want RT on broadcast to every American every night.

Of course, freedom of information is important as well, so we do want to enable people to have access, and as such, only a very small subset of the population will bother with it. Those that are 'inclined towards information' which is probably a good thing.
I've had friends that served on nuke subs. It still blows my mind that a sub only needs to refuel once every 15 years.

I never understood the argument nuclear power is so "dangerous". The US navy has fielded nuclear reactors in warzones since 1954 and no Chernobyl. Almost the entire fleet is nuclear-powered, including all aircraft carriers, subs, and battleships.
You're too focused on 'efficiency' here. The two processes are so wildly different that a 70% loss at certain stages isn't a big deal.

A solar panel loses more than 70% of the power that hits it. But that doesn't disqualify it at all.

And plants lose a ridiculous percent of energy right at the photosynthesis stage, but they'd still beat solar panels if solar panel prices went back a few decades.
How will it affect other SQLite connections against the same database?

My guess is they'll be OK, but presumably any transactions will lock tables for the duration?
I think recidivism is more correlated to opportunities for rehabilitation than punishment . When I was at a boxing gymnear Baltimore there were kids from poor families talking about their life. In the US if you are poor you are pretty much screwed once the legal system has you. Your background check will exclude you from decent jobs and it’s just a never ending downward spiral. The courts often add some kind of bullshit fees which unemployed people can’t pay so they go back to prison.

The US has managed to set up a cruel and heartless system that punishes poor people, costs enormous money and destroys the social fabric of whole communities.
As I understand it, a ton of Russians, especially older ones, just rely on TV and print media for news, and those are much more tightly controlled by the Kremlin.

> Just like US citizens during the invasion of Iraq, most of them barely knew what was happening and simply didnt care to know. They were just comfortable in their assurance that USA was #1.

While the WMD aspect of the invasion of Iraq was bullshit, the rest of it didn't seem to contain nearly as much propaganda -- as in, just blatantly lying -- as what Russia's doing here. I don't think the US lied about US soldier casualties, for instance, acting like they were taking a small fraction of the actual injuries and deaths. Not to mention the war crimes seem enormously more common and severe with Russia's invasion, and those are all getting covered up by the Russian media within their country (e.g. "Azov/Ukraine did Bucha").

Basically any war will involve some amount of propaganda and atrocities, but some people are acting like the way Russia and the US prosecute war are the same, when that appears to be clearly wrong.
I mean, a trillion spent is a trillion spent: it'll trickle down regardless of how you spend it, the question is if you could have spent it some other way that would have given more jobs?
Can Tor work over IPv6?
> the US president is going to dictators begging for oil, hat in hand.

A big advantage of EVs is that presidents of the future shouldn't need to beg for oil as much, as road transportation energy supply market would be largely domestic.

But we clearly aren't there yet.
https://www.deepisolation.com/ looks like a reasonable solution, assuming we don't use the waste as fuel.

Why would future generations have to worry about something buried deep underground? Just don't drill there.
What the Duck? Apple’s AutoCorrect Sucks More Than a Black Hole
Yandex Ads Merch Drop
Hrm. I've done this myself with the OBD-II reader and some do come up pretty quickly, but they took all some amount of running/driving to be ready if you reset the ECU...which people would try if there's a code stored / check engine light on. Some of them take quite a while to be ready.
This is much more than "just wrapping". It allows strings to be used more readily with existing Clojure abstractions and/or allows idiomatic use without the need for being on guard to avoid reflection.

Notably, Alex didn't write this library and only has a minor contribution to it.
I assume this is on community management. I am not taking part in Clojure surveys so its fairly obvious to me why my opinion is not reflected in the community surveys.

I got to admit that maybe community management might have improved in the last few years.
Vetiver is a Tamil word. Ver literally means root.

https://translate.google.com/?sl=auto&tl=ta&text=vetiver&op=...
(You can listen to the pronunciation of the English version and the Tamil version in the Google Translate link above).

I remember my childhood days when the vetiver roots were used to add fragrance to bath water and fragrance & taste to summer drinks.
Carbon was removed two years ago.
Many of us work in worlds where we absolutely cannot just install packages. Solutions that aren’t default are solutions we can’t use. And X forwarding is available by default - losing that is regression.
I get what you feel but still... Censoring the internet is dangerous, Europe will certainly not give up this power even after the war ends
> Whether it's corn or grass that's being fed on, the carbon being belched out by cows comes from the carbon the plants captured from the atmosphere before being eaten.

I think the main problem is that said plants are grown using fossil fuel-derived fertilizers.

Why they don't use cow dungs to fertilize said plants, I don't know. Maybe a farming specialist can enlighten me why chemical fertilizers are so much more abundanly used than animal waste fertilizers.

Another problem is local buildup of carbon or nitrogen. The Netherlands suffers from a nitrogen crisis: an EU court has ruled that the Netherlands' nitrogen emissions are higher than allowed by treaties, and so we must cut emissions. Emissions are caused for a large part by farming activities. These emissions are a problem because the nitrogen in farm waste products originate from a non-local source. So the nitrogen builds up locally and harms nature.

The Dutch government ordered farmers to cut back on their stock. Now farmers are protesting, blocking roads and setting hay balls on fire.
> Most dairy things are pretty gross

cheese?
> But a group of N sqlite databases is an N-writer database. And mvsqlite provides the necessary mechanisms to do serializable cross-database transactions without additional overhead.

I'm confused, are these databases planned to be replicated? Or is it expected for the databases to have separate schemas?
I wish I could tip him
I would think "wokeness" is too vague to study scientifically. That term has been used as a catch-all for many different things.
last I checked archive.is had killed its bookmarklet, which is very annoying

haven't checked in a while though, maybe there are workarounds