skysight-inc/HackerNews huggingface dataset:
I have worked with JSON in SQLServer, and I agree with the sibling comment that JSONB is the ideal storage format. SLQServer's JSON querying functions are pretty straightforward, although they do expect that you know the schema of the json data you are querying.

As to JSON metaformat (I assume you mean for ingestion), a format of an array of objects works best.

For the last question, the main gap I find is trying to understand the 'structure' of json data that I didn't generate directly. There aren't great tools to show whether all the JSON records have the same nested structure with similar key names, etc.
Neovim is amazing but recall how long it took you to get used to vim keybindings. It isn't something you master overnight. I recall it took me a few weeks to get comfortable. Lots of people are perfectly comfortable not using keyboard navigation.

Edit: Also to note - vscode supports editing files anywhere over ssh as well, so there isn't a huge advantage to neovim there.
Wrong. How do you think open source works? Did you read your Linux source code before trusting it? Probably not, and people do not need to because it takes one canary to notify and get the word out when something is wrong.

Ethereum is an experiment and has never not been in development. You saying that crypto can never work or that it’s transparency is pointless because an experimental project has an issue you don’t understand is extreme cherry picking combined with unrealistic expectations on a developing space. Progress is being made all the time and Ethereum is far from the only game in town. I do not understand why those ignorant, even those like yourself who admit just how ignorant you are, attempt to make poignant decelerations about the state of crypto.
Last year, the NVIDIA Shield TV, a $200 device if you get the Pro version, received an update to Android TV that forced a new UI for the homescreen that injects ads from a variety of premium streaming services [1]. There is no easy way to disable it as far as I know other than installing a custom launcher such as FLauncher [2]. The cancers of modern day advertising cannot be understated.

[1]: https://www.guru3d.com/news-story/nvidia-shield-tv-update-an...
[2]: https://play.google.com/store/apps/details?id=me.efesser.fla...
ah, yes it does? 'cargo build' absolutely goes and finds dependencies, updates them, and so on.

'rustc' does not, but we are talking about cargo here.
Wikipedia globally blocks Apple Private Relay IP ranges from editing
Nothing “happened” it’s still growing and a great language. It’s just past the point where mavens are evangelizing it because it’s not new to the mavens anymore.

It’s a fantastic set of tools, and a great community. The real trick is that the organizations that you find using it, especially well established ones, are going to pay well and be looking to invest heavily in their engineering teams.
Very cool! Not exactly to _my_ personal taste, but objectively a very nice project! Kudos for USB-A 3.0. Love the openness, Coreboot and the configurator. The warranty is impressive. I wish more products like this existed!

On the design downsides (imho): Why MicroSD? There's enough space to put a BD-RE drive, not to mention full-size SD. The battery is not user-serviceable, judging by the looks. Not made of 18650, not hot-swappable. And the power button... there... err... ugghh... just.. WHY?? (I'd definitely hit it instead of DEL, which was placed there an all of my previous laptops).
A Language Design Analysis of HolyC
> “So we are actually paying more”

I suspect this is false and the ads and tracking enabled by smart TVs are instrumental in getting the price down.

Price sensitivity on TVs I suspect is one of the main drivers of this.

Still, I think there’s a real niche for someone to make a tv focused on the HN market. Call the company “dumb electronics”. db even has a pleasing symmetry to it for a logo imo. Focus on speed to boot and switch inputs, optionally sell it as a package with an Apple TV, make it premium and OLED. Basically the tv apple would build if they decided too.

The current best option in the tv market is the LG OLED, but it’s smart and still leaves a lot to be desired.
The 90s were very chaotic and hard times but the article is exaggeration. Most women (daughters) didn't turn to sex workers, most sons were not drafted to fight in Chechenia. In fact, it was even bigger worry that your son would be sent to fight in Afghanistan and be killed there during the time of the USSR.

Economically they were very hard and depressive times. Many mistakes were made. But then it gradually got better and it was nothing to do with Putin. In fact, Putin was one who supported many oligarhs and imprisoned and killed others that he didn't like. In a way, he was part of the problem that prevented Russia to develop even faster and made it too reliant on oil and gas revenue.

Putin simply had very powerful propaganda. Other post-Soviet countries similarly had problem with oligarhs and corruption and some of them made a slow progress to deal with it others not so much. Nevertheless, while achieving stability in Russia, it also tried to cause chaos in Transdnipria, South-Ossetia, Eastern Ukraine by inflaming nationalistic conflicts. Russia could get away with it for a while but now attempts to take over Ukraine will severely harm Russia itself and it will lose the stability it was hoping to keep.
I don't think so. Bhyve with a Rust frontend could run on other systems.
I absolutely do have qualms with the entire organization and find ezra klein to be a snake. The idea that a self proclaimed anarchist who spoke against the state as being an exploitative entity, promoting increased state taxes on land, is amusing until you realize the context of him living in the period of Russian aristocracy.
i am an audiologist and see an inordinate amount of ear hair. funny, thanks.
Wow I did not know that. That's wild.
The newest version (the one in the article 11.4.42.111) uses Gnome 41.0 "vanilla" -> solaris-desktop
Where do you see that they didn't accept the consequences of their own actions? They just wish it were different/better.

