About this introduction:
-
What is SQLite?
-
SQLite as Lightweight Database
-
SQLiteStudio
-
How to install in any OS
-
General view of the software
-
What is SQLite?
You are probably wondering why it is called SQLite.
Well, SQLite is a version of SQL but is for databases that don’t require client-server setup, which means that cannot be used in multiuser enviorment (multiple users cannot edit the same SQLite file simultaneously).
Also, SQLite is widely distributed in the world and is used for any type of modern device such as iPhones, Android devices, consoles, satellites and many other devices.
SQLite as Lightweight Database
Database solutions can be divided into two categories: lightweight and centralized. The SQLite is considered a lightweight database solution, which is a solution for one user or a small number of users. But, as lightweight database it can face one problem if multiple users start to edit the database file simultaneously and a solution for this problem is to use centralized database solutions such as (MySQL, Oracle, PostgreSQL, IBM DB2 and many others).
SQLiteStudio
To teach SQLite, it was choosen SQLiteStudio (which is one of many SQL editors) because is intuitive and it is easy to manage and explore databases.
It is important to mention that SQLiteStudio is a third-party program built by Richard Hipp and his team of programmers. Also, to mention that SQLiteStudio is not associated with SQLite or its developers.
-
How to install in any Operative System (OS)?
The installation is the same for all the OS.
- Go to the following website: https://sqlitestudio.pl/
- Click on Download section above.
- After it, you should see something like the Image 1.
Image 1 – Download section from SQLiteStudio website You can see that are both portable and installer version for each OS. You can choose one, but i recommend to choose the portable version which don’t require installation. Also, is important to mention that after the download you should check the SHA-256 checksum of the file you downloaded for security purposes. If you don’t know how to checksum, there is a guide available on this website: How to verify checksum on Windows, Mac and Linux
- For last, to start the program just double-click on the executable (You can create a shortcut if you want to launch easily the application in the future)
-
General view of the software
Once you open your program you have a tab menu with the following elements: Database, Structure, View, Tools, Help as shown in the image bellow.
Under Database section, you will be able to see different options related to Database (Image 3).
These different options include the possibility to add, edit or remove a database or connect and disconnect the database. For purposes of simplicity, it only be used the options mentioned.
Under the Structure section, you will see the following options (Image 4)
Only the trigger options will not be used… The rest will be shown how and why is used.
For last, i would like to mention the Tools section, where it will be used the SQL editor to make queries (it will be explained later in one of the classes) (Image 5). Also, if you have any question about the software or about the SQLite you can consult the User Manual or the SQLite documentation under Help section (Image 6).
VEXILLA - IT World 