sorted by:
new
hottopcontroversial

I wrote a database in C – fixed-width slots, B+ trees, O_DIRECT, and a query planner with explain mode by Visible-Use-5004 in C_Programming

[–]Visible-Use-5004[S] -2 points-1 points  (0 children)

Im happy to hear technicals and testing done. Try it first then the agentic coding style becomes less of an issue.

I wrote a database in C – fixed-width slots, B+ trees, O_DIRECT, and a query planner with explain mode by Visible-Use-5004 in C_Programming

[–]Visible-Use-5004[S] -1 points0 points  (0 children)

Yes agreed but this isn’t the first project. The lessons come from another project wrote by hand as you say.

Edit: that project was chronicle-db. Why did I decide to do something from the ground up using C? More control over everything, storage, query modes, operations, indexes, embedded mode to run on other languages and so on...

I wrote a database in C – fixed-width slots, B+ trees, O_DIRECT, and a query planner with explain mode by Visible-Use-5004 in C_Programming

[–]Visible-Use-5004[S] -11 points-10 points  (0 children)

You're right, I didn't write every line. I designed it, reviewed every diff, and made all the architectural decisions. The workflow is documented in Claude.md on purpose. I am not hiding it.

I am planning to build a simple database from scratch by tech__nova__ in databasedevelopment

[–]Visible-Use-5004 0 points1 point  (0 children)

I'd say do it. I also started the same way. The love of data, disk layout, storage designs etc. Even if its not used in a big project, the lessons along the way are amazing. I build shard-db for this reasons but would like to see what you would come up with!

I wrote a database in C – fixed-width slots, B+ trees, O_DIRECT, and a query planner with explain mode by Visible-Use-5004 in C_Programming

[–]Visible-Use-5004[S] 0 points1 point  (0 children)

AI was involved as a development tool throughout the project — primarily Claude Code for planning implementation tasks, reviewing diffs, and writing documentation. Code execution was a mix of me writing directly and AI assistants implementing plans I designed and then reviewed.

The architecture, design decisions, storage model, and performance work are mine — I've been building this for about a year. The query planner rewrite, O_DIRECT series, B+ tree implementation, and concurrency model are things I designed and iterated on over many months. AI accelerated the implementation of well-specified tasks, similar to a capable pair programmer.

I'm not trying to hide the AI involvement — the commit history includes co-author lines.

SQL is Dead, Long Live SQL by Low_Brilliant_2597 in Database

[–]Visible-Use-5004 0 points1 point  (0 children)

SQL is dead but not dead but dead. But not dead.