skysight-inc/HackerNews huggingface dataset:
I've used SQLite with HashBackup for 13 years and it's been awesome. A lot of the stories I read about "data corruption" with SQLite are, IMO, really about faulty applications that do database commits with the data in an inconsistent state from the application point of view. I've done it myself - it's an easy sin.

I've migrated database versions 35 times over the last 13 years, ie, every individual HB database has been migrated 35 times. You don't always need to make a new table, do a copy, and switch over. In the latest migration, I added new columns, initialized them, dropped columns, etc. without doing a db copy.

For this migration I wanted to switch to strict tables, where typing is strict. I could have done this by just altering the schema (it's just a bunch of text in the SQLite db) and then using SQL to make sure existing columns had the right data (using CAST). But instead, I created a general framework to allow me to migrate data from one schema to another, mainly so I could reorder columns if I wanted. That can't be done with ALTER statements, so I did end up doing a complete copy, but I've done many migrations without a copy.

I found this paper interesting on "zero downtime migrations".

https://postgres.ai/blog/20210923-zero-downtime-postgres-sch...

After reading it, the bottom line is that changes happen within transactions (true for SQLite too), and the key to zero downtime migrations is to use short transactions, use timeouts, and use retries on all database operations, including the migration commands. You can do all these with SQLite.
That only really applies if you believe the advertisers see Twitter as a neatly divided entity, but they don't; they'll see it as a site that does A, B, C, X, Y and Z, all of the above.

And if an advertiser pays a service that, for example, shows terrorist propaganda, then they could be seen as funding and supporting terrorism.

Better to not take the risk. This was another reason why the credit card companies and / or payment providers pulled out (hehe) of Pornhub; they did not verify the age or consent of the people involved, thus were the payment providers complicit in perpetuating this. It would have been morally unjust to keep funneling money into PH if they didn't do anything against them. Not that the payment processors can claim much moral high ground, generally speaking, but you know what I mean.
Any machine learning experts out there willing to weigh in on what they expect to see if Musk does open-source the algorithms used in Twitter's individualized recommendation and overall top-ranking systems? What kind of datasets are used to train these machine-learning models? What's their technology stack like anyway?

Personally I've always had a low opinion of Twitter and have never used it or even looked at it, except by accident when a tweet gets memed somewhere. More often than not my response to reading some 'tweet' is "I am now stupider for having read this." I also loathe the typical recommendation algorithms (Netflix in particular), which assume that you only want to see more the same.

Has anyone ever considered that at least some people still like to see things outside their little bubbles, some novel content, something new, creative, interesting? Those algorithms are reinforcing siloing - here, get in this little box, here's what you and your fellow box-mates like, here's some more of that box content, here's what to think and believe...

Really, the knobs and dials on these recommendation algorithms need to be directly exposed to the userbase, and the overall ranking algorithm and the datasets used to train it need to be open-sourced.
Yes, that one. Some people (me included) have strong reservations about whether that’s an achievable and / or desirable goal.
Which wars are you talking about?
The guy who made a bot to copy data from adsbexchange has almost half a million followers, and is a public figure. I wonder if he would enjoy getting harassed in the same way or not.
A good employer will not judge you based on your half-completed personal work. The point isn't to see perfectly executed programs, it's to get a sense for the kind of interests this person has. Seeing a couple half-finished Go projects is better than seeing nothing at all.
>any scientist name i'll give as a reference will be immediately categorized as "anti-vax" or "fringe and non representative"

That's because they probably are fringe and non representative. And for every Galileo there are 100.000 Dr Wakefield's

> a lot of the consensus around covid vaccines has been proved incorrect times and times again

If that were true it wouldn't be the consensus, by definition.
Nobody who supports Twitter's (imho responsible) use of censorship thinks that Musk's plan to libertarianize Twitter should be illegal, unlike the folks who used to shout "First amendment! Free speech!" about Twitter's moderation. They're just saying that his actions are childish and will make the site substantially worse.

And having seen the arc of many social media sites with "libertarian" moderation, I'm firmly in that camp.

I mean, Hacker News would not be what it is today without firm-handed moderation.
It's only nice if you fully share politics with the moderation team. Which currently works in a very mobster-like manner: for my friends - everything, for my enemies - the law. The rules seem to apply one to some, and many times without any evidence.
Finally the tables turn! Engineers cry "hiring is broken!" not undestanding the game is not optimized for the candidate. The OP: "Resumes are dangerous!" not understanding they're a gate-keeping mechanism that's gamed to get an interview. They were never intended to provide the interviewer with a complete representation & background material. That paper rockstar got an interview; would you have given them one otherwise?
And those 10% are the most vocal and loud ones. So if your platform has those 10% on both sides pissed I don't want to see the results...
I think there’s some truth to it. And the article is an opinion piece.
what does the grimes thing have to do with Netflix? I might just be out of the loop
Because the people with power, the leaders, big tech, advertisers, people with influence, and the media do not like musk. They’ll just start some new trendy site and go there.
I agree with this - I was making the point that austerity, by the terms of its own argument, hasn't worked. Reducing public spending has demonstrably not reduced our debt burden even before the pandemic, and so therefore I would suggest we abandon it.
Pretty nonsense take a I have to say.

You act like Musk is some kind of genocide dictator. Oh my god, he fights with the SEC therefore he must be shot in the head.

> Musk has shown time and time again that his ideals of climate change or whatever are not genuine.

Literally based on what? He has been consistent for 20+ years. Given tons of talks and has literally changed one of the most conservatives industry in the world to a much, much greener industry.

Why did he do Tesla? Do you think he thought 'What a great businesses idea?'.

> He wants to get to play with cool toys, make bold but undeliverable promises, and get as much attention as possible.

When he started SpaceX he was not famous. You can go back to inteview where he was a mostly unknown (at least by people who don't follow Silicon Vally startups). And he already talks about all those things.

The idea that he build a rocket company because he wants to 'play with toys' is just nonsense.

And even if it was, so what? SpaceX achieved what it did, no matter the reason.

> And yet, people look up to him as if he’s some saint bestowed upon us.

He is a successful entrepreneur and engineer. I defend him from people who just make up a bunch of nonsense because they don't like him as a person.

> I truly feel letting a billionaire like him take one of the biggest megaphones in the world private as a personal playground is one of the worst things that could have happened.

Sound like you lived a really privileged life if you think that.

And he already did use it as a megaphone, that is literally what Twitter is.

What exactly are you suggesting would happen?

> And it’s all because he wants to say what he wants to say when he wants to say it, even though he has a history of bullying and trying to shut up people who disagree with him.

Twitter not being owned by him has not prevented him from saying anything. The SEC doesn't care who owns twitter.
But this kind of low-grade humor is exactly what people want to see. Look at how popular this tweet is compared to any of Elon’s about actual Tesla or Rocket things.
Their USP is native, efficient tooling

Why is Android Studio so slow, then?
What has the former British empire got to do with choice of destination? Do you mean English speaking?

I though the reason they aim for the UK is the impression of a good quality of life.
My company merged with a few others, so we are now multi-location. We reorganized, so the people in my room are not the people I work with anymore.
Half of the IT workers are temps, externals, consultants, all over the world. So I spent my days in headphones, conducting meetings.

Our main office is a drive a few hours away. Because of cost optimization, the building is in a less desirable part of town, and a few colleagues had to deal with crime on the way to work. On some days, predicted desk usage is above 100%, but management said that's OK because we'll spend our time in meeting rooms anyway, and we're supposed to empty our desk while we're in a meeting room. There's an endless amount of people shuffling back and forth, so if you're close to a door there is no way to have any concentration.

Seeing all this, why should I go back to my company building? To annoy the people sitting next to me who are not my team members anymore, by having full time meetings over the computer?

Thank god my managers are wise enough to say:this doesn't make sense, stay at home when necessary. But other teams are required to come back and they don't like it. Their bosses wonder why. I want to answer, they are hiding to try and get some work done, but you're not allowing them.
Until Musk changes his mind, or China says, ban all mentions off Taiwan or say goodbye to your factory.
Kinda make sense, though, as what would that "true" really mean? That the function succeeded? But then the result should be the output.
Define success? I think he will help twitter a lot cause they have been suffering from a leadership void for years. I don't think Twitter will become a trillion dollar company but they will be around a long time and be profitable, and there's a decent chance Musk could go public again and recoup some of the acquistion price and remain in control.
Indeed; China doesn't like references to a certain children's cartoon / book character, and nearly two billion people do not take kindly to any kind of disrespect aimed at their prophet.
Are all types of general anesthesia equally dangerous? I believe that some of them work in different ways. I suspect we could find a less dangerous way.
> yet I have a very similar feeling of being slowed down when I attempt to speak those thoughts out loud in real time

Yeah I sound like an idiot when I start talking because my brain will process thoughts much faster than I can speak them and it ends up with odd extended pauses while I catch up and such.

I don’t write particularly well either, often because I’m on a phone and my phone loves to make radical new words via autocorrect but at least I can read over a few times before posting.
I was thinking about forums and how much better they were the other day. One reason, the main reason, was because they learned lessons from Usenet and stopped any flame wars in their tracks. These social media networks didn’t and have let our entire society devolve into a giant flame war. We need systems to force people out of heated conversations and ensure they are engaging in good faith. This requires human moderation but we could surely build tooling to detect if a conversation is heated and force people to take a breather.
I can't say that I've ever felt the emotion of rage when using twitter. People say things I don't agree with all the time, even here. It just doesn't warrant an emotional reaction.

My experience with twitter is great. Things happen and the people that I follow react to them. I see news, machine learning papers and one liner jokes / pithy observations. I've no problems with freedom of speech or any other aspect of it.
The article you reference is specifically on very young mice, and does not attempt to prove that this happens in adult brains of mice or humans.
> The implication here is that this doesn't have a convincing case behind it?

The explication, I guess, yeah. I was and am explicitly saying that, yes.

> Then when would you act?

When the prediction that this may become a issue becomes more convincing, somewhere between where it's at now, and climate change, which already has a convincing case that it WILL become a issue (nay, IS one!)

> maybe proactive caution around big business should be the norm given all the historical abuses

Agreed, proactive caution towards things for which there is a convincing case that it is or may become an issue
It seems like it is an evolution (name change?) of "Heat-insyde", here is an old article with an actual photo of a small prototype:

https://elements.evonik.com/research-and-innovation/salt-sol...

Those old enough (like myself) to remember the Batman TV series will appreciate how the parts of the machine sport clear labels.

There is still the "other" site:

https://www.heat-insyde.eu/
Someone who knows more about Japanese culture and tax policy needs to weigh in, but my understanding is that housing is typically not considered a long-term investment vehicle, to the point that houses are expected to be demolished after some number of decades and depreciated accordingly.

This mindset prevents an established base of property owners from blocking subsequent development, resulting in their property values skyrocketing.

America might have a chance of fixing this with national-level zoning, which will never happen as long as current political alliances are the way they are.
Right. It’s like removing spam.

Frankly, I think Reddit could do the same and give more weight to upvotes from those that prove they’re real.

It could help with disinformation problems and with finding signal.
What existing solution? The point here is that no one found a good solution yet...
Based on the abstract it looks like it's a combination of reference counting and tracing GC that brings improvements in both tail latency and throughput compared to G1 and Shenandoah.

> LXR introduces: i) RC re-
membered sets for judicious copying of mature objects; ii) a
novel low-overhead write barrier that combines coalescing
reference counting, concurrent tracing, and remembered set
maintenance; iii) object reclamation while performing a con-current trace; iv) lazy processing of decrements; and v) novel survival rate triggers that modulate pause durations.

