Set Up Instructions for SQL
===========================

Install Software
----------------

To follow along, you will need the UNIX shell, 
plus `SQLite3 <http://www.sqlite.org/>`__ or 
`DB Browser for SQLite <https://sqlitebrowser.org/>`__.

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 <https://sqlitebrowser.org/dl/>`__ 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 <https://gitforwindows.org/>`__. 
   Installation instructions are `here <https://carpentries.github.io/workshop-template/#shell>`__.  
-  Download `SQLite3 <http://www.sqlite.org/>`__ 
   and `DB Browser for SQLite <https://sqlitebrowser.org/>`__.  
   If installing SQLite3 using Anaconda, refer to the `anaconda sqlite docs <https://anaconda.org/anaconda/sqlite>`__.