CodeCrafters CodeCrafters

Build your own SQLite

Learn about SQL syntax, SQLite's file format, B-trees and more

Start Building
sqlite sqlite sqlite sqlite sqlite sqlite sqlite sqlite sqlite

In this challenge, you'll build a barebones SQLite implementation that supports basic SQL queries like SELECT. Along the way you'll learn about SQLite's file format, how indexed data is stored in B-trees and more.

Stages

Print page size

In this stage, you'll implement one of SQLite's dot-commands: .dbinfo. This command prints metadata related a SQLite database, and you'll implement one of these values: the database page size. You'll do this by parsing a file that uses the SQLite database file format.

Very easy
We'd expect a proficient developer to take < 5 minutes to complete this stage.
Print number of tables

In this stage, you'll extend support for the .dbinfo command added in the previous stage. Specifically, you'll implement functionality to print the number of tables. You'll do this by parsing a file that uses the SQLite database file format.

Hard
We'd expect a proficient developer to take more than 1 hour to complete this stage.
show all...
“ There are few sites I like as much that have a step by step guide. The real-time feedback is so good, it's creepy! avatar Ananthalakshmi Sankar Automation Team, Apple “ Enjoying programming all over again. It's been a while since I wrote Rust, but getting a good hang of it. avatar Pranjal Paliwal Software Engineer, Headout