skysight-inc/HackerNews huggingface dataset:
If you're using database/sql you don't need locks around database access.

All sane Go SQLite drivers should be concurrency safe.

That said, (and I'm biased but) there's something fishy about modernc concurrency: https://github.com/cvilsmeier/go-sqlite-bench#concurrent

Querying data with 2 threads shouldn't be 2x slower than using 1 thread; 4 threads shouldn't be 6x slower; or 8 threads 15x.

The folks at GoToSocial have long maitained a conccurency fix; I don't know if it's related to this performance issue.

Still the advice about using read-only and read-write connections still holds, for all drivers.

Why? Because in SQLite reads can be concurrent, but writes are exclusive. If you're using WAL, a single write can be concurrent with many reads, otherwise a writer also blocks readers. And SQLite handles all of this.

But SQLite locks are polling locks: a connection tries to acquire a lock; if it can't, it sleeps for a bit and tries again; rinse, repeat. When the other connection finally releases its lock, everyone else is sleeping. There's a lot of sleeping involved; also with exponential backoff.

Using read-only and read-write connections "fixes" this. Make the read-only a pool of N connections, and the read-write a single connection. Then, all waiting will be in Go channels, which is fast at waking waiters, and doesn't involve needless sleeping/pooling. As a bonus, context cancellation will be respected for this kind of blocking.

On this final point, my driver goes to great lengths to respect context cancellation, both of CPU queries (which you need to forcefully interrupt), and busy waiting on locks (which also doesn't work for most other drivers). So you can set a large busy timeout (one minute is the default) with the confidence that cancellation will work regardless. The dual connection strategy still offers performance benefits, though.
What pushes you into saying stuff like that?
I think its funny how some conservatives used to advocate for common carrier regulation because they didn't have much control over social media platforms, now that they do, they don't care anymore about that.

But liberals do seem to stick to their principles of free market capitalism, "it’s his platform and he can do what he wants within the law". I see now why you are so ineffective in combating Trump/Musk if the only problem you have with them is their hypocrisy.

Perhaps you need to come to the realization that if you want liberal democracy you really do need to regulate mass communication platforms in a way that doesn't leech peoples brains out of their ears.
I've used umami for my projects with low volume and it has worked great. Set it up on it's own instance connected to a postgresdb and it's been great for the past year.

Also there is a nice python library for calling the functions directly:
https://github.com/mikeckennedy/umami-python

I do wish it would track bot traffic though. My site of 10m pages is heavily crawled by bots and I wish I could keep track of them a bit more.
Fluoxetine promotes metabolic defenses to protect from sepsis-induced lethality
That's true, but there's no reason Twitter/X has to stay like that.

Stack Overflow has a pretty good model. It does not remove suspended accounts nor their posts (except those directly related to the suspension). It subtly signals that an account is in suspension by reducing the account's 'reputation' (internet points) to 1 and placing a small notice on the profile, usually stating the reason for the suspension (e.g. suspicious voting etc).
The irony the eurodollar system already works like decentralized crypto. There is a ledger of assets and liabilities and the international banks keep tabs on each other.
Its probably not great UX/UI but as an advanced user I never even looked at it. I am typing in a query and the recommendations are only there for a brief moment.
It might, but if so funded by China. (Or maybe you just meant China?)
Anno has Denuvo. So no rootkit. You are thinking of other games that have Easy Anti Cheat or something like that
Actually freedom of speech is a principle, which Musk and his ilk claim to care about, despite using their power to censor people through either direct control of information streams or threats. The first amendment to the US constitution specifically seeks to reify this principle in laws pertaining only to the government's actions, but freedom of speech as a principle can be supported or violated by anyone with power over other people. The people claiming to be "free speech absolutists" are hypocritical even if they didn't also work for the government and enact these vendettas against speech they don't like on a governmental level (which is also happening)
Doxing often involves linking data in public datasets to de-anonymised individuals. Using ADS-B to achieve that is just an implementation detail.

Ultimately, there's little doubt that sharing the real time location of named private individuals is doxing.

It's true that Twitter suspended journalists only 24 hours after the ban on doxing went live, but the penality was minor, and journalists were allowed back after they removed the offending content.
Anyone who has considered child porn speech is smoking something. We have agreed the act of taking pictures or videos of children in those situations to be illegal, it isn't about the meaning or speech a person may apply to that final product.

Slander and death threats are harder to define. You have to show an active plot to commit the crime, not just a statement. At that point the plot, the action you took, is the crime rather than your words.
There has been well-known processes for many years, to produce the relevant antibodies from industrial fermentation processes.

If that is not being done, then it's surely because there is too little demand and the hurdles to get FDA to accept a new, obviously better serum, are too expensive to overcome.
The seed oil advocates are not asking for proof that a new substance is healthy before accepting is use. They took something that as existed for as long as humans have known you can crush seeds to get oil out of them, have actively harmful properties that they can explain.

They have no evidence and make active claims. If you want to join their side on that flimsy logic because it sounds mean or you don’t like big pharma then enjoy the company you keep
you might be having issues connecting to faslty.

afk ghcr uses fastly and docker uses cloudflare.
> According to your logic cyberbullying is just free speech.

IMO it is

> Should I wish for you to by cyberbullied, so you see first hand that free speech has limits?

Feel free to, you have that right. If people choose to act on it I will deal with it on my end appropriately, and I wont be complaining to you to stop saying what you have the right to.
> The only EU member with nuclear weapons is France, which has it's own domestic nuclear ecosystem.

The UK has US-derived (?) nuclear weapons, and so it would perhaps make sense for them to hire the Americans that maintained them:

* https://en.wikipedia.org/wiki/Nuclear_weapons_of_the_United_...

Given the 'waffling' of Trump on NATO support, Poland may want to develop their own.

Also South Korea and Japan may want to ramp up their own native infrastructure given the waffling of US Pacific support.
If this is Go and database/sql (as the modernc tidbit points to) this comment is ill advised.

Go database/sql handles ensuring each actual database connection is only by a single goroutine at a time (before being put back into the pool for reuse), and no sane SQLite driver should have issues with this.

If you're working in Go with database/sql you're meant to not have to worry about goroutines or mutexes. The API you're using (database/sql) is goroutine safe (unless the driver author really messed things up).

To be clear: each database/sql "connection" is actually a "pool of connections", that are already handed out (and returned) in goroutine safe way. The advise is to use two connection pools: a read-only one of size N, and a read-write one of size 1.

Regardless, mutexes are not needed.
Yeah, I just searched for “driver_register”, a call that would show upin a large number of Linux drivers in the open source Linux kernel, not to mention other public-facing repos, and it only returned two results, neither from the mainline Linux kernel repo.
>>Ultimately the system of checks and balances was designed to slow down change.

I think a good part of the world still doesn't get it. Progress is mostly a outcome of stability, not change, even less rapid change.

This whole concept might sound counter intuitive. But think about it seriously. Exponential growth, when you factor in small losses in between comes when you stick to one process(that generates small gains) for long. Not by making rapid changes to a process(in hopes of making one big gain) for a long time.
Show HN: Inscribed, create stop motion animation and slide powered by Excalidraw
Inscribed.app, a slide-based tool for creating stop motions animation and slides.

I've been writing a lot of tech content lately and needed a way to create a stop motion to visualize ideas for my blog.

I'm a big fan of Excalidraw and Apple Keynote, so this tool is an attempt to combine the UX of the two together. Sketch like Excalidraw with a slide making interface (with shortcuts) like Apple Keynote.

Features:
- keyboard shortcuts: copy/paste/del, up/down navigation
- adjust document size
- drag and drop images
- google fonts integration
- presentation mode
- export as GIF, or as iframe to embed everywhere you want.

Try it yourself: https://inscribed.app

Demo: https://www.youtube.com/watch?v=wEXE8-6yEzw

Github: https://github.com/chunrapeepat/inscribed

Hope you like it. any feedback is welcome.
We have years of experience with Trump already. At this point assuming that he will be cruel, irresponsible, corrupt, and vindictive is justified.
https://www.bbc.co.uk/news/uk-scotland-48366184

You should perhaps do more research before making claims like "flat out falsehood".
Wall Street banks have sold almost all $12.5B of debt tied to Musk's X purchase
> We’ve spent billions and billions on the “homes are the solution to homelessness” crowd. And the problem has only grown worse.

The agenda for during my adult life has been cutting services for needy (public housing, mental health, etc). Since we seem to agree that homelessness is getting worse isn't it also rational to agree that cutting these services is, at the very least, not helping.
I don't see his feats as impressive when he was responsible for putting more than half of the population in poverty when he started.

You can look at these numbers and say it's an improvement, but half of the population is still considered poor and the rate at which it's decreasing is not fast enough to consider Milei as a "genius".
I mean, congratulations you’ve explained why the Speechers criticising Twitter were always wrong on this point, but Twitter has now been taken over by people who’ve been pushing a very unamerican idea of free speech so it’s fair game to point out they’re trying to prevent people from using the very system that DOGE runs on.
Lack of empathy for other humans.
> But then I thought that if I had just used that code as is, it probably would have worked but I wouldn't have learned anything about opencv.

A large majority of people would be very, very happy with this. I don't have to know how to fix my car to drive it and thank God for that!

I think it's wonderful that LLMs enable someone to create useful things without understanding what's happening under the hood.

I also hope those people don't claim to be / won't be hired as (senior) software engineers, though.
That is the original title on the BBC article, they changed the title after I posted it here.
Yes, I do. It doesn't distract me a lot, but sometimes my eyes do look at it and it takes a moment to restore the train of thought of what I actually wanted to prompt.
Ceramic brakes are great!
The bit with the implication that only offshore engineers would use LLMs to write blog posts, while the intellectually and morally superior engineers in the US would never stoop to such depths.

(Especially hilarious given it's Uber, which obviously could never have engineers doing anything morally dubious ever /s)
> Freedom of speech, at least in the US, is a concern specifically with the government censoring citizens' speech.

Well, no -- you're conflating "freedom of speech" as a general concept with the first amendment as a legal principle. The first amendment is specifically the mechanism of law we use to ensure that freedom of speech is respected in our interactions with the political state.

The first amendment doesn't apply to our interactions with each other outside of the political sphere, but that doesn't mean that we don't also have expectations of conduct and cultural norms that uphold freedom of speech via other means in non-government contexts.
I am not asking for opinions, I am asking for metrics.

10x is an arithmetic operation. Therefore, to make such an assumption, there has to be a quantity that operation can be applied to.

So, by what quantifieable metric is jj "10x better" than git?
The US isn't "poised". Nobody's talking about actually doing it.

Sure you can write what-if's, but the current administration hasn't brought it up. They've brought up a lot of bad and dumb stuff, but not that.
Thanks for the thoughtful reply on an incediary topic.

I agree with your viewpoint I think, but Im sure as always there are some edge cases which make this definition difficult.
It’s always been free speech for us, not for you.
There's no such thing as an economic institute without an obvious agenda, and generally no way that we know to compute the optimal spending. And even if there was some way to decide how much to spend, there would still be the insurmountable problem of deciding what to spend this money on.

It's pretty obvious that some uses of money are more useful than others - if the state spent large amounts of money on buying snow and storing it in the sun, that's not going to have the same kind of effect as spending the exact same amount of money on building new roads. But beyond obviously silly examples, no one can really agree on even the basics of the effects of government spending in other areas.

For example, a question like "if the government pays very large pensions and social aids, does that increase the economy as much as spending the same amount of money on subsidizing private business?" is extremely divisive in economic circles - with opposing schools of economics claiming opposite results as the "obvious scientific answer".
> The UK

Not in the EU.

And the same NatSec requirements hold.

> Poland may want to develop their own.

A nuclear shield is useless without second or third strike capabilities - which requires a nuclear triad - as both Russia and China have developed those capabilities due to their rivalry with the US.

Poland hypothetically building 10 nuclear devices does nothing if Russia can launch multiple strike after getting striked.

Furthermore, developing nuclear weapons is causus belli enough to justify a hot war for China or Russia, nor does it actually prevent war as can be seen with the Kargil War.

More critically, nuclear programs are expensive and that money is better used in further building out conventional military capabilities, as can be seen with the Russia-Ukraine War, where a country with an ossified MIC (Ukraine) is able to cause significant pain to a nuclear power.

Tl;dr - Nuclear weapons alone are useless in a world where most Nuclear Powers (US, Russia, China, India, Israel) have a nuclear triad and multi-strike capabilities.

> Also South Korea and Japan may

The Indo-Pac theatre is different from the European theatre, as there is bipartisan support to prioritize Asian defense over European defense.

Furthermore, in a situation where American support is reduced, Asian countries can continue to retain conventional warfighting capabilities. This is because defense spending across Asia had always been high since the early-mid 2010 standoffs, so there hasn't been the same level of angst that much of Central Europe has.

Furthermore, Korean and Japanese military exports are extremely competitive, with Indonesia, Vietnam, and Philippines all closely aligning with SK and JP on defense posture.
OmniPod pumps have both iOS and Android apps, as well as a prepackaged Android based device (without a cellular modem.)

This is an area in which technology is hugely helpful, however the development cycle is incredibly slow. Like glacial. It’s unclear how much that’s helping…

That said, I’m super happy to have the options we have at this point.
You don't use X much do you?
And you don't even have to organize. Just participate in the world. Go to improv classes, or play PnP RPGs, maybe in a bar or something. Go to a sport club, learn new things. Don't despair, and don't get caught in the circus. Do the best you can to avoid consuming too much, especially avoid solitary consumption. The organization will come organically.
Tricky? Not really.

Difficult? Yes.
How can you spread all this misinformation? Do you believe it yourself?

Yes, there has been companies trying to exploit the ocean for mining for as long as we have been traveling the seas. There has yet to be a successful attempt at it.

Then a lovely apples to oranges comparison comparing primary energy of one country to electricity mix of another.

Lets do the real comparison, the one you did not want to do because it does not show France is as a favorable light:

Primary energy mix using the substitution method[1]:

- France: 51% low carbon

- Denmark: 43% low carbon

Then we have electricity mix [2]:

- France: 92% low carbon

- Denmark: 88% low carbon

France is wholly unable to build nuclear power as evidenced by the Flamanville 3 program being 7x over budget and 13 years late on a 5 year construction schedule.

The EPR2 program is in absolute shambles due to the insane subsidies required, and now "hopefully" will reach an investment decision (i.e. the government decides on the subsidies) in 2026.

We should keep our existing fleet of nuclear power as long as it is safe, needed and economical.

But only someone with vested interest in the outcome of the nuclear industry would suggest wasting trillions of dollars on nuclear subsidies in 2025 given the state of renewables and storage.

> No country that has invested in renewables has yet managed to get off fossil fuels while France invested in nuclear & nearly completely decarbonized.

And the misinformation continues. When is France going to decarbonize the remaining 48% of their economy?

[1]: https://ourworldindata.org/grapher/per-capita-energy-source-...

[2]: https://ember-energy.org/data/electricity-data-explorer/
You know they won't.
It doesn't list Go types from several k8s projects on github that I contribute to. Feel something is buggy about the filtering as well. I guess he will take some time to iron out all issues - suspect not all his data got migrated into the new db and the DB size should be far greater than 6TB. That feels rather low for github.

But I liked his tip about SQLite driver scalability to avoid that stupid locked error that I too have faced regularly. numCPUS for readers and single writer - will try that out.
Yep it totally is and you are fine to say that about me or anyone else.

If someone takes you up on that offer and you pay them, that crosses from free speech into illegal activity and you will be put in jail. But you are totally fine to talk about if you want.
How long will it take for people to realize, they are looking at a contradiction?
Because you either make it where you grew up or we'll ship you to the Midwest where you're cheaper to deal with, ya fuckin' bum.
> As dumb as it is, Trump ran on these policies and is delivering.

90% of the voting public pays little attention to policy (not saying this is a good thing).

A good portion of people that voted for Trump voted for him because he promised to hurt Those People. And just like Trump 1.0, it's going to end up hurting them as well (per /r/LeopardsAteMyFace):

> “I voted for him, and he’s the one who’s doing this,” she said of Mr. Trump. “I thought he was going to do good things. He’s not hurting the people he needs to be hurting.”

* https://archive.is/https://www.nytimes.com/2019/01/07/us/flo...
The thing which has become very weird for me is watching Star Trek holodeck episodes in the age of LLMs. When I was in high school we considered this absurd writing - obviously they must be sentient...now LLMs have happened and it feels obvious that the opposite can be true.

Same story with Star Wars and droids: C3PO wasn't sentient, just a protocol model loaded into a droid frame in the wrong environment, it's attempts to constantly being the conversation back to politeness being a simplistically coded filter layer.
i think the majority of Vercel customers are doing web site hosting & most of the web requests are IO bound so it makes sense to handle multiple requests per microvm.

can't say the same if customer is doing CPU bound workload.
Is that the HN equivalent of “what’s the point of having Fuck You Money if I don’t say “fuck you”?”
> COBOL quirk where the zero datetime is 1875

This is a piece of misinformation coming from Twitter/X post.
Regulation in the US makes single purpose devices basically impossible to justify from a cost perspective. Also, as the user, a commodity off the shelf device, which can do more than one thing (e.g. CGM and Pump from different manufacturers) is fantastic. +1 million better.
How long do the tax authorities sit on those payments before reimbursing them?
That doesn't hold up because there are 200 year old people as well, and apparently millions of 100-year olds. I'm not saying all of it is fraud but incompetence leading to waste would not be surprising.
Sure, you could easily say that, but it would be a pretty silly thing to say. The world is not black and white, as much as we'd like it to be sometimes.
You're right, and that's were the double standards come in.

Progressives: Elon doesn't care about freedom of speech because he doesn't allow (edge case)

Also progressives: Freedom of speech has its limits

Pick a lane.
You said "poised".

None of that is anywhere close to "poised". You're linking to an article describing a comment from 7 years ago.

"A 2% chance of happening this year" (or even 10%) is not "poised".
It's a relatively recent addition and only appears if you stop typing when you're only a few words in
Why would a job automatically mean housing? This is America, a job only means enough money for housing in some markets.
It also sounds weird to native speakers. Probably just a semantic typo.
Do people in the US still use X? If yes, why? What keeps you on the platform (so the owner is a tiny step closer to destroying your own country)?
This make me curious about exactly what "signal.me" links were all about. The details appear to be available here:

* https://signal.miraheze.org/wiki/Signal.me_URLs

* https://signal.miraheze.org/wiki/Usernames#Username_links

Signal.me links are just a way to easily send either a phone number or user name to someone else. No cryptographic identity. No protection of the phone number or user name. So to get around the ban a Signal user could simply send their phone number or user name over Twitter/X.

It seems that the encrypted username form does provide some identity protection in that it can be cancelled, but for as long as it is active it appears that someone can just ask the Signal server what the associated user name is.

The people involved probably should not be using Twitter/X for this sort of thing in the first place. Mastodon comes to mind as an alternative, but really, anything else.