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 availability 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