SQLite is known for its zero configuration which means no complex setup or administration is required. Let's see how to install SQLite on your system.
Install SQLite on Windows
Follow the steps given below:
The above method facilitates you a permanent way to create database, attach database and detach database.
There is another way to execute CRUD operation in SQLite. In this method, there is no need to set a path.
You can execute the SQLite query here. But here, the data is temporary and once you shut down your computer, you will lose the records you have. Because, you cannot create, attach or detach a database here.