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 < m.antoniole...@epcc.ed.ac.uk> 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/databa >> se-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 <amyho...@stanford.edu> >> 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 >> >> amyho...@stanford.edu >> >> 650.556.5194 >> >> [IMAGE] 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 <mozi...@e.mozilla.org> >> Reply-To: Mozilla <reply-fe9510747060047a77-100_ >> html-241685816-1065730-...@e.mozilla.org> >> Date: Tuesday, November 14, 2017 at 8:36 AM >> To: "Amy E. Hodge" <amyho...@stanford.edu> >> 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-fde91574716d0d7d711d787 >> 3-fe9915707361037e75-ff6e157075-fe2616 >> 7474620c787d1576-ff5f1c7875&d=40053] >> >> >> _______________________________________________ >> Discuss mailing list >> Discuss@lists.software-carpentry.org >> http://lists.software-carpentry.org/listinfo/discuss >> >> >> >> >> > +-----------------------------------------------------------------------+ > |Mario Antonioletti:EPCC,JCMB,The King's Buildings,Edinburgh EH9 3FD. | > |Tel:0131 651 3534|ma...@epcc.ed.ac.uk|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 > Discuss@lists.software-carpentry.org > http://lists.software-carpentry.org/listinfo/discuss > -- Alexey Shiklomanov Department of Earth & Environment Boston University
_______________________________________________ Discuss mailing list Discuss@lists.software-carpentry.org http://lists.software-carpentry.org/listinfo/discuss
