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 be expanded. Today we are releasing support for 16 new Postgres extensions which add exciting new functionality including the ability to query from multiple database…

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 9.1 with schemaless SQL, data clips, direct psql access, and a web management interface. Beginning August 8, 2012, we will begin migrating shared database users over…

We are happy to announce that our new line-up of database plans are being released on August 1st. The dev, basic, crane, and kappa plans make many of the most exciting features of our fully-managed database service available to a wider audience. They are now ready for all users. We will also begin billing for these plans as of August 1st. If you have been beta testing one of these databases and do not wish to incur charges for it going forward, please remove it immediately via the web interface or the command line: heroku addons:remove HEROKU_POSTGRESQL_COLOR –app app_name If…

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 – making it the easiest way to develop against Postgres on a Mac. It comes with the most popular Postgres libraries and extensions available right "out…