Scribd
Upload
95 views1 page

Install SQLite and SQLiteStudio Guide

This document provides instructions for installing the necessary tools to work with SQLite databases, including downloading SQLite from its website, extracting and running the SQLite tools from the command line, and installing SQLiteStudio, a free GUI tool for managing SQLite databases. The instructions guide the user to create directories for databases and tools, download SQLite and SQLiteStudio, extract the downloaded files, and execute the tools.

Uploaded by

Pedro Pablo Campuzano
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
95 views1 page

Install SQLite and SQLiteStudio Guide

This document provides instructions for installing the necessary tools to work with SQLite databases, including downloading SQLite from its website, extracting and running the SQLite tools from the command line, and installing SQLiteStudio, a free GUI tool for managing SQLite databases. The instructions guide the user to create directories for databases and tools, download SQLite and SQLiteStudio, extract the downloaded files, and execute the tools.

Uploaded by

Pedro Pablo Campuzano
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Installing Working Environment

In this guide we will present students just getting started with SQL a guide to install and use SQLite
database.

Create a Working Directory for the Databases Course


In this folder we will install all the tools required for the course.

1. Create a new folder for Databases course, e.g. /databases

Download SQLite tools


1. Go to the https://www.sqlite.org website
2. Open the download page https://www.sqllite.org/download.html
3. Select the appropriate version to download for your platform (Windows, Linux, and Mac)

The downloaded file is in the ZIP format and its size is quite small.

Run SQLite tools


1. Create a new folder for SQLite, e.g. /sqlite
2. Extract the content of the downloaded zip file in the new folder
3. Execute ‘sqlite3’ from the command line
4. Execute ‘.help’ command in sqlite3
5. Execute ‘.quit’ to quit the sqlite shell

Install SQLiteStudio
The SQLiteStudio tool is a free GUI tool for managing SQLite databases. It is free, portable and cross-
platform. SQLite tool also provides important features to work with SQLite databases such as
importing, exporting data in various formats including CSV, XML, and JSON.

1. Download the SQLiteStudio from https://github.com/pawelsalawa/sqlitestudio/releases


2. Create a new folder for SQLiteStudio, e.g. /SQLiteStudio
3. Extract the content of the downloaded zip file in the new folder
4. Execute ‘SQLiteStudio’

Now, you should be ready to start your journey with SQL databases.

You might also like