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"


Support further development by purchasing the PDF version of the book.
Other online resources include the Data Science Desktop Survival Guide.
Books available on Amazon include Data Mining with Rattle and Essentials of Data Science.
Popular open source software includes rattle and wajig.
Hosted by Togaware, a pioneer of free and open source software since 1984.
Copyright © 1995-2020 Togaware Pty Ltd. . Creative Commons ShareAlike V4.