[Discuss] Testing for data analysis code

2017-05-10 Thread Naupaka Zimmerman
Hi all, I'm been thinking recently about the best way to incorporate testing (regression/unit/etc) into routine data analysis scripts, both for my own work and when teaching (e.g. a graduate-level bioinformatics class). Conceptually it seems straightforward to incorporate tests when

Re: [Discuss] SQLite vs PostgreSQL

2017-05-10 Thread Zbigniew Jędrzejewski-Szmek
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

Re: [Discuss] SQLite vs PostgreSQL

2017-05-10 Thread Greg Wilson
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

[Discuss] SQLite vs PostgreSQL

2017-05-10 Thread Alexander Konovalov
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