How to Install SQLite On Windows 11


go to transcript


transcript,
hey guys in this video i’m going to show you how you can download and install sqlite on your windows 11 operating system so sqlite is a database engine which is written in c language and sqlite is a self-contained serverless database that means you can create and use this sqlite database on your local computer and you can create your database and transfer your database from one computer to another without worrying about some server configuration so let’s see how we can install sqlite on our windows 11 operating system so first of all open your favorite browser and search for sqlite and the first link which will appear here will be from sqlite.org so we are going to click on this link in here you will be able to see this downloads tab here on the top you can also see the downloads button under the latest releases so you can click any of these links i’m going to click on downloads tab here and once you click on the downloads tab you will see different versions of downloads right so you can download the source code you can download the documentation pre-release snapshot we are interested in the pre-compiled binaries for windows so just scroll down where it says pre-compiled binary for windows and we will download the sqlite tool for our windows 11 operating system right so just select the third option here which says sqlite tool win32 and you can see what it says a bundle of command line tools for managing sqlite database files so i’m going to click on this link which is going to download this zip file so once this zip file is downloaded just go to the location where this zip file is downloaded and first of all we need to extract this zip file so right click on it and you can choose any tool or which you have for extracting this zip file i’m going to click on extract and then i’m going to click on extract once again which is going to extract this zip file in the downloads folder itself so once this zip file is downloaded you will be able to see only three files here so what i like to do here is i just cut this folder from here so let me cut this folder and then i go to the c folder and then i’m going to paste this folder here and then i’m going to rename this folder so let me rename this folder to sqlite 3 right so this way i can remember where i have my sqlite binaries and i can also set the environment variables for the sqlite which will help me to run my sqlite commands from my command prompt right so once you have copied this sqlite 3 into your c directory just go where all of your executable files related to sqlite are there and then copy this path from here we need to set the environment variables for sqlite in order to use so just copy this path from the top and then just click on the search icon here and then search for environment variables and when you type few letters of environment in the search result you will be able to see this result which says edit the system environment variables click on this option which is going to open this kind of window click on environment variables here and then click on path environment variables under system variable so just select this and then click on edit and here you just need to create a new environment variable and then paste your path so my path is c colon backslash sqlite3 in my case so make sure you copy the path where all your files relate to sqlite are there right so this is the path just paste the path here once you are done click on ok and then click on ok and once again click on ok so once you are done setting the environment variables for sqlite you can start using sqlite using command prompt so just search for cmd and then open the command prompt and in here you can just type sql ite sqlite 3 and then press enter and if you see this kind of output which will show the version of sqlite which you have downloaded in my case escalade version 3.372 and here you can see uh that sqlite shell has been started so from here you can create the database you can manage your database using the command prompt from this shell right now let me show you some basic sqlite command so how you can get help about sqlite when you type dot help here and then press enter you will be able to see all the commands which are available in your sqlite database and then you can use one of these command to uh manage and use sqlite right so one such command is dot quit you can use this command dot quit to quit from your escalate shell so now i’m out of my escalate shell right now how we can create a sqlite database so let me just close this command prompt let’s say i want to create this database on our directory which is on my desktop so let me create a new directory here so let so let’s say this directory name is db and i want to create my database here so let me just open this db database here and once again i’m going to open the command prompt by just typing cmd and let me just move this command from little bit on the right hand side so you can see the database which is created inside this folder so first of all copy the path where you want to create this database and then just type cd and then paste this path press enter so now you are inside this uh database directory where you want to create this database right so here you can just type sqlite 3 and the name of your database in my case let’s say i want to just create my db which is the name of my database and then the extension you can give db extension or sqlite extension whatever you like and then press enter once you do that your database is created so you are switched into this database but still you will not see any database file which is uh visible on in your database folder in order to view your database you can give this command dot databases and then press enter and it’s going to show me all the databases which i’m using so once you give this command it’s going to show you the list of all the databases right now we have only one database and now you can see this database file which is created here now how you can create a table inside your database so as you have created this mydb.db database and you are working inside this database when you give this command you can create the table using this command you can just write create and then the table and then write table here and then the name of your table let’s say my table name will be books and then inside these parentheses i can give my column names so let’s say i just want to give one column name which will be id and the data type will be int here and let’s say it will be the primary keys so i can just write primary key here and then once you are done you just need to give the semicolon here so this command is going to create a table with the name books and it will have only one column which will be called id right i’m going to press enter here so this table is created so once your table is created how you can view the table so you can give this command dot tables and then press enter and you will be able to see all the tables inside your database we only have one table which is called books so i can see only one table here now if i want to see the schema of the table i can just write dot schema here and then the name of the table which is books in my case and then press enter it’s going to show me the schema of that table so you can see this table contain only one column and this table name is books right so this is how you can install and use sqlite database on your windows 11 operating system i hope you’ve enjoyed this video and i will see you in the next video

watch on youtube

Check Also

How To Remove Viruses & Malware In 3 Steps | Windows PC | 2019

go to transcript if you are the content owner and want to remove your content? …

How to get macOS Dynamic Wallpapers on Windows 10/11

go to transcript if you are the content owner and want to remove your content? …

How To Fix Windows Update Error 0xca020007 In Windows

go to transcript Thank You Everyone So Much For Watch My Video On ” How …

Leave a Reply

Your email address will not be published. Required fields are marked *