You can create it either by SQL or viva the “Add Field” option in the GUI.įor the purposes of this training let’s name the table as “Students”. Now you will be prompted to define your database table. It will also ask you to select a unique name for the database file.įor the purposes of this tutorial let’s name it “test”. Click on the “New Database” button in the upper left, right below “File”.Ī dialog will open asking you about your desired location for the database file. With the GUI, it is a pretty intuitive process for creating a database and the tables within. If it is not showing up in the front, just type “DB Browser” in the search box above and it will show up.Ĭlicking on the icon will open up the DB Browser, which looks like this: Now when you open up the applications drawer, you will see the DB Browser listed there You are now ready to use SQLite on your Ubuntu 20.04 machine. With this output, the installations are complete. Once you get the prompt back, the installation is complete. Go ahead and type this into the terminal to start the installation: $sudo apt install sqlitebrowserĭuring the installation, the terminal will ask you that after installation additional 58.5 MB of disk space will be utilized, do you want to continue? If you don’t have enough disk space, feel free to abort the installation at this step otherwise proceed.ĭepending on your Internet connection speed, this process will take some time. For this guide, we will install the de facto tool i.e., SQLite Browser. Now that the database engine is installed on your machine, you need a management tool to operate on it. Once you get this output, this means that the installation has been successfully completed. Now go ahead and install the SQLite3 package through the following: $sudo apt install sqlite3 $sudo apt updateĪs soon as the update is completed, you will know when the prompt returns. Fire up the terminal and update your Ubuntu 20.04. Update the OSīefore we proceed with the installation, it is always a recommended step to run the update to resolve any dependency issues and get the latest versions of all of the packages. In this tutorial, I will show you how to install and use SQLite on Ubuntu 20.04, the same procedure will work on the upcoming Ubuntu 22.04 version too. SQLite is released under an OpenSource license, so it’s free to use. It is widely known for its efficiency and its ability to be connected with various programming languages. SQLite is a lightweight cross-platform relational database engine.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |