Lesson Contribution: Windows Issues

[Talishask]

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.)

I ended up using my Linux machine and the Linux version

[ChristinaLK]

thanks for the feedback!

[beepboopbirdy]

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.