we face some problems while working and some among them are Handling SQLite databases and managing the database.
In managing database the common problems are switching between tabs and because of complexity databases it become difficult to manage the database.
The advantages of the SQLite in VS code is in the following link https://www.sqlite.org/index.html
For many developers, SQLite has become the preferred client-side technology for data storage. It is a server-less, embedded, open-source database engine that satisfies most local data access scenarios.
Your application size reduces since you don’t download your own SQLite binary and package it as part of your application
Extension for SQLite Database
The main extension that we use for handling the SQLlite database is sqllite viewer by installing this extension we can have the access to view the database in the visual studio code editor only and we can manage the database in the same database.
STEPS TO INSTALL EXTENSION
- Check for sqliteViewer in the extensions section of VS code.
- Install the sqliteViewer Extension
- Now create the project .
After Installing extension your can create the project and the following link can help you in creating project
After creation of the database follow the steps to view the database and then you can manage the database.
- Right click on db.sqlite3
- Select open to slide or click Ctrl + Enter
- Database will get open in the new slide.
- You can manage the database.