Hey - I would love to include this material in either the Open Data Manual or datapatterns.org. Are you able to release this content under an open license?

Issue came up with someone following the tutorial who then went on to work with a data set that used spaces in field names. The tutorial should make clear that SQLite (and most managers) can't handle spaces in column or table names without special quoting.

In part 3 of the SQLite tutorial, the first command in the self-joins section is broken. Instead, it should be:

SELECT a.last_name, a.first_name, a.amount, b.amount FROM contributors a, contributors b WHERE a.last_name = b.last_name AND a.first_name = b.first_name;

Currently, it is:

SELECT a.last_name, a.first_name, a.amount, b.amount FROM a, b WHERE a.last_name = b.last_name AND a.first_name = b.first_name;

which leaves a and b undefined and results in an error.

PS
I love the tutorial! I've found it very helpful.

On this page:
https://github.com/tthibo/SQL-Tutorial/blob/master/tutorial_files/part2.textile

This image is NOT FOUND:
https://github.com/tthibo/SQL-Tutorial/raw/master/tutorial_files/images/subquery_max_.png

SQLite Manager Problems 😬

Description 📝

Upon starting the tutorial I noticed that the link to download the SQLite Manager add-on for Firefox was broken.

• Here is an updated link: Firefox add-on.
• Alternatively, here is a link for the Chrome browser extension: Chrome add-on
  Then I encountered another issue; SQLite Manager cannot import from files delimited by pipes ("|").

Source

Note: I never saw an Import Wizard icon either, as shown in the tutorial. And only after reading the above source did I experiment with dragging and dropping a csv file into the browser.

Solution ✅

I ended up downloading SQLite Browser and using it for the tutorial. It is easier to use imo and has more people actively contributing to it 👍

I liked this tutorial a lot. Perhaps it could be made more user friendly by either

1. Updating the datasets to be CSV formatted,
2. Or adapting the steps to use SQLite Browser.

Very useful and well explained, thank you very much. I forked to practice with it. If I ever want to use it or part of it for classes can I credit you and use it?

The file with the candidate_id in the contributions has negative values for amount. Seems weird....