sqlite

SQLite3

SQLite is a C library that provides a lightweight disk-based database that doesn’t require a separate server process and allows accessing the database using a nonstandard variant of the SQL query language. Some applications can use SQLite for internal data storage. It’s also possible to prototype an application using SQLite and then port the code to a larger database such as PostgreSQL or Oracle.

Link:

• DBeaver

Tutorial

1. Create a python virtual environment and activate

   python -m venv venv_sqlite

2. You don't need to install anything to use sqlite3 on python.

3. Follow the main.py

   • DB Initlization
   • Query the db as a dataframe

4. View the database file using DBeaver