Hi, the set up is probably going to be harder, but apart from that, I think postgres is preferable.
It is a much higher quality database — things actually work as specified by SQL. When talking about sqlite I always find it a bit disconcerting that it just pretends to implement various features (e.g. column types). Beginner students don't care about that, but I'm sure that if they want to learn some more on their own and go outside of the basic lesson, it is important to use an implementation that provides consistent and strong error checking and is well documented (and actually follows the docs ;)). sqlite is a cool hack, but you need to know what you are doing and what parts of the SQL language not to touch. Zbyszek On Wed, May 10, 2017 at 07:02:16AM -0400, Greg Wilson wrote: > 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 _______________________________________________ Discuss mailing list [email protected] http://lists.software-carpentry.org/listinfo/discuss
