Join Exercism’s SQLite Track for access to 28 exercises with automatic analysis of your code and personal mentoring, all 100% free.
DROP TABLE IF EXISTS hello_world;
CREATE TABLE hello_world (greeting TEXT);
INSERT INTO hello_world (greeting)
VALUES ('Hello, World!');
.save hello_world.db
Get better at programming through fun, rewarding coding exercises that test your understanding of concepts with Exercism.
Convert color codes, as used on resistors, to a numeric value.
Convert a resistor band's color to its numeric representation.
Given a number determine whether or not it is valid per the Luhn formula.
The SQLite source code is in the public domain and doesn't require a license for use.
SQLite provides APIs for extending the the database system, including new functionality.
There is no server process to manage access so processes can write directly to a SQLite database.
Transactions are ACID-compliant so all changes are applied or not at all, increasing reliability.
SQLite doesn't require installation or configuration before use and can be used almost everywhere.
The official SQLite library is less than a single megabyte.
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 mentoringThe 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 exercisesThe best part, it’s 100% free for everyone.