skysight-inc/HackerNews huggingface dataset:
OK, that one has 15,948,996 rows.

Here's what I got from running the same "sqlite-utils analyze-tables companies2.db company" command against it:

company.handle: (1/10)

Total rows: 15948996
Null rows: 0
Blank rows: 0

Distinct values: 15948996

company.type: (2/10)

Total rows: 15948996
Null rows: 0
Blank rows: 5253878

Distinct values: 92

Most common:
5311279: Privately Held
5253878:
1290064: Self-Owned
1055857: Partnership
987045: Public Company
828643: Self-Employed
799655: Nonprofit
334552: Educational
87681: Government Agency
35: De financiación privada

company.name: (3/10)

Total rows: 15948996
Null rows: 0
Blank rows: 1591

Distinct values: 15549439

Most common:
1591:
1098: .
277: A
246: -
164: None
155: X
142: N/A
132: ...
128: x
122: 1

company.website: (4/10)

Total rows: 15948996
Null rows: 0
Blank rows: 3249552

Distinct values: 11272926

Most common:
3249552:
86957: facebook.com
57769: instagram.com
46404: business.site
31397: linktr.ee
27882: indiamart.com
21852: wixsite.com
19008: negocio.site
17366: linkedin.com
13224: yelp.com

company.founded: (5/10)

Total rows: 15948996
Null rows: 0
Blank rows: 8040264

Distinct values: 1561

Most common:
8040264:
524236: 2020
451742: 2017
441748: 2018
426575: 2019
418318: 2021
411391: 2016
389487: 2015
339212: 2014
299038: 2013

company.industry: (6/10)

Total rows: 15948996
Null rows: 0
Blank rows: 1334901

Distinct values: 421

Most common:
1334901:
820156: IT Services and IT Consulting
651746: Construction
651557: Advertising Services
465857: Software Development
455111: Business Consulting and Services
447922: Real Estate
435151: Retail
355049: Financial Services
312937: Wellness and Fitness Services

company.size: (7/10)

Total rows: 15948996
Null rows: 0
Blank rows: 2655086

Distinct values: 123

Most common:
6646929: 2-10
3584483: 11-50
2655086:
1197530: 51-200
1091094: 1 employee
421595: 201-500
150053: 501-1,000
129373: 1,001-5,000
44755: 10,001+
27742: 5,001-10,000

company.city: (8/10)

Total rows: 15948996
Null rows: 0
Blank rows: 3155391

Distinct values: 410985

Most common:
3155391:
269708: London
124059: Paris
113135: New York
99314: São Paulo
75428: Los Angeles
69691: Madrid
67328: Toronto
63738: Dubai
63456: New Delhi

company.state: (9/10)

Total rows: 15948996
Null rows: 0
Blank rows: 4524015

Distinct values: 58563

Most common:
4524015:
691167: England
584141: California
329584: Texas
291639: New York
286723: Florida
222552: São Paulo
185925: Maharashtra
171885: Ontario
171657: Île-de-France

company.country_code: (10/10)

Total rows: 15948996
Null rows: 0
Blank rows: 2961064

Distinct values: 272

Most common:
4059985: US
2961064:
1232403: GB
885302: IN
756411: FR
664235: BR
467501: DE
414433: NL
410372: ES
389535: CA
Have you ever noticed the large number on your content blocker indicating how many things were blocked? Most of those are analytics.
Ai is just the tool. The copyright issue is now with the derived work produced by ai.

So what is meant by regulate ai is amend existing laws for the age of ai?
Source for obsctruction from the BLM? As far as I can tell, they carry out controlled burns all the time (what they call "prescribed burning"): https://www.nifc.gov/sites/default/files/blm/documents/BLMFi...
> It's not all about number limits. It's about healthcare and support.

Sure, but numbers can be compared objectively.

> there is no major stigma associated with abortion [in Germany]

I agree, there is a lot more stigma in the US, especially in more socially conservative circles.

> If there's serious danger for the mother, it's unlimited.

This is also true in every US state the last time I checked.

> As far as I know, the situation in france and UK are somewhat similar.

