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.

If you’re manipulating and migrating data in some form or another this list of tricks is absolutely indispensable.

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.

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.

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.

.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.

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.

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.

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).

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