Hacker News

Top stories

Live mirror
30 storiesupdated just nowView source snapshot
  1. San Francisco Onion Futures Company(onionfutures.com ↗)
    24comments
  2. Android 17 is the first since 3.x to add new APIs without releasing to the AOSP(grapheneos.social ↗)
    342comments
  3. Science Is Open Software(jepedersen.dk ↗)
    16comments
  4. Typesafe-computer-use drives a Mac toward a goal for 1/50th of a cent per step(github.com/awlevin ↗)
    4comments
  5. SDCC – Small Device C Compiler(sourceforge.net ↗)
    9comments
  6. Cloudflare Quick Tunnels(cloudflare.com ↗)
    270comments
  7. How OpenAI Used Its Own LLMs to Design Its Jalapeño Chip(ieee.org ↗)
    71comments
  8. Saving another 100TB of RAM(cloudflare.com ↗)
    58comments
  9. Why building a Rust LSP is hard(rust-glancer.github.io ↗)
    13comments
  10. How to Write with an LLM(sockpuppet.org ↗)
    305comments
  11. NASA-IBM Lunar Foundation open-Source Geospatial AI Model(usra.edu ↗)
    discuss
  12. Harm Laundering in GPT Models: Gender Discrimination Transformed Rather Than(arxiv.org ↗)
    discuss
  13. Goroutine Leak Profiles(go.dev ↗)
    1comments
  14. Xcode 27.1 Beta Release Notes(developer.apple.com ↗)
    75comments
  15. The first new cat species discovered in 100 years(nationalgeographic.com ↗)
    86comments
  16. Show HN: Cactus Needle 3: 8-29MB automation models can match DeepSeek V4 Flash(cactuscompute.com ↗)
    82comments
  17. Photon-Emission-Guided Laser Fault Injection Enables RP2350 Secure Debug(ledger.com ↗)
    61comments
  18. OpenJev(openjev.com ↗)
    250comments
  19. You can run Git on object storage if you re-make packfiles(tigrisdata.com ↗)
    discuss
  20. The Farnese letter(simonklee.dk ↗)
    6comments
  21. Cache-to-Cache: Direct Semantic Communication Between LLMs (2025)(arxiv.org ↗)
    12comments
  22. Minimal Phone 2(minimalcompany.com ↗)
    200comments
  23. Claude Code now reads AGENTS.md if there is no Claude.md(claude.com ↗)
    211comments
  24. Show HN: LiveWorld – Every 24/7 YouTube live camera on one globe(liveworld.info ↗)
    32comments
  25. Cyclomatic Complexity in C#(ndepend.com ↗)
    16comments
  26. LispBM is a concurrent Lisp for microcontrollers with message passing(lispbm.com ↗)
    3comments
  27. Inside ZCode: Silently uploading your Git history to the cloud(ferstar.org ↗)
    95comments
  28. Alibaba open-sources AI model that can detect cancer and nearly 150 conditions(scmp.com ↗)
    10comments
  29. Warez: The Infrastructure and Aesthetics of Piracy (2021)(archive.org ↗)
    40comments
  30. How SpaceX streamlined the Raptor engine(construction-physics.com ↗)
    63comments

Frankensqlite a Rust reimplementation of SQLite with concurrent writers

57 pointsby 6mo agofrankensqlite.com
58 comments
6mo agoHN ↗

Love the "race" demo on the site, but very curious about how you approached building this. Appreciated the markdown docs for the insight on the prompt, spec, etc

6mo agoHN ↗

Is the implementation untouched by generative AI? Seems a bit ignorant/dishonest to claim “clean-room” in such a case

6mo agoHN ↗

AGENTS.md and COMPREHENSIVE_SPEC_FOR_FRANKENSQLITE_V1_CODEX.md in the root folder, and ugly AI slop image on the home page and README.

A better question is if the implementation was touched by anything other than generative AI.

6mo agoHN ↗

I was looking at this repo the other day. Time travel queries look really useful.

Impressive piece of work from the AIs here.

6mo agoHN ↗

We are going to get overwhelmed with this stuff aren't we.

6mo agoHN ↗

The people who understand basic logic will be fine but I'm starting to think that's a very small group of people.

6mo agoHN ↗

Says on top it's called monster but then it speaks of frankensql. Confusing website imho for a nice project

6mo agoHN ↗

While I don't think the website is particularly well-designed, "monster" can be used as an adjective.

6mo agoHN ↗

There's a limit to what Claude can do without a competent human helping …

6mo agoHN ↗

Extremely. Repo is littered with one-off Python scripts, among many other indicators.

6mo agoHN ↗

Nobody in their right mind would sponsor this project to be hand written.

6mo agoHN ↗

Why does clean room even matter given SQLite is in the public domain?

6mo agoHN ↗

And in every training corpus many times over.

6mo agoHN ↗

Looks mildly interesting, but what's up with the license?

MIT plus a condition that designates OpenAI and Anthropic as restricted parties that are not permitted to use or else?

6mo agoHN ↗

Good luck enforcing that. "Glad" to hear that Gemini's excluded.

6mo agoHN ↗

Where do you see issues enforcing license terms?

6mo agoHN ↗

The fact that they've hosted it on GitHub means they've agreed to GitHub's terms, which allows them (via OpenAI) to train on the code.

Also it's pretty hilarious to vibe-code a library that clones another library that someone has spent decades of work on, and then try to prohibit people from using that LLM output as training data for an LLM.

6mo agoHN ↗

TCL test harness. C SQLite's test suite is driven by ~90,000+ lines of TCL scripts deeply intertwined with the C API. These cannot be meaningfully ported. Instead, FrankenSQLite uses native Rust #[test] modules, proptest for property-based testing, a conformance harness comparing SQL output against C SQLite golden files, and asupersync's lab reactor for deterministic concurrency tests.

If you're not running against the SQLite test suite, then you haven't written a viable SQLite replacement.

6mo agoHN ↗

The TH3 test suite is proprietary, but the TCL test suite that they refer to is public domain.

I'm not sure where they get their 90k CLOC count though, that seems like it might be an LLM induced hallucination given the rest of the project. The public domain TCL test suite is ~27k CLOC, and the proprietary suite is 1055k CLOC.

6mo agoHN ↗

Thanks for the clarification, I appreciate it.

and the proprietary suite is 1055k CLOC.

Why is the code size of the proprietary test suite even public though?

6mo agoHN ↗

You can buy access to it.

Any serious SQLite re-implementation should buy it and test against it.

6mo agoHN ↗

The cost of TH3 is listed as "call".

It's much more likely the issue is one of cost, not of seriousity.

6mo agoHN ↗

Given that the project and websites are entirely vibe-coded, I don't think they passed the call to get a quote.

6mo agoHN ↗

I thought I read somewhere that their full test suite is not publicly available?

6mo agoHN ↗

The TH3 test suite is proprietary, but the TCL test suite that they refer to is public domain.

I'm not sure where they get their 90k CLOC count though, that seems like it might be an LLM induced hallucination given the rest of the project. The public domain TCL test suite is ~27k CLOC, and the proprietary suite is 1055k CLOC.

6mo agoHN ↗

This and this needs Jepsen testing.

The value of SQLite is how robust it is and that’s because of the rigorous test suite.

6mo agoHN ↗

If this wasn't ambitious enough, the author is also porting glibc to rust. As I understand it, all of it is agentic coded using custom harnesses.

6mo agoHN ↗

It entirely depends on how much the author reads the result of the agentic coding.

6mo agoHN ↗

Not very much judging by the commit rate.

6mo agoHN ↗

It depends on much more than that, including the author's ability to interpret, understand, and act on what he reads to improve any problems.

6mo agoHN ↗