France and UK have an abortion rate twice as high (~17 per 1000 women) as Germany (~8/1000)[0]. So at least there is enough of a difference that Germans get only half as many abortions as the French or the Britons.

For comparison, the US is sandwiched between Bulgaria and Sweden, around ~21/1000.

> a talking point, created to fool americans

I'm not trying to fool anyone. I'm just examining the claim that women in the US, even those in conservative states, are hopelessly oppressed with regards to abortion, so much so that they should be depressed about it.

[0]: https://worldpopulationreview.com/country-rankings/abortion-...
> You have to be a moron to move right now unless you have to.

Not necessarily. The current state of high rates and high valuations (due to few sellers) is very unusual. It is so skewed that, for example, I could sell my condo and use proceeds to pay off my remaining mortgage and buy, for cash, a large house in excellent condition in a smaller town. Someone close to retirement might do that and retire today instead of working another 5-10 years. My 2c.
Shouldn’t Walgreens execs be on trial for not having done proper due diligence before rolling out the tech?
> Contrast that to Go, which is used in real situations internally at Google. They don't need to spy on their users, they have first hand experience using the tool.

And that’s a big disadvantage if I were to scale the usage of Go then I would say startups and middle orgs occupies like 80% if the Go team work according to logic at google scale, Go wouldn’t be this successful
>Note that prescribed fires aren't the only way of removing excess vegetation, there's mechanized mowing and goat herds for example.

Which works fine for the areas east of the Flatirons (that is, the plains), but that's only half the county. A real problem for wildfire management is that they often happen in areas that we consider undevelopable, which is to say, difficult to get into and out of.

I recall going climbing in Boulder Canyon some decades ago, looking up at some burn scars and thinking "it would be several hundred feet of technical climbing to even reach where that fire occurred". Fighting it would be simply out of the question, and prevention without controlled burns would be just as difficult.
How is your attitude not equivalent to "I can't trust myself to see things I disagree with, I am so weak-willed that there is the horrific danger that I will start believing them"?

There are reasons someone might want to find those links, even if they disagree with them. When Google hides them from you without your consent or ability to opt out, they're treating you as if you were a child. Or perhaps more like livestock.
I love riding my motorcycle through the mountains of Santa Cruz through Big Basin. The way the Redwoods surround you is just incredible, and the fresh air is just as regenerative as the trees themselves
> just like it's possible every asshole who did it before him was due to a genuine desire for the good of humanity.

So.. you're saying that every person that testifies before congress has bad intentions just because they testify before congress?

Say he did want what was best for humanity, how should he have acted differently in front of congress?

To me, from every interview I've heard from him, he doesn't seem like a Zuckerberg.
Yeah, erm, no, just NO.

Unless we're talking about A-grade corporate or government debt. Which isn't guaranteed, of course, but at least its a relatively sensible area to dabble in if you want to play the game.

Anything else, whether "junk bonds" or any of the more "exotic" items listed in this blog post are the sort of thing you should not touch with the proverbial bargepole.

Why ? Because there is a reason those sort of debts are debts...

Remember the 2008 financial crash ? Remember what was a significant part of the cause ?

Yup. That's right.

Initially it was packages of "harmless" mortgage-backed securities and collateralised debt obligations (CDOs).

Then people got greedy and started re-packaging sub-prime loans.

And the rest, as we know, is history.

So, unless you are genuinely, honestly and absolutely certain that you are willing to loose the money you have "invested", which, let's be honest, the majority of people cannot afford to loose the money ... just steer well clear.
There has never ever been a better time to jump ship from GA. All of your historical GA data will NOT be viewable in your GA4 property. The biggest moat they had was millions of sites with multi year page view data for easy trend comparisons. The moat is now broken and they don't care. GA4 and the forced migration is being handled so bad the only explanation is they would rather nobody use GA anymore.
I don't think anyone keeping a 1948 Dodge Custom 6 deludes themselves into thinking they're being productive in doing so, or that they're doing it because they're been too gosh darn busy to learn how to operate a new car for the last seventy-five years.

People who keep '48 Dodges running (or Windows 95 running) do so out of love. And I'm totally on board with that. I just find it a little silly to pretend otherwise. It's not a rational decision to keep a '48 Dodge running, or Windows 95 running. There's no productivity gains that aren't immediately devoured by the expense and time of upkeep.

