You now have a fifth column, age.SQLite is a very popular relational database that is designed to be embedded within software applications.
In the following two sections you will first add a new column into your existing table and then update existing values in the table. So far you have created a table, inserted data into it, and queried that saved data.
You will receive an output like this: SQLite version 3.31.1 19:55:54įollowing this, your prompt will change. If the file sharks.db already exists, SQLite will open a connection to it if it does not exist, SQLite will create it. This will create a new database named sharks. To create the database, open your terminal and run this sqlite3 command: sqlite3 sharks.db In this step you will create a database containing different sharks and their attributes. With SQLite installed, you are now ready to create a new database. To verify the installation, check the software’s version: To install the SQLite command-line interface on Ubuntu, first update your package list:
Step 1 - Installing SQLite on Ubuntu 20.04 To set up a server, including a non-root sudo user and a firewall, you can create a DigitalOcean Droplet running Ubuntu 20.04 and then follow our Initial Server Setup Guide.
For instructions on using SQLite inside your Python code, check out our tutorial, How To Use the sqlite3 Module in Python 3. For an excellent overview of popular relational databases and how they compare, check out our article, SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems.Īdditionally, many languages maintain integrations with SQLite. It does not cover larger conceptual issues and production concerns, such as when one should, or should not, consider using a SQLite database. Note: This tutorial includes practical instructions for installing and using SQLite. You will then create a database, read data from it, insert items, delete items, and join items from separate tables. In this tutorial you will install SQLite on Ubuntu 20.04.
It is popular for its efficiency and ability to interface with many different programming languages.
SQLite is a free, cross-platform database management system.
The author selected the Free and Open Source Fund to receive a donation as part of the Write for DOnations program. How To Install and Use SQLite on Ubuntu 20.04