Database systems allow you to interact with data on a very fast scale.
Many database systems use the SQL language. One of such systems is SQLite.
You may like:
Learning SQL: Master SQL Fundamentals
Create a database with SQLite.
You can create a new database with the command:
This will create the file database.db. Yes, this file contains the entire database: all data.
Database name must be unique.
You enter a special command prompt after typing the command above.
This is shown by the letters:
You can type SQL queries : interact with the database.
You’ll need this prompt many times in throughout this tutorial.
To see an overview, write:
More on the SQL queries later.
You can exit the SQLite3 shell by typing
This will exit the prompt.
Video demonstration on database creation below: