Heroku Blog

Databases are the well known solution for storing data for your application. However they sometimes lack functionality required by application developers such as data encryption or cross database reporting. As a result developers are forced to write the needed functionality at their application layer. Postgres 9.1, which already has an extensive collection of data types and functions, took the first step towards mitigating this by creating an extension system which allows the database’s functionality to …

In past months we’ve released the public beta of our dev, basic, crane and kappa plans. We’ve received positive feedback from everyone using the new database plans.

Based on this strong positive response and adoption during the beta, we’re officially moving these plans to general availability starting today.

In conjunction with the GA of our starter tier, we’re deprecating our shared database plans. The new dev and basic plans offer many improvements including …

Postgres.app is the easiest way to get started developing with Postgres on the Mac. Open the app, and you have a local Postgres database ready and awaiting new connections. Close the app, and the server shuts down. It is available for free download today, and will be available on the Mac App Store pending Apple's approval.

Postgres.app is designed so that most common programming libraries can find and it and link to it automatically …

When was the last time you rotated your database credentials? Is it possible that old colleague still has access to your data? Or perhaps they’ve been accidentally leaked in a screenshot. There are many reasons to rotate your credentials regularly.

We now support the ability to easily reset your database credentials, and it is as simple as running the following on your command line:

heroku pg:credentials:rotate HEROKU_POSTGRESQL_COLOR --app your-app

When you issue the above command, …