The Remote pane currently (v3.12.0) just shows two things:

• A list of all users with public databases (on DBHub.io), ordered from the newest change to the oldest
• The list of all databases the user has uploaded to DBHub.io

With the the list of users with public databases now getting pretty long, it's hard to use the Remote pane effectively. 😦

Instead, we should probably update the Remote tab to show:

• A curated list <-- probably a good default. eg something like:

  • Learning SQL
    • CS50x - the database (movies.zip) used in this
    • Ditto for (eg): https://www.codecademy.com/learn/paths/analyze-data-with-sql
    • Ditto: https://www.sqlitetutorial.net/sqlite-sample-database/
    • Ditto: https://datarockie.teachable.com/p/intro-sql-for-data-analysis <-- non-english though
    • Ditto: https://www.datacamp.com/community/tutorials/sqlite-in-python
    • and others.
  • Interesting data sets (TBD)

• People's own databases.

• All public user uploaded databases - like the current approach, but with a filter like the top of the DB4S Browse Data tab, so people can more easily find users/databases they're after.

  • Ideally we'd have some kind of "search" interface, but that's likely a pita SysAdmin wise for the backend (eg needing an Elasticsearch cluster), so I'd skip it at least for now.

My initial thinking is some kind of toggle thing, or drop down selector to switch between what's shown.

For the curated list, it'd probably require us to say Hi to each of the course authors about getting their database onto DBHub.io, and so they can include the info about it in their download instructions (if desired). It might also mean they get a useful boost in people learning about their course too, if we have each course entry in DB4S have some kind of a clickable link that opens a web browser window to the course overview page.

Thoughts?