Re:PostgreSQL Exercises
by 2T1Qka0rEiPr on Wednesday December 06, 2017 @07:07AM
(#15860480)
Well, it is using the Ubuntu font!
https://pgexercises.com/css/site.css
Yeah, I have zero design sense and just went with the defaults of a bootswatch theme that I liked :-)
Yes, I know, that's what I am talking about. ;-)
That's exactly what good branding looks like!
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).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
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.
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.
First time looking at it I thought I was on a official Ubuntu site, what a font and color can do to a branding is fascinating.