18.10 SQLite

SQLite3 provides a file based SQL database. Because it is file based there are no administrative overheads. SQLite database files usually have a .db file extension. SQlite is widely used on GNU/Linux and Android.

Identify the tables in a database file:

$ sqlite3 photos.db .tables

List the schema of the tables:

$ sqlite3 photos.db .schema

Display first few rows of a table:

$ sqlite3 photos.db "SELECT * FROM Tags LIMIT 10"

Your donation will support ongoing development and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2021 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0.