There's no harm in that, and Github being used by millions of developers is a strong reason to make it just a little bit safer for even the rarer cases like these.
My hearing loss got to a point where tuning the hearing aid to the point where it sufficiently amplified sound for me to distinguish speech made it so loud that it sounded to my brain like a normal speaking volume, but it caused physical pain in my ear.
> Male competitiveness plays a huge role in the corporate world, and is a reasonable explanation for why the top of the hierarchy is naturally dominated by males

Could you foresee this being a problem? Such as the best person for a job being passed over for someone more competitive/in the club?

I also refer you to the observed effects of testosterone in financial markets (riskier trades, bubbles) which are typically seen as pathological.

Personally I’m not extremely competitive but do suffer from the ‘testosterone-overdose’ fairly regularly which usually involves impulsivity and rashness.
Sounds like a testable hypothesis, let's look at the evidence:

https://www.gameofrent.com/content/can-lvt-be-passed-on-to-t...

The best empirical evidence available shows pretty strong signs that land value taxes are not passed on to tenants
> I will never understand why people choose VSCode/Jetbrains over a terminal based editor.

I don't want to use my valuable time learning how to get vim working in some super-optimal way that's hypothetically going to improve my productivity by 1%. JetBrains consistently works well enough for me that I'm not going to bother switching. 90% of my life is spent thinking about how to solve the problem so the editor is not the main constraint.
> The famous sage Valmiki was a Shudra who became a Brahmin by composing the epic Ramayana.

Could you cite a reference ? The traditional stories that I have heard from my grandparents tells a different story. That he was born Agni Sharma (Brahmin) and acquired the name Valmiki for reciting the words "death" (mara) which repeated seemed he was chanting "Rama".
a vm running a server is not really "simple", at least not by my idea for static html. i would think a vm/server is only needed if you have specific hosting requirements.

maybe i'm missing something as i didn't see anyone else suggest it, but i would just use github pages, or even something like gdrive, dropbox, mega can host html i think.
Aside from other good techniques mentioned here (have a mediator who is empowered to force a "disagree and commit" resolution, use collective or impersonal language), one useful technique is to focus not on where you disagree, but on where you agree.

For instance: in debugging, even if you disagree on what to try, you probably still agree on what's happening, and that you want to fix it. This changes your task from proving who's right to solving the problem together. It also focuses attention on what you know / can observe to be true.
This whole situation reminds me of the Spanish-American war. At the time Spain was thought to be a great world power, but in reality their ships were old and in disrepair, so much that a rag tag group of Americans defeated them in a few months. The whole Spanish empire collapsed afterwards.
That is an incredible link. Thanks for sharing.
> The same logic could be used in saying the word NO, if a person says NO the first time, he is more likely to say NO the second time, and a third time.

Yes, that's what a verbal tic is, people develop them all the time. But you're purposely ignoring the complexity of human psychology and social dynamics involved in what I'm talking about and employing a reductionist "logic' that doesn't even relate to my point. I'm not the one using black and white thinking.

A better example of what i'm talking about would be the "Big Lie," a propaganda technique employed by Goebbels and Stalin. It works because people will eventually believe something, even something they know to be false, simply because it's repeated often enough. In an environment where one is surrounded by truth-bubbles like social media, that effect is multiplied because the propaganda tends to come from people you already trust.

I mean look at most threads about conspiracy theory here on HN and you'll see plenty of comments justifying conspiracy A because conspiracy B was proven to be true, even though that makes no rational sense. That's the way people are.
https://web.archive.org/web/20220415110524/https://www.econo...
I cringe anytime I go to a friends place and their TV is connected to their network. I can't believe people have gotten to comfortable with the privacy implications of these devices being connected all the time.

It wasn't that long ago that I think it was Samsung was caught with the mic always on or something? I don't remember.

I hate how TV's have gone. I don't really consider myself an audiophile (or the picture quality equilvent) but I am willing to spend money on good sound and picture. Not spend a ton but cleanly middle ground on sound and high ground on picture quality.

I have a 75" tv right now and eying an 85" when I upgrade this thing. I play a lot of video games, watch a lot of movies, so it is very worth it for me. I would happily pay a premium to not have all of this smart tv stuff thrown in that I will never use.

There are display or other dumb TV's but from what I can tell they lack many of the bells and whistles that the top of the line TV's coming out today have. Which is what I care about. For example, getting rid of the Halo effect around lights. Something that could ruin a dark video game or movie.

You could just say "don't connect it to wifi". Well the first obvious problem, I live in a city. There are a ton of unsecured Wifi networks nearby that it would be very easy for the TV to connect too. Even if not, if they entered an agreement with Xfinity and used their shared wifi network... I would wager they would be able to connect almost anywhere.

Problem 2. I have had a number of times that randomly I would have signal issues with devices that had been working just fine. The only possible solution I could find was to update the firmware on the TV. Requiring me to connect it to the internet (I keep an ethernet cable nearby just for this use case) so it could update and likely send all of the data it was collecting anyways.

I always connect an Apple TV to my tv for any streaming I want to do.

That being said, If Apple actually truly put out a Smart TV that just ran TVos and didn't invade my privacy... I would likely buy it and have no hesitation on connecting it too the internet.
Maybe because it’s all easy to find. You don’t need years of experience, just search for the plug-in you need. Sure it’s probably worse, not really portable and possibly insecure, but the barriers of entry are so low that it works great for most people.
You're not competing against the best of the best for every single job. Only 1% of people are in the 1%, and they'll largely be employed in high-wage, high-visibility positions at high-budget employers. In an idealized global market you'd be competing against other people for jobs with desirability commensurate with your own ability.

It's true that if in an absolute sense you're in the bottom rung of the labor pool then a global market will be more likely to sort you into a job with low desirability. I sympathize; I'm from Cincinnati, and if my employer were in the Bay Area (and paying Bay Area wages) it would have been harder for me to get a job there. But I'm not that sympathetic, because a global market means someone with a better fit but no local options can find a job. It means that if the market for data scientists in Cincinnati dries up I still have a chance.
I do not want to learn to fix my car, there is a service for that. I have exactly zero interest in cars apart from driving them to go from A to B.

Some people feel thr same with computrts.

And I do not argue with my parents or wife, weak as I am, just fix the stuff and hope for the best :)
>For one, it's a creative endeavor, where different points of view stemming from different backgrounds can only have a positive effect on the end product.

I'd say it's far more engineering than creative. You're writing code to meet the specifications of a client. I don't think the race of the person writing that code makes a difference.

>Does the product benefit more from being reviewed by teammates from the same schools and employment backgrounds, or by ones with different life and professional experiences

It benefits from being reviewed by people who have lots of experience writing different types of software. Which has nothing to do with ethnic diversity.

>Besides, getting to know people from different backgrounds and cultures can only expand your own view points and make you a better developer

Meaningless platitude, unless you can back this up with data

>Your point about companies pushing diversity to prevent unions sounds conspiratorial at best.

https://www.informationliberation.com/?id=61403
This seems an unnecessary patronizing comment; free speech and all but thanks dad for admonishing others that don’t cater to your sensibilities.

You found a holy war in a disposable comment. You might consider your own knee jerk reaction over something so insignificant.

“Unnecessary unitasker” is not equivalent to “all unitaskers.” Not sure how you can take the language as is an extrapolate so much drama.

Two sentences and look at the thin skins remind me “we’re a society!”
Although a decade late, Oracle should open source the whole Solaris stack with governance model similar to Java Community Process (JCP).

They still can make $$$ from support licenses.
Movie remakes might not be quite enough to make the 30 year number work. I feel like there is some confirmation bias here.

Consider "Happy Days", made in the 1970s to celebrate the 1950s. The wave of mods and paisley jangle pop in the 1980s to celebrate the 1960s. All the "Big Star" sounding bands of the late eighties and early nineties celebrating Alex Chilton circa 1972.

I would guess the movies are a lagging trend, the real number is likely 20 years, approximately equating to mid childhood, early teens as being idealised and getting expressed in successful adulthood at 30 in pop culture by those who experienced those times in formative years.

That would put the first wave of 80s nostalgia in the 2000s[0]

Stranger things is more like nostalgia for early 2000s 80s nostalgia.

Edit: the twenty year rule? [1] [2]

[0] http://www.inthe00s.com/archive/inthe00s/smf/1342451842.shtm...

[1] https://decades.medium.com/how-1980s-nostalgia-ruled-the-200...

[2] https://www.furious.com/perfect/culturecycles.html
If you think a ToS can capture every bigotry, propaganda technique, and misinformation campaign in perpetuity, I am impressed and hope for success in installing it on every centralized internet platform. Otherwise we would need individual humans at a corporation owned by rich men interpreting a vague set of principles about what "hate" and "misinfo" means, which is a different discussion...

