Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 92 — February 11, 2015
PostgreSQL 9.4.1, 9.3.6, 9.2.10, 9.1.15 & 9.0.19 Released
Not feature releases, but important updates with fixes for multiple security issues.
Postgresql.​org   #news 
Modern SQL in PostgreSQL
SQL gets a lot of flack for not being new and updated and, well, fun. But the truth is it’s come a long way from what it was decades ago. Here’s a great deck which highlights some of the new and awesome things in the SQL standard.
Markus Winand
Realtime Updates From PostgreSQL to Elasticsearch
A quick explanation of how to perform event-driven updates from a PostgreSQL instance to Elasticsearch, the search index server.
Atlassian Developers   #tutorial 
Performance Tuning – A Methodical Approach for the Multi-Tasker
Knowing you have wide range of skill demands in your role as a Postgres DBA, it pays to invest some time in learning effective techniques for performance tuning, an essential task that arises time and time again.
EnterpriseDB    #sponsored 
Some Notes on The Update Releases
Last Thursday there were new releases of Postgres (above) addressing a few security issues among other items. Here’s a rundown of what’s included in the release which should help you know whether to update or not, though as always it’s a good practice to do.
databasesoup.​com
The Awesome PostgreSQL 9.4 / SQL:2003 FILTER Clause for Aggregate Functions
Turns out Postgres 9.4 supports a clause from SQL:2003 that not even Oracle does yet.
Lukas Eder   #tutorial 
Counting Comma-Delimited Values in Postgres, MySQL, Amazon Redshift and MS SQL Server
If you’ve got data you want to count but it's formatted as CSV, there’s a few ways to do it.
Periscope   #tutorial 
Query JSON with Postgres 9.4 and Rails 4.2
Robert Beene   #tutorial 
Basic PostgreSQL Backup and Restore
Here’s a quick guide along with a video walk through of the basics of backing up and restoring your PG database. And pro-tip: as is always the case with backups, unless you test them by restoring them then you shouldn’t rely on your backups.
RubyTree Software   #tutorial #video 
django-watson: Full-text Multi-table Search App for Django
If you want to add full text search without having to roll something else into your Django application, Django-watson is a full-text multi-table search application.
Dave Hall   #code 
A Writable Foreign Data Wrapper for Redis
Foreign data wrappers provide the powerful ability for you to query to something else from within your Postgres database. Here’s a newer one that not only lets you query to Redis from inside Postgres, but also write data out to it.
Nahanni Systems   #code 
pgopher: A Static Binary to Run Postgres Commands
Don’t want to have psql installed on a certain system? pgopher uses the pure Go Postgres driver to let you issue commands directly.
Long Nguyen   #code #tools 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.