0:00
Hello then welcome to LinuxS2 and in this video guide I'm going to show you how to install
0:08
SQLite in Ubuntu or Debian distribution or any of your derivatives for that fact
0:14
So SQLite is a really lightweight database and it does not follow the old school client server model
0:20
It's just a self-contained file which has the database schema and all the things that our application
0:26
can require to access the database and to that particular file is simply amped to any particular application and then application can interact with that file
0:36
just like it would do with a client server like database so let's see how to install it the very
0:42
first thing you want to do is to update your system just do an APD update command
0:54
simply to make sure everything is up to dated Now just execute the installation command for Esky Lite 3
1:16
So the SQLite version 3 has been installed in the system. Now let me create a database and after that I'll show you how to install the SQLite
1:24
browser so that you can graphically manipulate the database. Now doing these all things all things through the command line can be tedious
2:01
So let me show you how to install SQLite browser so that you can do these things very easily through our graphical utility
2:20
So here is the tool and we can easily browse the database as we created
2:38
as we created. So here is the database that we just imported and this is the table
2:50
Distow that we created and these are the fields and now let's see what is the data inside
2:57
these tables and as you can see there are two entries. We can easily add new entries over here by just clicking on the new record and we
3:05
can type the values over here. For example, I can say art, apply and I can also type here, 201
3:18
As you can see, values has been inserted. So you can use this graphical tool to do all kind of stuff
3:26
It's like the PHP My Admin or any database workstation tool. So that is the guide about how to install SQLite in your system and how to install the
3:34
the SQLite browser so that you can graphically manipulate the SQLite database
3:40
I hope you find this video helpful if you did then hit the like, subscribe to the channel. Let me know what you think about it in the comment section below
3:45
Nice. I'll catch in the next one. Until then, take care and keep enjoying Linux
