Set Up Instructions for SQL¶
Install Software¶
To follow along, you will need the UNIX shell, plus SQLite3 or DB Browser for SQLite.
Mac Users¶
If you are running macOS you should already have SQLite
installed. You can run sqlite3 --version
in a terminal to confirm
that it is available. You can also download
DB Browser for SQLite from their website.
Linux Users¶
If you are running Linux, you may already have SQLite3 installed,
please use the command which sqlite3
to see the path of the program, otherwise
you should be able to get it from your package manager (on Debian/Ubuntu, you can
use the command apt install sqlite3
).
Windows Users¶
If you are running Windows, run installers as administrator. Additionally, make sure you select the right installer version for your system.
Download git for Windows. Installation instructions are here.
Download SQLite3 and DB Browser for SQLite. If installing SQLite3 using Anaconda, refer to the anaconda sqlite docs.