frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Surveillance data challenges what we thought we knew about location tracking

https://www.lighthousereports.com/investigation/surveillance-secrets/
203•_tk_•2h ago•35 comments

How bad can a $2.97 ADC be?

https://excamera.substack.com/p/how-bad-can-a-297-adc-be
160•jamesbowman•6h ago•91 comments

How AI hears accents: An audible visualization of accent clusters

https://accent-explorer.boldvoice.com/
124•ilyausorov•7h ago•43 comments

What Americans die from vs. what the news reports on

https://ourworldindata.org/does-the-news-reflect-what-we-die-from
292•alphabetatango•4h ago•159 comments

Hacking the Humane AI Pin

https://writings.agg.im/posts/hacking_ai_pin/
13•agg23•6d ago•0 comments

SmolBSD – build your own minimal BSD system

https://smolbsd.org
66•birdculture•5h ago•3 comments

AppLovin nonconsensual installs

https://www.benedelman.org/applovin-nonconsensual-installs/
88•jhap•2h ago•27 comments

Astronomers 'image' a mysterious dark object in the distant Universe

https://www.mpg.de/25518363/1007-asph-astronomers-image-a-mysterious-dark-object-in-the-distant-u...
183•b2ccb2•8h ago•99 comments

Show HN: An open source access logs analytics script to block bot attacks

https://github.com/tempesta-tech/webshield
15•krizhanovsky•3h ago•1 comments

A 12,000-year-old obelisk with a human face was found in Karahan Tepe

https://www.trthaber.com/foto-galeri/karahantepede-12-bin-yil-oncesine-ait-insan-yuzlu-dikili-tas...
204•fatihpense•1w ago•86 comments

Ultrasound is ushering a new era of surgery-free cancer treatment

https://www.bbc.com/future/article/20251007-how-ultrasound-is-ushering-a-new-era-of-surgery-free-...
353•1659447091•6d ago•99 comments

Unpacking Cloudflare Workers CPU Performance Benchmarks

https://blog.cloudflare.com/unpacking-cloudflare-workers-cpu-performance-benchmarks/
36•makepanic•2h ago•3 comments

AI and Home-Cooked Software

https://mrkaran.dev/posts/ai-home-cooked-software/
19•todsacerdoti•1w ago•8 comments

Why your boss isn't worried about AI – "can't you just turn it off?"

https://boydkane.com/essays/boss
145•beyarkay•4h ago•139 comments

ADS-B Exposed

https://adsb.exposed/
261•keepamovin•12h ago•67 comments

Beyond the SQLite Single-Writer Limitation with Concurrent Writes

https://turso.tech/blog/beyond-the-single-writer-limitation-with-tursos-concurrent-writes
44•syrusakbary•1w ago•18 comments

GrapheneOS is finally ready to break free from Pixels and it may never look back

https://www.androidauthority.com/graphene-os-major-android-oem-partnership-3606853/
17•MaximilianEmel•36m ago•8 comments

Show HN: Wispbit - Linter for AI coding agents

https://wispbit.com
19•dearilos•3h ago•10 comments

Prefix sum: 20 GB/s (2.6x baseline)

https://github.com/ashtonsix/perf-portfolio/tree/main/delta
71•ashtonsix•6h ago•28 comments

Zoo of array languages

https://ktye.github.io/
138•mpweiher•12h ago•41 comments

The day my smart vacuum turned against me

https://codetiger.github.io/blog/the-day-my-smart-vacuum-turned-against-me/
191•codetiger•1w ago•82 comments

Why Is SQLite Coded in C and not Rust

https://www.sqlite.org/whyc.html
15•plainOldText•2h ago•10 comments

Testing a compiler-driven full-stack web framework

https://wasp.sh/blog/2025/10/07/how-we-test-a-web-framework
41•franjo_mindek•6d ago•9 comments

New lab-grown human embryo model produces blood cells

