Loading...

CodeCrafters

Catalog Pricing Roadmap

Build your own SQLite

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

C++

Clojure

Elixir

Gleam

Java

JavaScript

Kotlin

Python

Ruby

Rust

TypeScript

Zig

Build your own SQLite

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.

Try Build your own Shell → View Membership Plans →

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

Print number of tables

Print table names

Count rows in a table

Read data from a single column

Read data from multiple columns

Filter data with a WHERE clause

Retrieve data using a full-table scan

Retrieve data using an index

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