Hi folks, I had a quick look at sqlitebrowser (https://github.com/sqlitebrowser/sqlitebrowser). It provides a Windows binary but, for Linux, unless you have Ubuntu or Fedora or Arch Linux, you may need to build it, which in turn needs CMake and Qt installed but according to the authors its "simple" (of course it is, shudder)
An alternative is sqlitestudio (https://sqlitestudio.pl/) which worked as-is on Windows and Ubuntu but rendered a corrupt GUI due to problems with other packages on SL7. I'd agree with Alexey and Mario and vote for using the command-line tool. As attendees have to type in SQL commands regardless of whether they are using the command-line or a GUI, the only value-added of a GUI is better-rendered tables. The fewer additional tools students have to download the better, especially those who are on slow internet connections, have older or more brittle computers, or wait until the morning on the course when internet access may be even more problematic. cheers, mike ________________________________________ From: Discuss <[email protected]> on behalf of Alexey Shiklomanov <[email protected]> Sent: 15 November 2017 14:22 To: ANTONIOLETTI Mario Cc: [email protected] Subject: Re: [Discuss] FW: Welcome to the new Firefox I agree that command line SQL is the way to go, and I have seen it taught that way successfully. Similarly, I think we could emphasize the SQL APIs provided by the languages we teach. For instance, R's `dbplyr` package (part of the tidyverse) integrates wonderfully into the general tidyverse ecosystem, and requires very little additional cognitive overhead to grasp once the basic dplyr, etc. commands have been taught. I'm sure there are similar mature interfaces for Python. On Wed, Nov 15, 2017 at 4:14 AM, Mario Antonioletti <[email protected]<mailto:[email protected]>> wrote: Hi, I have previously taught the SQL lesson successfully, I thought, by just using the command line. I feel there is an incongruity here - why should SQL get special treatment when we are so purist about git? there are lots of good git clients out there but we insist that people do it on the command line yet for SQL it is different? The reason why I went with the command line was the fact that lots of people use ie (now edge) or chrome - why should we expect people to install firefox if they want to learn SQL? Using the command line is also more consistent with the other lessons: bash, git, ... Mario On Tue, 14 Nov 2017, François Michonneau wrote: Hi Amy, That's a good point. It's going to be interesting to monitor what's going to happen in the next few weeks. It looks like many addons (including some very popular commercial ones) are incompatible with this new version of firefox. I assume that the developers of these addons are going to catch up and make them compatible. However, it's not clear if it's also going to be the case for SQLite manager and this thread doesn't seem too promising: https://github.com/lazierthanthou/sqlite-manager/issues/75 It might be a good idea to explore alternatives. I saw that plotly recently released a cross-platform database interface named Falcon: https://plot.ly/database-connectors/ (Linux version available from: https://github.com/plotly/falcon-sql-client/releases/latest). sqlitebrowser (https://github.com/sqlitebrowser/sqlitebrowser) is actively maintained and also cross-platform. cheers, -- François On Tue, Nov 14, 2017 at 11:46 AM, Amy E. Hodge <[email protected]<mailto:[email protected]>> wrote: I just downloaded the new Firefox Quantum and discovered that SQLite Manager no longer works – it’s automatically disabled and only gives me the option to Remove it. Hopefully the older version we still be available for a while, but we may need to make a note in the lesson materials about the version people need to use for the SQL lessons. Right now I’m seeing that they haven’t made it easy to access downloads for older versions. I’m not finding it. ~ Amy Amy E. Hodge, PhD Science Data Librarian [email protected]<mailto:[email protected]> 650.556.5194<tel:650.556.5194> [IMAGE] orcid.org/0000-0002-5902-3077<http://orcid.org/0000-0002-5902-3077> Data Management Services Branner Earth Sciences Library, 212 Mitchell 397 Panama Mall; MC 2211 Stanford University Stanford, CA 94305 From: Firefox <[email protected]<mailto:[email protected]>> Reply-To: Mozilla <reply-fe9510747060047a77-100_html-241685816-1065730-...@e.mozilla.org<mailto:reply-fe9510747060047a77-100_html-241685816-1065730-...@e.mozilla.org>> Date: Tuesday, November 14, 2017 at 8:36 AM To: "Amy E. Hodge" <[email protected]<mailto:[email protected]>> Subject: Welcome to the new Firefox Get Firefox Quantum. New. Fast. Fierce. irefox The new Firefox. Fast for good. Today we’re thrilled to introduce you to our brand new browser — Firefox Quantum. What you’ll notice first is that the new Firefox is blazing fast. In fact, you’ll enjoy speeds up to twice as fast as a year ago. It’s also more powerful. We’ve rebuilt Firefox from the ground up to focus on how you use the Web today to watch, listen, create and play without limits. We’re excited to deliver a browser that feels completely different — modern, quick and efficient. We think you’ll agree: It’s a quantum leap forward in how you’ll experience the internet. When you use Firefox, you’re also contributing to a movement to ensure the internet remains a global public resource, open and accessible to all. As an independent, not-for-profit organization, we’ve been committed since 2003 to building products that put you in control of your online life and advancing open technology and public policy that promote a healthier internet. We put you at the center of everything we do. On behalf of Mozilla's global community, we're proud to introduce you to the new Firefox. Fast for good. Chris Beard CEO, Mozilla P.S. If you have any questions, we're always here to help. Thanks for reading! You're receiving this email because we think you’re neat, AND you subscribed to hear from us. If our emails aren’t sparking joy, we’ll understand if you unsubscribe. You can also update your email preferences at any time. ozilla Donate to Mozilla | Download Firefox 331 E. Evelyn Avenue Mountain View CA 94041 Legal • Privacy [open.aspx?ffcb10-fe9510747060047a77-fde91574716d0d7d711d7873-fe9915707361037e75-ff6e157075-fe2616 7474620c787d1576-ff5f1c7875&d=40053] _______________________________________________ Discuss mailing list [email protected]<mailto:[email protected]> http://lists.software-carpentry.org/listinfo/discuss +-----------------------------------------------------------------------+ |Mario Antonioletti:EPCC,JCMB,The King's Buildings,Edinburgh EH9 3FD. | |Tel:0131 651 3534|[email protected]<mailto:[email protected]>|http://www2.epcc.ed.ac.uk/~mario | +-----------------------------------------------------------------------+ -- The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336. _______________________________________________ Discuss mailing list [email protected]<mailto:[email protected]> http://lists.software-carpentry.org/listinfo/discuss -- Alexey Shiklomanov Department of Earth & Environment Boston University _______________________________________________ Discuss mailing list [email protected] http://lists.software-carpentry.org/listinfo/discuss