But I'm not sure how it could work without having users agree to a new ToS frequently, due to things like the Euphemism Treadmill: https://www.cambridgeblog.org/2020/08/ableist-language-and-t...
What do you mean by "terminal sessions"? I use vim inside regular xterms or tmux. Am I using such terminal sessions already? What would be different in nvim?
We built the first automated solution for streaming tests
People don't realize that walking is a way to think and thinking is work as well.
Many successful people, including Steve Jobs, took long walks during the day. It helps the mind focus and untangle all your ideas in your head.
Of Sound Mind: How Our Brain Constructs a Meaningful Sonic World
> The varna is about individual callings or occupation, not caste as understood today in India.

That's certainly what the caste denialist narrative desparately wants to paint. It certainly is not the consensus.
Thanks for reading. Would love to hear specifics on which facts were false / one-sided propaganda.

My conclusions may or may not end up being true, but hopefully we share the same premises of the conflict.
I came to believe that this types of skills, especially visualization, are learnable. For some people it looks like this skills are somehow natural but this can be just an accident of upbringing and time allocation.

The thing that convinced me that they are not innate is my own journey with drawing and guitar playing. At first (around 15 years ago) I thought that I have some brain deficiency that makes it impossible to visualize things that I draw and remember simple melodies (I even thought that I was tone deaf). But when I invested a lot of time in it (thousands of hours probably) something clicked and suddenly those mysterious abilities materialized in ma head. There surly is some element of talent to it - there are people that would get there a lot quicker, but I believe that for most deliberate practice and a lot of time would do wonders.
Except that I can use vim on my iPad Pro with just a terminal app, which I can't do with VSCode. Vim is portable anywhere you can get a terminal connection, even if it's over serial.
DSPs and other application-specific processors expose the cache hierarchy as a set of scratchpads. This works very well for them, but not for any CPU that is shared between applications, like a server.
neovim should not be named anything-vim for the same reason a Tesla is not a "neomaclaran".
Vim/Neovim/Emacs/etc. require a certain "commitment" to them - you have to learn keybindings, for example. Moreover, if you want any fancy IDE features you're addicted to, like hints, autocomplete, static analysis, refactoring, etc. you have to configure it yourself, which still isn't quite straightforward as selecting a plugin in VSCode (perhaps this is a good feature idea?).

Most people just don't think it's worth it, when the existing tools are Good Enough for them.

But once you pass the initial obstacle, vim/emacs/derivatives are really nice to use, and there are plugins for literally anything out there.
That's part of the point. "Censorship" in this context is essentially moderation gone wrong (either subjectively or objectively, either by accident or on purpose via a bad actor) so as long as there is content to moderate, there will be "censorship". There are platforms with zero moderation (aside from very surface level stuff, like banning illegal content or off-topic threads) - that space is not starving, but those platforms by their very nature can't be a popular enough option to displace the moderated platforms.
I don’t see the need for moralizing. They took responsibility, and offered GitHub money to help. They aren’t leaning in heavily to blame Github here.

It’s fine to express the gulf of evaluation and execution that led to the error. It happened. There may not be any better known solutions at the moment to lower the risk any further.

Calling them careless is also unjustified. They made a mental error processing the information. Whenever humans are involved there is a risk of illogical and bizarre mental errors in decision making because we are degenerating meat robots granted full agency.

Shit happens. How we emotionally deal with it is the test of life as a human being.
Better than :term in Vim 8? How so?
I agree. For me it's not required to know someone personally to be professional, establish trust, and have a great working relationship. If a friendship arises naturally, then great, but I also dislike the forced team building events (or after hour hangouts) companies think are essential for a team to work well together.

And yet I've learned that not everyone is like this, especially nowadays with remote work growing in popularity. Some people do feel that a personal connection helps in a professional setting. So I tend to begrudgingly accept this and make an effort to do this for the team.
Ask HN: What is the best ROI you have seen in Data science projects?
Best ROI in monetary,time or any other dimension
If it fits on a single machine - jq, flat files, JSON lines / avro if relatively flat. Change to a tabular format if when nesting not required.

Postgres JSONB works, but it requires maintaining a heavy server process. So does Lucene/elasticsearch.

I have been yearning for embeddable store (in line with SQLite the support that both works and also keeps the data compressed like JSONB). I know there were some attempts, tried some of it those, mostly monstrosities).
The biggest change came after the migration from Digg, which would have been about 5 years prior.

the_donald brought a lot of a younger users and white supremacists. I haven't seen a DNC-related reddit conspiracy before though. Certainly no noticeable shift that night.
Good to know! I was looking into getting one to replace my Chromecast. If I have to babysit a device's software I might as well just build the hardware myself, too! Even more pain in doing that, of course, but at least it's self inflicted.
It's no longer technically true that sqlite is limited in that way. But that is relatively new territory (compared to plain sqlite or postgres for sure) so you can expect some unknown troubles there.

I'd be willing to launch a product on it in some circumstances, but depending highly on the resources, composition, goals, and risk tolerance of the team. I'm excited about where it's going but DB is so important and the alternatives are so well understood it still feels like a big move.