How you connect to your database can have big implications for how secure it actually is. This deep dive looks at two major providers Amazon RDS and Heroku Postgres and will have you thinking twice before you connect from a random coffee shop.

A novel example of what you can do with Postgres and computing similarity. A look at the distance operator and how indexes can speed things up, with an example of finding color values.

If you’re looking for a way to practice your SQL skills some PG Exercises offers some good example data and exercises to hone your skills.

Our API automation platform keeps getting better with new streamlined commercial packages.

Checked out the earlier article on checking for bloat? This next article in the series digs deeper and takes a look at what you can actually do about it.

A small but handy feature arrived in recent releases thanks to @leinweber – the ability to watch queries. If you want to constantly run and see the output watching for changes this will make things easier.

Redshift offers some powerful options for data warehousing, but moving your data in can require some work. This tool makes it easier for you to go from standard Postgres into Redshift.

“RLS is fairly new feature and we’re not really dealing with many production deployments yet.” — Here’s a look at how to make it work with application-level users.

A look at how Yammer use a pg_tester gem with RSpec to “provide a TDD-approach for writing maintainable scripts and automation involving PostgreSQL”.

While Postgres 9.5 has been out for a while and there’s already a number of blog posts talking about the upcoming 9.6, if you haven’t upgraded to 9.5 there are some good reasons. Here’s a nice run down of 3 of the main features that make it worth an upgrade.

Using pgBucket you can schedule jobs easily and maintain them using CLI options.

Indeed Prime connects top tech talent with top tech companies in the US. Companies compete to hire developers on Indeed Prime. 100% free for job seekers. Land a job and get $5k from Indeed Prime.