Chapter 1. Getting Started

Welcome to SQLite. This chapter will give you an overview of what SQLite is and isn't, what it can and can't do, and how it compares to other databases that you might consider using or might already be familiar with.

We will look at a few basic SQL commands and see how to use the sqlite command-line tool and the SQLite Database Browser GUI to create, examine, and modify databases.

Introduction

SQLite is an embeddable SQL-driven database engine that implements both the database engine and its interface as a C/C++ library. Started in 2000 by D. Richard Hipp, it was written from the ground up and contains absolutely no legacy code, and the SQLite source code has been in the public domain since the first prerelease of version ...

Get SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.