Thankfully, not everything in life needs to be productive or rational. Do what you love, be unproductive, kick dirt, boot Amigas!
Shynet
The problem is that learning one hinges on the other, and you can't understand the practical at the depth AoE goes into without first understanding the theory.

Someone in the thread mentioned it was designed for physicists. It might be okay there. That's a kind of unique background where someone might understand the theory without the application. However, most of the time I've seen it used, it's a recipe for frustration.
I believe that 2 is a magic number here, and we are stuck with it. No new platform can emerge unless it supports every app from one of this two.
"... storage is their business so I expected way better."

Storage is our business and we target an even worse 99.95% availability[1].

Availability has a cost. That cost is complexity.

We would very much prefer to have boring outages more often than have fascinating outages very rarely.

[1] https://www.rsync.net/resources/notices/sla.html
> There have been no objective improvements since Windows 7 that I can think of

I think this is pretty rude to the many people who have contributed to Windows in the years gone by. I won't argue that there hasn't been some crappy things added or on the advantages/disadvantages of later Windows versions but there have been plenty of things added since Windows 7. Some I can think off just off the top of my head

* Credential Guard - protection of secrets in the lsass process even from kernel access

* gMSA support - Windows 7 could only use standalone MSA accounts which weren't as useful

* Windows LAPS - now supports encryption and is builtin to the OS

* Schannel improvements - newer cipher suites and TLS protocols (cipher suites in Win 7 are right at the edge of what people might support these days)

* SMB 3 - encryption, compression, better integrity/mitm/downgrade protection over SMB 2

* WSL

* Windows Sandbox

* Windows Terminal - including ConPTY support in the underlying APIs

There's plenty more out there but these are pretty important features for me to have on Windows. Granted some only make sense in a more corporate/domain environment but not all of them.
That would make it 0.75 tokens to 1 word right?
How could AI practically be regulated? Would this be the first illegal algorithm?
Why would I move when it took me so long to make friends and find a community at my current location?
The thing I find most interesting is this:

269708: London
124059: Paris
113135: New York
99314: São Paulo
75428: Los Angeles
69691: Madrid
67328: Toronto
63738: Dubai
63456: New Delhi

I would not have expected São Paulo to come fourth in this list, after New York but in front of Los Angeles. I just learned it's the 4th largest city in the world https://en.wikipedia.org/wiki/List_of_largest_cities - after Tokyo, Delhi, Shanghai - but I guess it has much more of a representation on LinkedIn than those other cities.
They're actually reasonably good. I often find that they do weird things like linking to non-US versions of websites instead of a US version. So I end up on the British or Dutch version of a website, with prices quoted in GBP or EUR.

I find myself using the "!g" shortcut (which takes me to Google) more often than I'd have liked to.

Thankfully, Apple offers this as one of their search engine options (despite being paid "tres comas" every year from Google to be the default search engine).
Of course you do not mind. But that means that you have no room for complaint when they delete something that you consider to be "not garbage".
`rm -rf /` could be a set of 'bad words' too. Or `shred -uf /dev/sda`
I'm a software engineering manager.

I'm responsible for the wellbeing of my direct reports. I need to ensure they can grow their careers. I need to know when they're stressed or burnt out or bored. I need to manage projects and be a shit umbrella.

While I am technically strong, I have architects and technical fellows who are WAY stronger than me. I work closely with them to ensure we're adopting the latest best practices and tools. They do much of the system design. They also mentor newer employees, but they don't have direct responsibility for those employee's careers. And they don't have direct responsibility for the success or failure of any given project.
No. In situations like this the best you can hope for is that his incentives aren't at odds with the rest of humanity.
95 needed at least 4MB, ideally 8MB or more of memory. Which means it will fit in the cache of modern CPUs many times over, though I may be ignoring some swap stuff.

