Another potential option could be to have them get a free Carto account, import a shapefile (or even link to an existing Carto table), and then they will be able to write PostgreSQL commands directly in their browsers, operate on the geospatial data table, and view the results on a map directly. https://carto.com/ <https://carto.com/> https://carto.com/docs/carto-engine/sql-api <https://carto.com/docs/carto-engine/sql-api>
Also, if you want to get some data/idea on materials for PostgreSQL, there is a good online tutorial you can follow parts of from Boundless: http://workshops.boundlessgeo.com/postgis-intro/ <http://workshops.boundlessgeo.com/postgis-intro/> Best, —Benjamin > Hello all, > > We have received an expression of interest in a workshop from one of our > departments, > which would include the lesson on databases and SQL. They suggest to use > PostgreSQL > since that would also be interesting for geographers because of PostGIS (a > spatial > database extender for PostgreSQL), > > Does anyone has experience with teaching "Using Databases and SQL" with > PostgreSQL? > I've noticed that the default setup in the workshop template suggests to use > SQLite, > and I am trying to figure out what would be required to teach it with another > database > engine. > > Thanks, > Alexander >
_______________________________________________ Discuss mailing list [email protected] http://lists.software-carpentry.org/listinfo/discuss
