![]() ![]() So let’s create a database with a table, I am calling it, “distributions”. It has queries that are similar to the standard RDBMS databases. Create database and table in SQLiteĬreating a database in SQLite is quite easy. Now let’s see how to create a database and insert some data in it. So no server, users, or connection management. One thing you will definitely love about SQLite, unlike other client-server databases, it has not configuration setup. sudo apt-get install sqlite3Īfter the installation, you can verify the installed version with this command.Īs you can see the installed version in the system is v3.33.0 at the time of writing this article. ![]() The ongoing latest SQLite version is 3 so we are installing SQLite3. You can install SQLite3 the latest version by following the commands.įirst make sure your system is up-to-date. Installing SQLite is as easy as any other program, the database is already available in the official repository for both Ubuntu and Debian. Let’s see how you can get the SQLite in your Ubuntu or Debian distribution.Īlso see, How to install & configure LAMP stack on Linux Installing SQLite on Ubuntu/Debian This file can be embedded into any end program.īeing so small but still SQLite has ACID compliance and implements most of the SQL standards while following SQL syntax. Rather, it is just a small self-contained file having everything in it. It does not follow the traditional client-server model like any other RDBMS (PostgreSQL, MySQL, MariaDB, Microsoft SQL). SQLite as the name itself suggests, a lightweight relational database management system contained in a C library. ![]() In this quick guide, you will go through the complete process on how to install SQLite and its companion graphical manager SQLiteBrowser on Ubuntu, Debian, and any of their derivatives. ![]()
0 Comments
Leave a Reply. |