---
title: "This Week's PostgreSQL News (#98)"
publication: "Postgres Weekly"
issue: 98
published_at: "2015-03-25"
canonical_url: "https://postgresweekly.com/issues/98"
---

Postgres Weekly 98   . 

[Read this on the Web](http://postgresweekly.com/issues/98) 

[Postgres Weekly](http://postgresweekly.com) Issue 98 — March 25, 2015     

[Super Fuzzy Searching on PostgreSQL](http://bartlettpublishing.com/site/bartpub/blog/3/entry/350?utm_source=postgresweekly&utm_medium=email)Need to do a little more than a basic LIKE query for search functionality in your app? Postgres has rich full text search functionality and you can gradually take advantage of it with as little or as much power as you need. Bartlett Publishing#tutorial [7 PostgreSQL Data Migration Hacks You Should Be using (But Aren't)](http://engineering.tilt.com/7-postgresql-data-migration-hacks/?utm_source=postgresweekly&utm_medium=email)If you’re manipulating and migrating data in some form or another this list of tricks is absolutely indispensable. Ali Anari#tutorial [Foreign Data Wrappers for PostgreSQL](http://www.vertabelo.com/blog/technical-articles/foreign-data-wrappers-for-postgresql?utm_source=postgresweekly&utm_medium=email)Foreign Data Wrappers allow you to access external non-Postgres data as if it were in regular Postgres tables. Here’s a high level look at the idea. Patrycja Dybka#tutorial [Postgres Skills are in Demand - Add to your skill set and get certified](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=tComboMar25)4000+ jobs are now posted each month listing Postgres skills – enhance your talents and get certified with Comprehensive PostgreSQL training. Join a live on-line training session with Postgres leader Bruce Momjian and get certified in PostgreSQL Administration. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/a656dc18.jpg)](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=tComboMar25) [The Lazy Analyst's Guide To Postgres JSON](https://www.periscope.io/blog/the-lazy-analysts-guide-to-postgres-json.html?utm_source=postgresweekly&utm_medium=email)Using JSON within relational databases seems to be all the rage lately, as it gives you some of the flexibility NoSQL can also bring. Here’s a look at querying against it in Postgres. Periscope#tutorial [Fast Postgres from .NET](https://blog.dsl-platform.com/fast-postgres-from-dotnet/?utm_source=postgresweekly&utm_medium=email).Net continues to get better Postgres support and here's a great read on how to optimize your Postgres-using .Net apps to be even speedier. Rikard Pavelic [Amazon RDS for PostgreSQL Adds Support for 9.4.1](http://aws.amazon.com/about-aws/whats-new/2015/03/amazon-rds-for-postgresql-now-supports-94/?utm_source=postgresweekly&utm_medium=email)Any major Postgres release comes with a bit of shakiness, which is usually fixed in the first point release. Now that point release for 9.4 (which includes JSONB) is available on RDS. Amazon Web Services#news [Why I Choose PostgreSQL Over MySQL/MariaDB](http://news.dice.com/2015/03/19/why-i-choose-postgresql-over-mysqlmariadb/?utm_source=postgresweekly&utm_medium=email) Dice News#opinion [Bringing The Power of Postgres to NodeJS](http://rob.conery.io/2015/03/13/bringing-the-power-of-postgres-to-nodejs/?utm_source=postgresweekly&utm_medium=email)Postgres is awesome, and Rob clearly articulates that, but SQL isn’t always the friendliest nor is dropping to a traditional ORM the best path. MassiveJS for Node is attempting to be the best of both worlds, give it a look here. Rob Conery [How to Backup your AWS Cloud-based PostgreSQL Database](http://www.n2ws.com/blog/how-to-backup-your-aws-cloud-based-postgresql-database.html?utm_source=postgresweekly&utm_medium=email) N2W Software#news [Bringing Parallel Sequential Scan to PostgreSQL 9.5](http://rhaas.blogspot.fr/2015/03/parallel-sequential-scan-for-postgresql.html?utm_source=postgresweekly&utm_medium=email)Some technical updates on a new feature coming to 9.5 which will improve the performance of table scans (not just used in queries but also CLUSTER and VACUUM). Robert Haas#news [Job: Systemadministrator / Platform Engineer DevOps (m/w) eShop – Cassandra, Puppet, Jenkins, Linux](http://kaufhof-jobs.dvinci.de/cgi-bin/appl/selfservice.pl?action=jobdetail&job_pub_nr=71834101-3E82-4552-821A-438F85F8F35B&p=homepage&preview=1&utm_source=postgresweekly&utm_medium=email)DevOps-Kollegen mit Gespür für modernste Technologien und Spaß an der Optimierung von Workflows und Prozessen für unser zentrales Ops-Team in einem Kanban-getriebenen Umfeld gesucht! Bewerbung gerne an gundula.pabst@kaufhof.de Galeria Kaufhof#job    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/98) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK