You don't need a complicated database server or an expensive development setup to start building applications that work with real data. Sometimes, all you need is a single file and the right knowledge to use it.
That's where SQLite comes in.
SQLite is used in mobile apps, desktop software, browsers, websites, and countless other applications. It is lightweight, reliable, and remarkably capable. Yet knowing that SQLite exists is very different from knowing how to use it effectively in your own projects.
SQLite from Scratch bridges that gap with a practical, step-by-step approach that takes you from your first database to a complete working application.
Rather than leaving you with a collection of SQL commands to memorize, this book shows you how the different pieces fit together. You'll learn how to create databases, design well-structured tables, write useful queries, connect SQLite to Python, and build applications that store and manage information reliably.
As you progress, you'll also discover how to improve query performance, protect important data, handle transactions, manage database changes, and avoid common mistakes that can cause problems in real projects.
What You'll Learn
Inside this hands-on manual, you'll discover how to:
- Get Started with SQLite: Set up your workspace, create your first database, and understand how SQLite works without managing a separate database server.
- Write Practical SQL Queries: Create tables, insert and update records, filter results, sort information, and summarize data.
- Design Better Database Schemas: Work with primary keys, foreign keys, constraints, relationships, and data types to build organized databases.
- Work with Related Data: Use JOINs, subqueries, common table expressions, and views to retrieve information from multiple tables.
- Connect SQLite with Python: Use Python's sqlite3 module, write parameterized queries, and build a functional command-line application.
- Use SQLite in Mobile and Desktop Applications: Understand local storage, offline-first design, application settings, backups, imports, and exports.
- Improve Database Performance: Learn how indexes work, read query plans, identify slow queries, and make informed performance improvements.
- Protect and Maintain Your Data: Understand transactions, ACID properties, journaling modes, Write-Ahead Logging (WAL), database migrations, and maintenance.
- Build a Complete Project: Bring your knowledge together in a capstone project that takes you through planning, implementation, testing, and shipping a database-powered application.
Who Is This Book For?
This book is designed for:
- Complete Beginners who want a clear, practical introduction to SQLite and relational databases.
- Students and Computer Science Learners who want to strengthen their understanding of SQL, database d