512MB isn't a lot today so might as well use it, at least for things that are useful, but it's nevertheless impressive how puny these old operating systems were, despite having user-facing functionality that would still feel familiar and natural to today's users.
To borrow from Jerry Maguire: you had me at physical qwerty.
As everyone has pointed out, this does not count. Note that the idea that regex can't parse html is specific and proven. What it means is that you can't write an expression that matches both the opening and matching closing tags. There's no way to handle nested tags within a single regex. It's only possible to write a regex that matches up to a finite nesting limit.
It’s like saying “I have no basis in differential equations or complex numbers or Newtonian mechanics or experimental findings on the wavelike nature of light but could somebody explain the Schrödinger equation derivation like I’m five?”

Like, there’s a reason we don’t explain things to five year olds.

Also I have a good ELI5 answer, so I don’t know what else you want dude lol so petty
America chose to build itself around cars, which makes it politically untenable to put any non-trivial gate in front of driving, which is why you can pass a half hour "test" once at 16 and be set for life, even as you approach dementia. It's even worse now, because even if we succeed at making automobiles not a necessity for average life, a huge subset of the american population believes they are a core part of their identity.
> to make sure that a compiler cannot do anything other than reading its input files (and system headers/libraries/etc)

Define "input files." Tools have to do a combination of reading, parsing, and sometimes even version unification/downloads just to get the complete set of inputs to feed to the compiler.

Of course you can define the compiler as the tool that parses text and writes machine code, but then you're just shoveling dirty water around.
It's an LCD, poor titling.
> LLM Developer

This is the fastest I've rolled my eyes in a long time!
They mention that they could finetune a 6B model for $7. Obviously the number depends on the amount of data and the model size but it's probably not going to be a significant expense in practice.
I use it for my blog's search function:

https://github.com/fazalmajid/fts5index

Their default syntax is not great, so I wrote a converter from Google syntax to theirs.
I'm imagining you tackling it on foot now.
After an hour my laptop was about to crash so I uninstalled it. It was using 8Gb of ram out of 8.
I am using both, I have one laptop dedicated to kde to make sure I don't miss out on anything in case both evolve in different directions. I make sure I still use the kde one once in a while...but I still tend to go by preference to the one running Gnome.

So they might have more problems but it doesn't necessarily translate in worse user experience for all users. The file picker was one example but I don't see me use very often a file picker, I am more a drag and dropper these days. It may be because file picker is not that great on Gnome, but I just checked the kde one today...and realized that meh. I'd still rather use dolphin on kde to drag and drop to a particular app than go to open --> file and choose it in the file picker. It seems just more convenient to me.

So KDE seems more flexible, and may fix issues that count for the 0.005% of the population, but the configuration panel feels like an airliner cockpit. Gnome may not care about what annoys 0.005% of user but the experience seems to be more straightforward to many and less choice means less stuff to configure to your liking the day you switch from one computer to another. You'd really have to backing up your .config preciously if you start customizing kde to your liking.

In the end it is great both exist, as well as the alternatives and the standalone window manager. On screens 10" and smaller and on older and slower machines I still prefer using a tiling wm.
Arguably OpenAI's moat is the heavily subsidized Microsoft Azure infrastructure to train its models and serve traffic, but your point still stands: government regulation will be a more reliable moat. Especially as the latest LLM models (e.g. LLaMA) are shrinking in size while maintaining performance parity.

I wonder if government will end up enacting any legislation or this scrutiny will blow over until something egregious happens (e.g. Cambridge Analytica). They've shown zero willingness to legislate any consumer data privacy laws so far.
> There’s a fundamental disconnect between how hard it is to relocate and how easy it is to lose your job.

This is it. The risk is completely one-sided and massive. Just ~6 months ago a recruiter reached out with a job that to be honest was perfect for my career path goals. But not remote, they wanted me to move across the country. Briefly considered it but it makes no sense, the risk is way too unreasonable.

If a company wants me to move, give me a contractual guaranteee of at least two years salary to be paid even if they reorg my position away. Then it's fair game.
I hope one day when Google forces us to migrate to Google Next Analytics Product™ my org will finally get fed up and switch to something stable. I’m philosophically opposed to analytics in the first place and would really like to never have to think about it again.
No x64 (AMD64) version of Windows 2000 ever existed. AMD64 CPU's didn't debut until 2003 and XP x64 was based off the work done on 64-bit Server 2003 for Intel's 64-bit Itanium chips

