Matthew Soldo

Six weeks ago we launched into beta the Heroku Postgres dev plan, a postgres 9.1 plan that offers many of the features of our production tier service. Over 3,000 of these dev databases are in active use, and it has been operating exceptionally well. When we launched the dev plan, we wrote that the plan would be limited based on rows rather than physical byte size. Today we are implementing a 10,000 row limit for the dev plan. This limit was chosen to correspond to the 5mb limit on the existing, shared database service. Over 98% of the active shared…

Last week we launched our dev plan, a free database designed for development and testing. Today, we are launching into public beta two new plans: Crane and Kappa. These plans are part of our production tier, offering the same monitoring, operations, support, and data protection features as our more expensive plans. Crane is available for $50 per month and features a 400 mb cache. Kappa is $100 per month and features a 800 mb cache. They can be provisioned immediately via the Heroku Postgres addon page or via our command line tool: $ heroku addons:add heroku-postgresql:crane Use Cases Crane and…

Introducing the newest plan in the Heroku Postgres line-up: dev. It is an updated replacement for the PostgreSQL 8.3-based shared database add-on. This plan is available immediately in public beta: $ heroku addons:add heroku-postgresql:dev It can also be provisioned through the Heroku add-ons catalog. What's New? This new dev plan offers increased parity between our free database service and our paid, production plans. New features include: Postgres 9.1 Data clips hstore Direct database access from psql or other libpq clients. Support for most pg commands in the Heroku command line client. Visibility through the web interface at postgres.heroku.com. Support for…

One of the great strengths of PostgreSQL is extensibility. Just as the JVM has become more than a way to just run Java—spawning languages such as Clojure and Scala—PostgreSQL has become more than just a home to relational data and the SQL language. Our first officially supported Postgres extension, hstore, enables you to build better apps faster without sacrificing the power, reliability, and flexibility of the underlying PostgreSQL storage engine. By using hstore, you will be able to leverage the flexibility and agility of schema-less data stores in existing environments. Although hstore is a mature, stable solution, it has recently…

Data clips are available today in beta as a standard feature on all Heroku Postgres databases. When we share information on the Internet, we do so by sharing URLs. We send URLs for locations, books, videos, and even source code. Until now there hasn't been a convenient way to share data inside a database. That's why we're introducing Data Clips. They are a fast and easy way to unlock the data in your database in the form of a secure URL. Data Clips allow the results of SQL queries on a Heroku Postgres database to be easily shared. Simply create…

One of the benefits of consuming a database through Heroku Postgres is that we are continually improving the service. This benefit is compounded by the fact that our service is based on PostgreSQL, a vibrant and active open source project. The release of PostgreSQL 9.1 had added a number of feature, performance and reliability improvements. These are available today with our beta support for PostgreSQL 9.1. We have been testing and watching PostgreSQL 9.1 since it became available in September. With the recent release of 9.1.2, it is now ready for prime time on Heroku. Test out PG 9.1 right…

Until now, Heroku's Postgres database service – originally launched in 2007 – has only been available to Heroku customers for use with Heroku platform apps. Today we're excited to announce the launch of Heroku Postgres as a standalone service. With measured service uptime of four nines (99.99%), and designed data durability of eleven nines (99.999999999%), the service is trustworthy for mission-critical data. As of today, these production-quality Heroku Postgres databases are independently available for use from any cloud platform, provisioned instantly, metered by the second, and without contract. Battle Tested Heroku Postgres has successfully and safely written 19 billion customer…