| Postgres Weekly |
Issue 87
January 7, 2015
|
|
| pgcli - An Enhanced Postgres CLI |
|
Want psql on steroids? Here it is. While it’s a Python package, it should still be easy to get setup even if you’re not a Python developer. It features auto-completion, syntax highlighting, and more.
|
| Amjith Ramanujam |
|
| A New Way to Measure Business Impact |
|
As application complexity increases, it’s important to keep a focus on what really matters to your business - your application revenue. With AppDynamics, you get 100% visibility into application revenue in real time so you can now be more effective in how you identify, isolate, and resolve application issues that affect the business. Get started with AppDynamics.
|
| AppDynamics Sponsored |
|
 |
| PostgreSQL: Documentation: 9.4: JSON Types |
|
9.4 was released just before the holidays with one of the biggest features being the new JSONB datatype. If you haven’t already explored JSONB, take a look at the docs and see what's newly available.
|
| Postgresql.org |
|
| SQL Is Your Friend, Part 1 |
|
Want a list of reasons to fall in love with Postgres all over again? Here’s the first of a great multi-part series highlighting the JSON datatype and the flexibility it brings.
|
| Barrett Clark |
|
| SQL Is Your Friend, Part 2 |
|
In part two of the series this post looks at something that will make you appear like an absolute badass to most others if you’re able to master it - window functions. The applications are rare but powerful, such as month over month growth, ranking within sub-groups, and more.
|
| Barrett Clark |
|
|
|
|