https://www.cam.ac.uk/research/news/new-lab-grown-human-embryo-model-produces-blood-cells
78•gmays•4h ago•18 comments

Automatic K8s pod placement to match external service zones

https://github.com/toredash/automatic-zone-placement
76•toredash•6d ago•30 comments

U.S. Sanctions Cambodian Conglomerate, Citing Role in 'Pig-Butchering' Scams

https://www.wsj.com/business/u-s-sanctions-cambodian-conglomerate-citing-role-in-pig-butchering-s...
47•paulpauper•2h ago•8 comments

Show HN: Metorial (YC F25) – Vercel for MCP

https://github.com/metorial/metorial
42•tobihrbr•8h ago•14 comments

Kyber (YC W23) Is Hiring an Enterprise AE

https://www.ycombinator.com/companies/kyber/jobs/BQRRSrZ-enterprise-account-executive-ae
1•asontha•11h ago

Pyrefly: Python type checker and language server in Rust

https://pyrefly.org/?featured_on=talkpython
177•brianzelip•10h ago•124 comments

Why is everything so scalable?

https://www.stavros.io/posts/why-is-everything-so-scalable/
346•kunley•5d ago•320 comments
Open in hackernews

Beyond the SQLite Single-Writer Limitation with Concurrent Writes

https://turso.tech/blog/beyond-the-single-writer-limitation-with-tursos-concurrent-writes
44•syrusakbary•1w ago

Comments

fragmede•4h ago
Can't use it locally (yet?) but it's definitely an interesting move in the space. For my personal projects lately I've been defaulting to sqlite in dev, and having a database wrapper layer to use something else in prod.
stronglikedan•3h ago
> Can't use it locally

I'm imagining some insane replication behind the scenes, where every write is happening concurrently on a different SQLite DB, and then merged together sequentially into some master DB.

frumplestlatz•4h ago
I’m not in a rush to use a reimplementation of SQLite — particularly from startup bros that had a very public, one-sided, and unpleasant fight with SQLite over their contribution model.

D. Richard Hipp is a genuinely fantastic human being, and SQLite is a project developed at literally the level of planetary infrastructure given how broadly and everywhere it appears.

Forking his project while using the name to garner recognition and attention is poor form, and it is difficult to have faith in the results.

bitpush•3h ago
I get where you're coming from, but isnt the whole idea of open source "if you dont like the approach, you're free to fork the code and do it the way you think is right?"

As long as the fork doesnt violate trademark (turso vs sqlite) it is working-as-intended?

I, for one, encourage this kind of behavior. We should have more forks. More forks = more competition = better results for everyone.

---

To make an analogy. Would you say the same thing if this were a for-profit company?

"I cant believe someone else is competing the same space as $x. $x is hugely successful, and so many people use it. I dont know why there's an alternative"

stronglikedan•3h ago
> Forking his project while using the name

The don't use the name. They use Turso. Even the HN title is wrong - the article title doesn't mention SQLite.

They refer to SQLite, but how could you not if that's what you forked from, and that's what has the functionality you're changing. That would be a very weird article if we didn't have that context.

frumplestlatz•3h ago
They state, plainly on their home page:

“The next evolution of SQLite”

That is a material misrepresentation and absolutely trading on the SQLite name

bitpush•1h ago
“The next evolution of SQLite”

How? The whole point of trademark is to avoid confusing users that an alternate product is the same as the original product.

By explicitly saying "Next evolution of SQLite", or "A fork of SQLite", or a "Better SQLite" .. all of this is saying our product is distinct and different from SQLite.

If the fork were called "nue-sqlite" or "sqlitest" or "fastsqlite", there's an argument to be made.

frumplestlatz•1h ago
The issue isn’t that you’re mentioning SQLite or acknowledging that it’s a fork.

The problem is that the phrase “the next evolution of SQLite” conveys continuity and endorsement.

A reasonable reader could conclude that Turso is an official successor or the next release of SQLite — that it represents the official lineage of the project.

Phrasing like “SQLite-compatible,” or “a fork of SQLite” would be clear and factual.

Calling it “the next evolution of SQLite” isn’t factual; it’s marketing positioning, and it implies ownership of SQLite’s identity and lineage.

This reflects a broader pattern in how the fork has been presented publicly.

The messaging often treats the original project as something to be fixed rather than a foundation to be respected.

Referring to Turso as a product while leveraging the SQLite name reinforces that framing — co-opting a public-domain engineering gift into a commercial asset.

Permik•1h ago
I'd still give them the benefit of the doubt as most (all?) of the contributors are Finns who you can almost guarantee to have a "no bullshit" type of mentality to essentially everything. And what I'd guess, the team most probably has quite an academic background because of the local culture.
tracker1•3h ago
Kind of cool to see work on this. I do hope that the final db file result is still binary compatible with SQLite 3 in whatever direction Turso moves towards though... Rust or not.

I've been advocating with several projects over recent years to get SQLite3 as an archive/export/interchange format for data. Need to archive 2019 data from the database, dump it into a SQLite db with roughly the same schema... Need to pass multiple CSVs worth of data dumps, use a SQLite file instead.

As a secondary, I wonder if it's possible to actively use a SQLite interface against a database file on S3, assuming a single server/instance is the actual active connection.

simonw•1h ago
SQLite against S3 can work with some clever tricks. The neatest version of that I've seen is still this WebAssembly one: https://phiresky.github.io/blog/2021/hosting-sqlite-database...

I also got sqlite-s3vfs working from Python a few months ago: https://simonwillison.net/2025/Feb/7/sqlite-s3vfs/

Both of these are very much read-only mechanisms though.

huntaub•1h ago
> As a secondary, I wonder if it's possible to actively use a SQLite interface against a database file on S3, assuming a single server/instance is the actual active connection.

You could achieve this today using one of the many adapters that turn S3 into a file system, without needing to wait for any SQLite buy in.

ncruces•1h ago
SQLite directly against S3 is workable if you mean querying a read-only database.

For example, from Go, you could use my driver, and point it to a database file stored in S3 using this: https://pkg.go.dev/github.com/ncruces/go-sqlite3/vfs/readerv...

For read-write it's a terrible idea. Object storage assumes objects are immutable. There may be some support for appends, but modifying the middle of an object in place involves copying the entire thing.

What is on the verge of becoming viable is to use Litestream to do asynchronous replication to S3, and have read replicas that stream the data directly from S3. But what's stored in S3 isn't a database file, but a format created for the purpose called LTX.

conradev•2h ago
The single-writer limitation in SQLite is per-database, not per-connection. You can shard your SQLite tables into multiple database files and query across all of them from a single connection.

I agree that "the single-writer limitation isn't just a theoretical concern", but it's also solvable without forking SQLite. ulimit's the limit! If your goal is resource maximization of a given computer, though, Postgres is likely a better fit.

asfs4fsdfadf•1h ago
Can someone explain what "ecological niche" this new Turso DB occupies in between SQLite and Postgres?
SchwKatze•1h ago
TursoDB aims to be fully compatible with sqlite, so files you create with tursodb can be read by sqlite and vice-versa. Like sqlite, turso is in-process, so it runs alongside your application, which is quite different from postgres' client-server architecture.

The only think turso has in common with postgres is mvcc, which is a rather standard concurrency control model across modern databases. Idk if I answered your question :)

spiffytech•1h ago
Don't forget that the SQLite team is working on their own multi-writer mode that blows BEGIN CONCURRENT' out of the water: https://news.ycombinator.com/item?id=34434025

Though this stuff moves slowly (that announcement was almost 3 years ago!), so I'm glad to see Turso giving us options today.

simonw•1h ago
Looks like that branch is still under actively development - seven new commits this month: https://sqlite.org/hctree/timeline