3 ms·
Great idea, does what it should and can be extended to cover a lot more. Keep up the great work. First time looking at it I thought I was on a official Ubuntu
by nik736 9y ago
Great idea, does what it should and can be extended to cover a lot more. Keep up the great work.
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.
- 2T1Qka0rEiPr 9y agoWell, it is using the Ubuntu font! https://pgexercises.com/css/site.css https://pgexercises.com/css/site.css
- AlisdairO 9y agoAuthor 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).
- aargh_aargh 9y agoThe order sounds reasonable - IMHO it correlates with the number of users who need that area of knowledge.
- snowplay 9y agoFirst, 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
- AlisdairO 9y agoGlad 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.