There was a brief period of Alpha machines that ran 64-bit CPU's that had early "Whistler" builds but nothing ever released to the public
The exploding offers I love the most -- are the ones that come after a ridiculously long process, itself saddled with weeks of radio silence and surprise extra rounds. Topped with handy-wavy descriptions of benefits, and essentially no room for you to ask questions about actual working conditions.

Because why wouldn't you just love working there?
It's better than the current product where it's readable in plaintext to Twitter employees, and to some outside contractors as well.

For those who already use Twitter DM's (which is a lot of people), this is an improvement.
It's turned into an ironic site where everyone always wants to lambast the newest tech, whether it's crypto or AI or even still web technologies like React. The irony comes from the fact that Y-Combinator funds all of these sectors and the original intent of this site was to discuss interesting new tech...
Who is this Linux you speak of and does he develop everything for the OS with the same name him/herself?

Seriously though, if the problems you mentioned are shared by enough people, someone will make something like that. Chances are though that something fitting your needs already exists or they are so niche/specific/nitpicky that you'll never find what you're looking for (in any OS).
> Everybody’s talking about money

I agree with you, but people are talking about money because in this context it's likely money that would be (hypothetically) motivating the move in the first place.
As a trans person, I have to disagree in the strongest terms.
> Outside of self driving cars

This is what I find so hilariously suspicious about Elon Musk's sudden anxiety about the dangers of AI chatbots. Like, dude, you've spent the better part of two decades making cars that drive themselves and have _already_ killed people with their faulty, ironically oversold "AI." Now all of a sudden someone else's AI, which isn't in the drivers seat of vehicles capable of 100mph+ speeds, and which actually works, is an existential danger to humanity?
just to point it out, laws like GDPR do not mention "cookies" anywhere. It's regulating how you may or may not retrieve and store ANY data that makes an individual identifyable.

The whole "cookie" topic is a dark pattern mostly pushed by ad providers as a friendly word to bypass having to say "may we track everything you do?".

So if it tracks data points that can be used to clearly identify a visitor, or marks the visitor in a way that can be used to personally identify them later, it will need the users consent, regardless of where and how this is stored.
>Begin crazy tinfoil hat rant...

And then you proceed to describe the exact situation that has been unfolding. Capital always seeks to achieve the highest returns possible by any means necessary. All of these things are just the logical steps a party interested in profit above everything else would take. No conspiracies needed, just cold brutal profit seeking behavior.
> This was the kind of decision that could instantly change the reputation of a PL, for purely political / psychological reasons.

Go already has a bad reputation for political reasons.
Exactly. I'm currently building in-house analytics (thanks Clickhouse) due to GA4 as well.

The only way I'm able to use GA4 in any way is with their search box + autocomplete, you can sometimes get a decent query result, then you click the three dots next to the tiny line chart, export as CSV and you get the data.

And for events, I think they want you to pay for BigQuery, so you only get some kind of aggregate count, which is useless. It'a too confusing to figure out if I'm wrong about that.
In this case they are creating a service and selling it, so it's not like they just decided to roll their own analytics because they hate GA4.
> then claimed that they were violent

If you're assaulted at somebody's house but you overpower them, you don't get to loot them. This isn't D&D.
Much of the "antivax garbage" turned out to be true. In hindsight, do you still believe that censoring true but inconvenient information is morally acceptable?
It’s way easier to tie everyone up in manipulative bullshit court proceedings in the US, and no one has the incentive/interest in stopping it right now.

It isn’t even about 10-100x cost, if it was straightforward cash. It would be resolved in weeks if that was the case. In many of these equivalent situations, it drags out for decades. At that point, it’s a toss up if the project even makes sense anymore, since everyone who needed it when it was voted in/started has moved on (by necessity) to something else.

In China, the courts basically just say ‘which way does the CCP want this to go?’ and voila, that happens. For better or worse.
Not necessarily, at least on my M520-based X201 it got slower in media-related workloads with recent kernels (last 1.5 year or so). But both KiCad and FreeCad are faster than in Win7.