Go to TogaWare.com Home Page. GNU/Linux Desktop Survival Guide
by Graham Williams
Duck Duck Go

SQLite

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

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"


Copyright © 1995-2019 Togaware Pty Ltd
Support further development through the purchase of the PDF version of the book.
Brought to you by Togaware and the author of open source software including Rattle and wajig.
Also the author of Data Mining with Rattle and Essentials of Data Science.