Want to learn and master SQLite?

Join Exercism’s SQLite Track for access to 28 exercises with automatic analysis of your code and personal mentoring, all 100% free.

Explore exercises

About SQLite

DROP TABLE IF EXISTS hello_world;
CREATE TABLE hello_world (greeting TEXT);
INSERT INTO hello_world (greeting)
VALUES ('Hello, World!');
.save hello_world.db

Key Features of SQLite


SQLite

Public domain

The SQLite source code is in the public domain and doesn't require a license for use.

Extensible

SQLite provides APIs for extending the the database system, including new functionality.

Serverless

There is no server process to manage access so processes can write directly to a SQLite database.

Reliable

Transactions are ACID-compliant so all changes are applied or not at all, increasing reliability.

Portable

SQLite doesn't require installation or configuration before use and can be used almost everywhere.

Compact

The official SQLite library is less than a single megabyte.

Get mentored the SQLite way

Every language has its own way of doing things. SQLite is no different. Our mentors will help you learn to think like a SQLite developer and how to write idiomatic code in SQLite. Once you've solved an exercise, submit it to our volunteer team, and they'll give you hints, ideas, and feedback on how to make it feel more like what you'd normally see in SQLite - they'll help you discover the things you don't know that you don't know.

Learn more about mentoring

Community-sourced SQLite exercises

The SQLite track on Exercism has 28 exercises to help you write better code. Discover new exercises as you progress and get engrossed in learning new concepts and improving the way you currently write.

See all SQLite exercises
SQLite

Get started with the SQLite track

The best part, it’s 100% free for everyone.