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

00-sql-introduction Instructions to select tables in "Browse Data" tab #332

Closed kekoziar closed 2 years ago

kekoziar commented 3 years ago

In 00-sql-introduction under the "Relational databases" section, it states

To see the contents of any table, click on it, and then click the “Browse Data” tab next to the “Database Structure” tab.

Except, that's not the functionality on my version of SQLite. The table which opens when clicking in the "Browse Data" tab has no bearing on if you've selected a table in the "Database Structure" tab. When first opened, the "Browse Data" tab will default to "Plots" (top table in list). To select different tables, one needs to either right-click on the table in the "Database Structure" tab and select "Browse Table" from the menu, or click on the "Browse Data" tab and use the "Table:" drop-down menu on the top-left of that tab. When clicking on "Browse Data" tab, it will be on the last selected table (or default to the top table).

novica commented 2 years ago

I can confirm the behavior as described by @kekoziar I tested on Linux 5.17.5 and Windows 10 with DB Browser for SQLite Version 3.12.2 on both.

jd-foster commented 2 years ago

Thanks @kekoziar for raising the issue and @novica for the PR to fix it.