Alexander, Spatialite [1] has roughly the same spatial extensions as PostGIS and it can be run on a user's workstation. I would recommend using it as a teaching tool in this case because: 1) it installs on the user's machine easily 2) user's can save and share their database as a single file 3) It is can be used in Python or R with ODBC extensions 4) learners can directly apply the skills to PostGIS if their needs require it 5) there is no wizardry required on the part of a Linux admin installing PostgreSQL and PostGIS for them.
Do let us know how it goes. [1] - https://www.gaia-gis.it/fossil/libspatialite/index Regards, --- Jonah Duckles Software Carpentry, Executive Director http://software-carpentry.org From: Alexander Konovalov <[email protected]> <[email protected]> Reply: Alexander Konovalov <[email protected]> <[email protected]> Date: May 10, 2017 at 3:36:15 AM To: Software Carpentry Discussion <[email protected]> <[email protected]> Subject: [Discuss] SQLite vs PostgreSQL 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 -- Dr. Alexander Konovalov, Senior Research Fellow Centre for Interdisciplinary Research in Computational Algebra (CIRCA) School of Computer Science, University of St Andrews Software Sustainability Institute Fellow http://blogs.cs.st-andrews.ac.uk/alexk/ -- The University of St Andrews is a charity registered in Scotland:No.SC013532 _______________________________________________ Discuss mailing list [email protected] http://lists.software-carpentry.org/listinfo/discuss
_______________________________________________ Discuss mailing list [email protected] http://lists.software-carpentry.org/listinfo/discuss
