Want to learn and master SQLite?

Join Exercism’s SQLite Track for access to 26 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

26 coding exercises for SQLite on Exercism. From Pascal's Triangle to Meetup.


Get better at programming through fun, rewarding coding exercises that test your understanding of concepts with Exercism.

See all SQLite exercises on Exercism

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 26 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.