search

datacarpentry / sql-ecology-lesson

Data Management with SQL for Ecologists
http://datacarpentry.github.io/sql-ecology-lesson
Other
49 stars 144 forks source link

Lesson Contribution: Windows Issues #336

Open Talishask opened 3 years ago

Talishask commented 3 years ago

I'm a member of The Carpentries Core Team and I'm submitting this issue on behalf of another member of the community. In most cases, I won't be able to follow up or provide more details other than what I'm providing below.

I noticed in preparing to do my teaching demo last night that the default installation of the windows version of DB Browser for SQLite doesn't have a query tab and doesn't respond to -, as required in the lesson/episode: https://datacarpentry.org/sql-ecology-lesson/01-sql-basic-queries/index.html (See attached picture.) carpentries

I ended up using my Linux machine and the Linux version

ChristinaLK commented 3 years ago

thanks for the feedback!

beepboopbirdy commented 2 years ago

I am also on a Windows machine and used this lesson for my teaching demo last November.

I opted to use the portable version of DB Browser for SQLite. I still had the .zip file in my downloads, so I unzipped a fresh copy and the 'Execute SQL' tab was there. Today, I tried the installers for both 32-bit and 64-bit Windows, and the tab was there from the start as well.

For instances like this, I think it would be useful to include instructions on how to display the 'Execute SQL' tab (View menu option -> click 'Execute SQL') especially since the default setting may not be consistent across computers running the same operating system. This could probably go under 'Relational Databases' in the 'Introducing Databases and SQL' episode, where the different tabs are described.