Added: 19th of November 2020
Viewed: 346 times
SQLite is a self contained database, and unlike MySQL / MariaDB does not require the same amount of configuration or a server to run. Once installed your ready to go.
SQLite also works with many different programming too, and if you understand how to query a MySQL / MariaDB database it's quite easy to pick up SQLite.
SQLite works best with standalone applications. Firefox, Thunderbird, Bleachbit are just a few applications that use SQlite.
This tutorial will just go over the basics of installing and using SQLite3 on Ubuntu and Ubuntu based distributions. Once installed we will then create a new database, table and insert some basic data. We will then query the database using some simple SQlite statements.
Other Tips & Tutorials
SQliteInstall SQlite3 in Ubuntu and Ubuntu based distributions, create table, insert data
Posted: 19th of November 2020