Frankensqlite a Rust reimplementation of SQLite with concurrent writers

37•rahimnathwani•3d ago

Comments

DetroitThrow•1h ago

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

Jooror•1h ago

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

messe•1h ago

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.

bpbp-mango•1h ago

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

Impressive piece of work from the AIs here.

tekacs•1h ago

It's worth scrolling down to the current implementation status part:

https://github.com/Dicklesworthstone/frankensqlite#current-i...

Although I will admit that even after reading it, I'm not exactly sure what the current implementation status is.

measurablefunc•42m ago

It's fake. It doesn't exist. It never happened. The whole thing is an LLM hallucination. You can notice that it's all half implemented if you read the code: https://github.com/Taufiqkemall2/frankensqlite/blob/main/cra...

tosti•1h ago

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

bigyabai•1h ago

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

littlestymaar•55m ago

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

DeathArrow•1h ago

Was it vibe coded?

kennethallen•1h ago

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

littlestymaar•54m ago

Of course it was.

baq•21m ago

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

anon-3988•1h ago

Clean room implementation yea sure buddy

vvern•1h ago

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

kennethallen•1h ago

And in every training corpus many times over.

burakemir•1h ago

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?

nxobject•17m ago

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

messe•1h ago

> 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.

littlestymaar•56m ago

Isn't that test suite private though?

messe•49m ago

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.

manmal•56m ago

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

messe•49m ago

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

siliconc0w•55m ago

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.

messe•48m ago

It doesn't read ambitious so much as naive.

nine_k•25m ago

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

baq•22m ago

It sounds scifi, but not naive anymore.

measurablefunc•40m ago

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...

baq•18m ago

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.

measurablefunc•12m ago

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.

Computer-generated dream world: Virtual reality for a 286 processor

If AI writes code, should the session be part of the commit?

Evolving descriptive text of mental content from human brain activity

WebMCP is available for early preview

Everett shuts down Flock camera network after judge rules footage public record

Show HN: Timber – Ollama for classical ML models, 336x faster than Python

How to record and retrieve anything you've ever had to look up twice

Right-sizes LLM models to your system's RAM, CPU, and GPU

Show HN: I built a zero-browser, pure-JS typesetting engine for bit-perfect PDFs

Ghostty – Terminal Emulator

Frankensqlite a Rust reimplementation of SQLite with concurrent writers

Tove Jansson's criticized illustrations of The Hobbit (2023)

Why does C have the best file API

Little Free Library

When does MCP make sense vs CLI?

Decision trees – the unreasonable power of nested decision rules

Enable CORS for Your Blog

Have your cake and decompress it too

Next-gen spacecraft are overwhelming communication networks

Show HN: Vibe Code your 3D Models

Long Range E-Bike (2021)

C64 Copy Protection

Microgpt explained interactively

Ape Coding [fiction]

You don't have to

Running Neural Amp Modeler on embedded hardware

Setting up phones is a nightmare

Why XML tags are so fundamental to Claude

Flightradar24 for Ships

Microgpt

Frankensqlite a Rust reimplementation of SQLite with concurrent writers

Comments

Computer-generated dream world: Virtual reality for a 286 processor

If AI writes code, should the session be part of the commit?

Evolving descriptive text of mental content from human brain activity

WebMCP is available for early preview

Everett shuts down Flock camera network after judge rules footage public record

Show HN: Timber – Ollama for classical ML models, 336x faster than Python

How to record and retrieve anything you've ever had to look up twice

Right-sizes LLM models to your system's RAM, CPU, and GPU

Show HN: I built a zero-browser, pure-JS typesetting engine for bit-perfect PDFs

Ghostty – Terminal Emulator

Frankensqlite a Rust reimplementation of SQLite with concurrent writers

Tove Jansson's criticized illustrations of The Hobbit (2023)

Why does C have the best file API

Little Free Library

When does MCP make sense vs CLI?

Decision trees – the unreasonable power of nested decision rules

Enable CORS for Your Blog

Have your cake and decompress it too

Next-gen spacecraft are overwhelming communication networks

Show HN: Vibe Code your 3D Models

Long Range E-Bike (2021)

C64 Copy Protection

Microgpt explained interactively

Ape Coding [fiction]

You don't have to

Running Neural Amp Modeler on embedded hardware

Setting up phones is a nightmare

Why XML tags are so fundamental to Claude

Flightradar24 for Ships

Microgpt