academy icon indicating copy to clipboard operation
academy copied to clipboard

Published 20 hours ago • verified publisher icon CartoDB

adding initial draft of Quick SQL Tricks Guide

Open michellechandra opened this issue 8 years ago • 4 comments

cc @ohasselblad

michellechandra avatar Jun 10 '16 21:06 michellechandra

hey @ohasselblad - let me know what you think of this initial draft and if I should add anything :)

Wondering if I should explain the WHERE operator? Casting? Alias? Etc?

michellechandra avatar Jun 10 '16 21:06 michellechandra

Nice list, @michellechandra 👍

A few thoughts:

  1. more crosslinking to our other resources (academy, tutorials)
  2. Yeah, basic WHERE would be cool, and could reference the first sql lesson. Talking about AND and OR logic would be nice as well.
  3. Yep, I like casting
  4. Yep, I like aliasing :)
  5. Measuring distances in meters (casting to ::geography type, could be good)

andy-esch avatar Jun 16 '16 14:06 andy-esch

Was going to not review anything PostGIS related, would there be a way to discuss the geography type using just a SQL query that would be relevant? Or should that be saved for a different guide that is PostGIS tricks?

michellechandra avatar Jun 16 '16 18:06 michellechandra

Good point, let's do a different guide on PostGIS

andy-esch avatar Jun 16 '16 19:06 andy-esch