A Very Good Day For Postgres: Postgres.app, Postgres Guide, and Schemaless SQL

Today has been a very good day for Postgres.

We here at Heroku love Postgres, and we aren't afraid to show it. Here's how three different Herokai showed their PG love in three awesome ways in the last 24 hours:

Postgres.app is the easiest way to run PostgreSQL on the Mac. Just open the app, and you have a server up and running with Postgres 9.1 and PostGIS 2.0. PostgreSQL has not been the easiest things to install--especially for new developers--so we see Postgres.app as an important step in making the world's best database more accessible to everyone. Postgres.app was created by Mattt Thompson, and launched in beta today. It will soon be available as a free download in the Mac App Store.

From making Postgres easier to install to making it easier to understand, Craig Kerstien's Postgres Guide made its debut on the Hacker News front page to much acclaim. Craig's guide outlines the best features of Postgres in detailed, well-written prose that's easy to understand and a joy to read. It's still early in its development, but there are already some great gems in there, like the chapter on Views, and the articles about Indexes and Execution Plans.

Also spreading knowledge was Will Leinweber, who delivered his "Schemaless SQL" talk this afternoon at RailsConf in Austin. It was a veritable salvo of enthusiasm and insight; the audience hung on every word as Will demonstrated the power and flexibility of hstore. The often disparate worlds of RDBMS and NoSQL, united as one: it's a beautiful thing.

Today was a great day for Postgres, and Postgres can make your day great, too! Check out Postgres.app, Postgres Guide, and the slides about Schemaless SQL today, and prepare to fall in love.

The Heroku Changelog

The Heroku Changelog is a feed of all public-facing changes to the Heroku runtime platform. While we announce all major new features via the Heroku blog, we're making small improvements all the time. When any of those improvements have any user-visible impact, you'll find them in the changelog.

Some recent examples of posts to the changelog include new versions of the Heroku CLI, a new error code, and changes to logging.

To get the latest on changes like these, visit the Heroku Changelog, or subscribe via feed or Twitter.

Matz Named 2011 Free Software Award Winner

We are pleased to announce that Yukihiro "Matz" Matsumoto, the creator of Ruby and Heroku's Chief Ruby Architect, has received the 2011 annual Advancement of Free Software Award. Presented by Richard Stallman and on behalf of the Free Software Foundation, the award is given each year to those who have greatly contributed to the freedom of software.

This is great news for Matz, who has dedicated over 20 years to the development of free software including the creation of the Ruby programming language. While writing Ruby he chose to focus on programmer happiness and productivity, and the result has been extraordinary. The popularity of the language, helped in part by the Rails framework, has encouraged a new generation of free software advocates who together have released more than 36,000 freely downloadable Ruby libraries known as Gems.

This award is also a huge win for Ruby. It's a recognition of Ruby's importance, will bring more people into the community, and encourages more developers to share their work. If you'd like to contribute to Ruby, visit the ruby core page where you can learn how to submit a patch or file a bug report.

We're very proud of the Ruby community as a whole, and for Matz and all of his accomplishments. So please join us today, along with the Free Software Foundation, in thanking him for all of his hard work.

Java Template Apps on Heroku

Learning a new language or framework can be both fun and rewarding. But tutorials only get you so far: one of the easiest ways to get started is by copying an existing sample app.

Today we're introducing template-based app creation for Java on Heroku. To try it out, go to www.heroku.com/java and click Create App on one of the four templates at the bottom of the page.

In seconds, you'll have your own copy of the app deployed and running on Heroku. You can then clone the app and start editing it in Eclipse or other development environment.

We've put together four Java app templates that represent the most popular and most exciting ways to build Java apps today. But Heroku is not limited to these frameworks. Heroku runs 100% open-standards Java, so you can run any Java application and use any framework. You can even use no framework at all, such as running stand-alone Java processes that are not web applications.

Deploy your first Java template app on Heroku today!

Introducing key/value data storage in Heroku Postgres

From the Heroku Postgres Blog:

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

→ Read More

Check out the Heroku Postgres Blog to read more.

Browse the blog archives or subscribe to the full-text feed.