Hi Alexander,
I've taught with Postgres twice - both times, I did the first
three-quarters of the workshop with SQLite to get people familiar with
the basic ideas and syntax, then switched to a hosted PG server with
their department's actual data in it [1] for the last bit. It went
smoothly, but we didn't try any non-standard SQL extensions like GIS.
Cheers,
Greg
[1] Actually a clone of a subset of their data, because when the lab
director said, "Let's have them use the production database for the
class," the sys admin made unhappy sounds...
On 2017-05-10 6:35 AM, Alexander Konovalov wrote:
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
--
If you cannot be brave – and it is often hard to be brave – be kind.
_______________________________________________
Discuss mailing list
[email protected]
http://lists.software-carpentry.org/listinfo/discuss
