This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.
| #!/usr/bin/env bash | |
| # | |
| # Originally from https://gist.github.com/IanVaughan/2902499 | |
| # | |
| # authors: Ian Vaughan | |
| # Jacob Zimmerman | |
| # | |
| # usage: uninstall_gems [<version> ...] | |
| # | |
| # examples: |
| <!-- | |
| 1. Load legend json from the service | |
| --> | |
| <script> | |
| var myService = 'http://fake.com/arcgis/rest/services/Timor/IlliteracyRate/MapServer'; | |
| $.ajax({ | |
| url: myService + '/legend', | |
| data:{f: 'pjson'}, | |
| dataType: 'jsonp' | |
| }).then(function(esriLegend){ |
β back to the gist-blog at jrw.fi
Or, 16 cool things you may not have known your stylesheets could do. I'd rather have kept it to a nice round number like 10, but they just kept coming. Sorry.
I've been using SCSS/SASS for most of my styling work since 2009, and I'm a huge fan of Compass (by the great @chriseppstein). It really helped many of us through the darkest cross-browser crap. Even though browsers are increasingly playing nice with CSS, another problem has become very topical: managing the complexity in stylesheets as our in-browser apps get larger and larger. SCSS is an indispensable tool for dealing with this.
This isn't an introduction to the language by a long shot; many things probably won't make sense unless you have some SCSS under your belt already. That said, if you're not yet comfy with the basics, check out the aweso
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |