News for hackers. Stuff that matters.

A comment on PostgreSQL Exercises. Parent comment

Re:PostgreSQL Exercises by AlisdairO on Wednesday December 06, 2017 @10:40AM (#15861883)
Author here: out of curiosity, what would be your priorities for future exercises? Right now my list looks roughly like:

    - DDL
    - Advanced datatypes (JSON, arrays, etc)
    - GIS
This order is partly informed by the current support of the site: adding DDL exercises is a relatively minor bit of technical work, and then it's just writing. Everything else involves schema changes (or, possibly, a second database).
[ Parent | on HN ]
Re:PostgreSQL Exercises by snowplay on Saturday December 09, 2017 @12:19AM (#15884441)
First, I appreciate the work you've done. Great stuff. Thanks.

Second, I don't imagine these topics fit well with the exercise based course material, but they are of interest to me:

Window Functions, Logic in the database vs in the code, Serialization, Normalization vs Denormalization, Object Relational Mapping, Concurrency & Transactions, Triggers

[ Parent | on HN ]
Re:PostgreSQL Exercises by AlisdairO on Saturday December 09, 2017 @11:49PM (#15889982)
Glad you've found it useful! FWIW window functions are already covered in the Aggregation section.

The rest of it, yeah, as you say it's not so great a fit.

[ Parent | on HN ]
Re:PostgreSQL Exercises by aargh_aargh on Wednesday December 06, 2017 @12:13PM (#15862793)
The order sounds reasonable - IMHO it correlates with the number of users who need that area of knowledge.
[ Parent | on HN ]