If you can't tell this is LLM slop then I don't really know what to tell you. What gave it away for me was the RaptorQ nonsense & conformance w/ standard sqlite file format. If you actually read the code you'll notice all sorts of half complete implementations of whatever is promised in the marketing materials: https://github.com/Taufiqkemall2/frankensqlite/blob/main/cra...

6mo agoHN ↗

If you bothered to do any research at all you’d know the author as an extreme, frontier, avant-garde, eccentric LLM user and I say it as an LLM enthusiast.

6mo agoHN ↗

Thanks. Next time I'll do more research on what counts for LLM code artwork before commenting on an incomplete implementation w/ all sorts of logically inconsistent requirements. All I can really do at this point is humbly ask for your & their avant-garde forgiveness b/c I won't make the same mistake again & that's a real promise you can take to the crypto bank.

6mo agoHN ↗

Great! But note I haven’t said that you should be doing the research. This was more of a warning about today, but it also was a different kind of warning about the next 12-18 months once models catch up to what this guy wants to do with them.

6mo agoHN ↗

Thank you for your wisdom. I'll make a note & make sure to follow up on this later b/c you obviously know much more about the future than a humble plebeian like myself.

6mo agoHN ↗

Even though it looks like LLM slop, we are starting to see big projects being translated/refactored with LLMs. It reminds me of the 2023 AI video era. If the pattern follows, we will start to see way fewer errors until it is economically viable.

6mo agoHN ↗

This kind of slop spewing into Github feels like the modern equivalent of toxic plumes coming from smoke stacks.

Utterly unmaintainable by any human, likely never to be completed or used, but now deposited into the atmosphere for future trained AI models and humans alike to stumble across and ingest, degrading the environment for everyone around it.

6mo agoHN ↗

It's kinda like when the web first started taking off then there were WYSIWYGs. Everyone and their mom was creating static HTML websites.

But nobody shows off static HTML sites on HN.

6mo agoHN ↗

This is a really interesting potential problem. I wonder how providers are going to avoid training on slop?

6mo agoHN ↗

Yeah, “rewrite in rust” strikes again, this time equipped with a AI slop generator.

6mo agoHN ↗

We need to ban this kind of AI slop yesterday.

6mo agoHN ↗

There is a popular [excellent non vibe-coded] web server called FrankenPHP; A port of PHP to Go bundled with Caddy.

Are there any other FrankenProjects out there that have had any success?

Were we so impressed by the concept of the original Frankenstein?

Is this a Freudian slip, that we are expecting these AI projects to turn on their creators?

6mo agoHN ↗

Whats the obsession with concurrent writes?

Single writer will outperform MVCC as long as you do dynamic batching (doesn't prevent logical transactions) and all you have to do is manage that writer at the application level.

Concurrent writers just thrash your CPU cache. The difference between L1 and L3 can be 100x. So your single writer on a single core can outperform 10-100s of cores. Especially when you start considering contention.

Here's sqlite doing 100k TPS and I'm not even messing with core affinity and it's going over FFi in a dynamic language.

https://andersmurphy.com/2025/12/02/100000-tps-over-a-billio...

6mo agoHN ↗

i reimplemented my Grandma in Rust. She was a real Safety and Security hazard to herself and her surounding. She forgot things and made unsound memory assumtion. Took me about 3 Days vibe coding with Claude Code and was a real fun time. Now my grandma is leaking anything and has some new comandline switches. To be fair i know best how to implement Grandmas and everybody should use my Grandma from now on. If this breaks your scripts just adapt. Sure this was very cynical but im so tired reading every week some new pet project where rust is seen a mesiah. It is a new language, it helps getting memory right more easy. It is like the new visual basic.

6mo agoHN ↗

Really, rust folks should stop using original projects names. It's not related to sqlite, it's very loosely inspired.

6mo agoHN ↗

s/rust/llm/ doesn't really matter which language the slop is produced in

6mo agoHN ↗

didn't notice at first, but my CPU fan went silent the moment I closed this slop website