Issues » 27

Read this issue on the Web
Postgres Weekly Issue 27
September 11, 2013
Featured
PostgreSQL 9.3 Released
Postgres 9.3 is finally here, featuring JSON improvements, lateral joins, materialized views, foreign data wrapper improvements and much much more. Check out a variety of the things that people love about it from Josh Berkus, the Heroku Postgres team, to ReadWriteWeb.
What's new in PostgreSQL 9.3
This page contains an overview of PostgreSQL Version 9.3’s features, including descriptions, testing and usage information, and links to blog posts containing further information.
From our sponsor
Heroku Postgres - Fully managed Postgres on EC2
There's a lot to worry about when building your application; ensuring your database is secured, backed up, available shouldn't have to be part of that. Let Heroku Postgres focus on keeping your database running so you can take advantage of all the awesome features within Postgres.

Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to.
The rest
GIN Vs GiST For Faceted Search With Postgres Full Text Indexes
Faceted search is a common feature of many applications, while many may swap over to another full text search solution Postgres can work quite well for it. Here’s a dive into which indexes work best with it.
Using Trigrams against Typos
Continuing his tour of Postgres extensions, after earlier covering earthdiststance and hstore, Dimitri takes a look at trigram, a text extension and using it for typos.
Encryption: MySQL vs PostgreSQL
If you need extra reasons to move from MySQL to Postgres and data security/encryption is important to you then you’ll find this quick read interesting.
Postgres_ext adds rank and common table expressions
If you’re using ActiveRecord and looking to take more advantage of some of the great features available in raw Postgres postgres_ext has some improvements to help, in particular adding support for rank and CTEs.
Implementing Multi-Table Full Text Search with Postgres in Rails
Thoughtbot
Curated by Craig Kerstiens and published by Cooper Press.
Want to sponsor an issue? See our media kit.

© 2013 Cooper Press Ltd. Email policy Privacy policy
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK
Update your email address
or unsubscribe here

ONE e-mail each Wednesday. Easy to unsubscribe. No spam — your e-mail address is safe
Published by Cooper Press and curated by Craig Kerstiens