There was a thread just recently debating the relative merits of RC & GC, and here we see them combined smartly.
So who's going to fund this adjudicatory system? Because lots of little $10 deposits, that are fully refundable, won't do it.
Going FROM 5K TO 3M MESSAGES/SEC WITH 2ms LATENCY (2020)
Do toxic users not need to buy things?
Which makes it even worse...
I suppose any decent visual testing tool would work, there are quite a few of them
Just because you want to allow people to speak, doesn't mean you need to force people to listen. The current moderation scheme, which is to provide essentially 1 moderator with no ability to customize it.

The obvious solution to me is just let people pick their own moderation tools, or at least configure it to how they would like. Moderation is great, but what I want moderated is different than what you might want moderated, and we should support broader implications.

This also allows Twitter to gain some independence from the wrath on both sides who want more or less moderation. They can respond by saying "Use the X moderation tool if you want more moderation or "Y if you want less".
As the GP stated repeatedly, it doesn't scale. Number of interactions scales with the factorial of users. The moderation team itself also doesn't scale. Good moderation is very difficult and requires trust. More moderators spreads the trust thin and greatly increases the chance that you end up with one or more bad moderators, who in turn damage that trust.
> I know because right now we're experiencing such a paradigm shift in terms of note-taking and knowledge building (abandoning WYSIWYG word processors in favor of networked-thinking bidirectional-linked graphs of notes), which IMHO sooner or later will extend to programming tools as well.

What paradigm shift? Can't say I've experienced it.
Because moderators need to be competent, understanding and honest. They will not come cheap and these apps have billions of users in some cases.
Most people don't even have that at home! I suspect if everyone had an office at work for "deep work," the commute would be easier to swallow. I, for one, could save some money on rent by moving to a place with one fewer bedroom.
> Bad behaviour (such as causing abuse) results in a penalty being applied to the collatoral.

Cool. Who decides when I visit a random website that my request was abusive?
facebook disagrees with you
> 2) let verified accounts choose to only (or mainly) interact with other verified accounts

That is already a thing if you are verified and one of the reasons why "blue checkmark for $2" (Elon's plan) won't work and will make many verified people unhappy. They don't want even more peasants and "cloud chasers" in their verified timeline.
> who actually bear the brunt of uncontrolled immigration

Any kind of source would be useful for such claims.

> It's not the middle classes who are struggling to find social housing or any housing at all.

I guess it depends on your definition of middle class. Middle class is currently the part that's being squeezed, way more than the poor (you can't get money from someone who hasn't any). So yeah, the middle class does get by marginally better than the poor (who often live in Dickensian conditions, true). But bringing down the middle class is not going to solve any of this. On the contrary, the middle class is what you need to develop to get a healthy democracy. The problem is the long tail of high incomes, roughly from the 8th decile up. Including the well-to-do conservatives who fan the flames and keep spreading the idea that the culprits are everybody but themselves.
A Long Walk in a Fading Corner of Japan
Racist AI
I think to put a finer, nuanced point to it is that there is no positive net health benefit to alcohol consumption[1]. So the mindset should not be "a drink or two confers health benefits" but rather "this is harmful, so I have to make sure I don't do it too often or too much".

This is not my area of study, so any other views are helpful.

1=https://www.thelancet.com/journals/lancet/article/PIIS0140-6...
You are right in general case, but I somehow doubt Musk needs Twitter to achieve narrative control (maybe, as opposed to Bezos with WSJ). It's hardly possible for him to not be able to get across the message. Good public image is evidently his priority, I am just thinking that buying Twitter is not an optimal way to achieve it. He might have something bigger in mind.
I feel they're already being gamified, but by people with an inside line to Twitter, i.e. shareholders and advertisers. If you mean something like search engine optimization on Google by random people wanting to get their content on the front page, I believe there are ways to prevent or minimize that. Of course Google has just gone and pumped advertiser content to the top of search rankings...
>His Tesla stake is worth ~190bn and the rest of his estimated net worth is comprised of SpaceX etc. Not sure why you think that is his Tesla equity only.

Lets say you're right. How did you come to a $80 billion valuation for spacex? The last valuation in 2021 was $100 billion. So spacex has lost value in your eyes? Starlink has happened since. Ukraine happened since.
While this may be technically accurate, the rest of the descriptions on how they interviewed & hired was brutally narrow-minded and biased. You're missing the part where they basically didn't hire anyone with a life outside of computing because you were being hired for an all-consuming death march.
I don't believe you are arguing in good faith so I will not be coloring anything in for you.
In my experience: some security appliance installed somewhere.
Free speech absolutism isn't really the norm in places where people come together for any shared purpose.

Courts and parliaments have rules of procedure so it's not, whoever's loudest wins.

Free speech is never 100% free, there are laws against libel, fraud, conspiracy, copyright, trademark, which create crimes that consist only of speech, or civil liability. And then there are social norms.

It's always a balance between letting 20% of hateful crazy trolls hijack all rational conversation, on the one hand, and blocking unpopular opinions on the other hand. Even HN moderates a lot.

Same applies to all the rights enumerated in the US Constitution, you have freedom of religion to the extent it doesn't infringe on the other important rights and provisions of the Constitution. Polygamy is banned. If your religion says servitude of women or Black people is God's will, you don't get to practice it. 2nd Amendment however broadly interpreted doesn't let you build a nuclear weapon in your backyard.

There are people who want to block legitimate speech they don't want to hear and these should be resisted. A first step toward fascism is indeed people not caring about free speech and thinking their personal discomfort is the most important thing, starting with the most powerful. There are also liars and extremists who want to take a first step toward fascism by extinguishing the ability to have the sorts of rational debate we need in a democracy.

You need to find a balance. You need to protect free speech by having reasonable rules and norms.

"Arbitrary power is most easily established on the ruins of liberty abused to licentiousness." - George Washington
Apple Silicon M1: Black. Magic. Fuckery. (2020)
@al2o3cr What do you think about IP warmup which is widely used by all market leaders for marketing campaigns?
Where did I say anything about me? I really don't know what you're talking about.
Money. Moderators are expensive and if you want it to be any good you need people from the culture you're moderating to understand the context of what is and isn't abusive in a given language. It's also an absolutely terrible job because you're just sifting through the absolute worst of the content on the platform all day.
Are these active usage numbers? I wonder how many of us have created one in the past but never use it. Or what the monthly actives are.

Of my family and friends I only know of 2 who use it actively though most have an account.
I guess the country is un-policed as well, considering that there still are some people who break the law.
Avoiding common pitfalls when communicating with developers
You can store nil in an Option[any] or in any pointer type such as Option[*int].
He said Netflix lost subscribers because it was producing woke content.

It doesn’t make any sense on its face other than as a way to con certain ideologies.

I have Netflix and I consume Black Mirror, Stranger Things, Squid Game, Bojack, etc. Calling Netflix woke is pure virtue signaling.

Maybe he’s planning to run for President?
> Twitter's true customers are its advertisers.

You're basing your assumption that advertisers will be the main source of revenue in the future.
What about the poison pill the board created after Musk announced his desire to move ahead earlier?