Build your own SQLite

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

Start Building

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

Very easy

Print number of tables

Hard

Print table names

Hard

Count rows in a table

Medium

Read data from a single column

Hard

Read data from multiple columns

Hard

Filter data with a WHERE clause

Hard

Retrieve data using a full-table scan

Hard

Retrieve data using an index

Hard

“ 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

RECENT ATTEMPTS 0