layout | title | permalink |
---|---|---|
page |
Setup |
/setup/ |
{: .prereq} Download this data to your computer: http://dx.doi.org/10.6084/m9.figshare.1314459. Click on Download all to download the zip file. Unzip it to a location that you can easily find on your computer.
The data for this lesson is a part of the Data Carpentry Ecology workshop. It is a teaching version of the Portal Database data.
The data for this lesson and the workshop are in the Portal Project Teaching Database available on FigShare, with a CC-BY license available for reuse.
{: .prereq} SQL is a specialized programming language used with databases. We use a simple database manager called SQLite in our lessons.
We will use SQLite Manager plugin for the Firefox web browser. If you don't have Firefox installed, you need to install it first and then you will be able to add the plugin.
- If you don't already have Firefox, download Firefox from the Firefox download page
- Install Firefox following the installer instructions
- Install the SQLite Manager add on:
Within Firefox, go to https://addons.mozilla.org/en-us/firefox/addon/sqlite-manager/. - Click on the green 'Add to Firefox'
- When a window pops up, click on 'Install'
- When the next box pops up, click on 'Restart Now' to restart Firefox
- Add SQLite Manager to the menu:
Menu (the three horizontal lines near the top right corner of Firefox) -> Customize, then drag the SQLite Manager icon to one of the empty menu squares on the right, Exit Customize - Open SQLite Manager:
Menu -> SQLite Manager
- If you don't already have Firefox, download Firefox from the Firefox download page
- Install Firefox following the installer instructions
- Install the SQLite Manager add on:
Within Firefox, go to https://addons.mozilla.org/en-us/firefox/addon/sqlite-manager/. - Click on the green 'Add to Firefox'
- When a window pops up, click on 'Install'
- When the next box pops up, click on 'Restart Now' to restart Firefox.
- After restart the SQLite Manager will be added ot the Tools menu
- Open SQLite Manager:
Tools -> SQLite Manager