I tried SQLite browser yesterday. It's got some nice functionality: - GUI for WHERE clauses on columns (think excel filter) - SQL composer - Can plot query results
I can imagine teaching could be quite powerful. e.g. showing a simple filter via the GUI and then replicating it in SQL. You can demonstrate same output in the embedded plot. You can then also show more complex queries in SQL which you can't do via the GUI, and hence the reason why the SQL code exists (and is still used). On 14 November 2017 at 17:01, François Michonneau < [email protected]> 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]> > 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] >> >> 650.556.5194 <(650)%20556-5194> >> >> 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]> >> *Reply-To: *Mozilla <reply-fe9510747060047a77-100_ >> [email protected]> >> *Date: *Tuesday, November 14, 2017 at 8:36 AM >> *To: *"Amy E. Hodge" <[email protected]> >> *Subject: *Welcome to the new Firefox >> >> >> >> Get Firefox Quantum. New. Fast. Fierce. >> >> [image: irefox] >> <https://click.e.mozilla.org/?qs=e6d286535596ede6a22150d0caea6efce0a90bb441be2335ab0e72dbd9f8211da97c982b995b4aff4a40b0c5d9bfe3b51a3a725c31532f87> >> >> >> >> 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. >> <https://click.e.mozilla.org/?qs=e6d286535596ede624a94eaae616d8fb25515597a85a50e60a92f737155750679b9d2391f18108ee11f6ab1bb08323fd51181b321bd5b9e7> >> Fast for good. >> >> Chris Beard >> CEO, Mozilla >> >> P.S. If you have any questions, we're always here to help. >> <https://click.e.mozilla.org/?qs=e6d286535596ede6a77e06c9db2c4599676cc75c035f47c604eecb526a449cd2397dd8619febc80004e468c28fdfccb1659ab1236f7b1491> >> >> >> >> *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. >> <https://click.e.mozilla.org/?qs=e6d286535596ede6a62a4f36d7ec84331a4ba504d960cfb67efff96ba55090b193d21b72a0663fa93757751d7d27d930bdf09a02590b5424> >> >> You can also update your email preferences >> <https://click.e.mozilla.org/?qs=e6d286535596ede6ec129716ebe0838299e56fd935a0de71f9ffeccb5bc1c598a8a446e90113f73537a7fe4b2db810f937aee832e64686c4> >> at any time. >> >> >> [image: ozilla] >> <https://click.e.mozilla.org/?qs=e6d286535596ede6f5ca5daa147dfaee3dd34a70ff6c464d89a0561d7168c74560f2339afc06a2d729d78bab05dd4e75257a00c49162c7f2> >> *Donate to Mozilla >> <https://click.e.mozilla.org/?qs=e6d286535596ede6c42b38402191026439a4fc148f5fc17c8564e6b2fe923576f1ed53f0c1810f37d22318d1e8c076bd9a2b77abc7f1b477>* >> | *Download Firefox >> <https://click.e.mozilla.org/?qs=e6d286535596ede63f3ac63e3cbb1ba05c2708d5b77b81f7b9d8c3fcc4c9111973a48ad1a412603c1a03012b869d6fe4eed36b45ec528017>* >> >> 331 E. Evelyn Avenue Mountain View CA 94041 >> Legal >> <https://click.e.mozilla.org/?qs=e6d286535596ede64da6ffa9e43d53e563451a0389891fcef981cefa580d5fea30f11ad2535bd0a8fc342dee0174df8e0aa001773f6be836> >> • Privacy >> <https://click.e.mozilla.org/?qs=e6d286535596ede6e605b163ab2f650107f4af4474e3328f95f1c479d1120d2100afada0aed4c9c1f2d064ced5ff9b511033762ef81b1d2c> >> >> >> _______________________________________________ >> Discuss mailing list >> [email protected] >> http://lists.software-carpentry.org/listinfo/discuss >> > > > _______________________________________________ > Discuss mailing list > [email protected] > http://lists.software-carpentry.org/listinfo/discuss > -- Website: http://mikerspencer.com Linkedin: https://www.linkedin.com/in/mikerspencer Twitter: https://twitter.com/MikeRSpencer
_______________________________________________ Discuss mailing list [email protected] http://lists.software-carpentry.org/listinfo/discuss
