On this page, you’ll find instructions for installing SQLite tools for Windows and Mac.
🔹 Intro
SQLite is a lightweight, file-based database engine. It’s so lightweight that you don’t really need to "install" it like traditional software.
In fact, if you're using Python, you only need to install a library like sqlalchemy
to start interacting with SQLite databases in no time.
However, we're going to install a very helpful tool for managing SQLite databases - DB Browser.
🔸 What is the DB Browser?
DB Browser for SQLite is a graphical interface for SQLite databases.
You can use it to navigate through your database structure visually, view its actual data, run queries, and even design and create new databases.
It's a very useful tool, that we will use alongside our Python scripts wherever we are working with a SQLite db.
🔹 Installation
- Navigate to the DB Browser for SQLite download page by clicking here.
- Download the latest version for Windows \ macOS.
- Install like any other program.
✳ Didn’t manage to install? Try this Video.
🔸 Using the DB Browser for the first time
📂 Existing Database Steps
➕ New Database Steps
✳ Didn’t manage to follow the steps? Go back to our demo.