CodeCrafters
Build your own SQLite
Learn about SQL syntax, SQLite's file format, B-trees and more
Start Building
C#
Go
JavaScript
Python
Ruby
Rust
Zig
Clojure
C++
Java
C
Gleam
Kotlin
TypeScript
Elixir
This challenge requires a CodeCrafters Membership.
You're welcome to study the full challenge structure and stage instructions for free. A membership is needed for submitting code and viewing solutions.
Want to try a free challenge? Try Build your own Shell — it's free this month.
SQLite is a popular SQL database engine. In this challenge, you'll build your own version of SQLite that is capable of reading a SQLite database file and answering basic SQL queries like SELECT and using indexes.
Along the way, you'll learn about the SQLite file format, SQL syntax and more.
Stages
Print page size
Login via GitHub to view this stage
Print number of tables
Login via GitHub to view this stage
Print table names
Login via GitHub to view this stage
Count rows in a table
Login via GitHub to view this stage
Read data from a single column
Login via GitHub to view this stage
Read data from multiple columns
Login via GitHub to view this stage
Filter data with a WHERE clause
Login via GitHub to view this stage
Retrieve data using a full-table scan
Login via GitHub to view this stage
Retrieve data using an index
Login via GitHub to view this stage
RECENT ATTEMPTS
0
“
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!
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.
Pranjal Paliwal
Software Engineer, Headout
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.
Pranjal Paliwal
Software Engineer, Headout