search

data-lessons / library-sql-DEPRECATED

SQLite lesson for librarians NOW MOVED > https://github.com/LibraryCarpentry/lc-sql
https://github.com/LibraryCarpentry/lc-sql
Other
2 stars 16 forks source link

Installation of SQL needs to be better explained #23

Open weaverbel opened 7 years ago

weaverbel commented 7 years ago

I am working through the lesson prior to teaching it and have stumbled across a few gotchas. Setting up SQLite needs to be a documented step-through process as the language used on the SQLite download page is pretty hostile for Windows people. Install binaries? Huh? Install where? And then what? What I got when I installed was a command line SQLite3 but then the lesson suddenly talks about SQLite Manager which is a Firefox Add on - we need to walk people through getting that working as that was slightly complicated as well. It is really important in these lessons that we do not alienate people by assuming knowledge or leaving steps out so people feel stranded.

ostephens commented 7 years ago

Checking, in the Software Carpentry SQL lesson they say to use "Unix shell plus SQLite3 or Firefox SQLite plugin"

In Data Carpentry Ecology they opt for simply using the FF plugin

The DC approach definitely seems the more straightforward/simpler as it has only one option. I'm not familiar with the FF Plugin and any limitations it has - if it offers full access to SQLite functionality then it would make sense to me to base the LC lesson on this

drjwbaker commented 7 years ago

@thegsi taking this.

thegsi commented 7 years ago

Before tackling see debate on #34