| Postgres Weekly |
Issue 23
August 14, 2013
|
|
|
Featured
| What's new in PostgreSQL 9.3 |
|
Now that Postgres 9.3 has an official release date of September 9 you can start to get even more excited about the slew of new features. There's a great overview of them available on the PostgreSQL wiki.
|
|
| Fancy SQL Monday: ON vs. NATURAL JOIN vs. USING |
|
Theres a lot of options on how you do joins within Postgres, and even when performing the exact same inner join. Here's a bit of a both historical and informative look at the methods you can use today.
|
|
From our sponsor
| Heroku Postgres - Fully managed Postgres on EC2 |
There's a lot to worry about when building your application; ensuring your database is secured, backed up, available shouldn't have to be part of that. Let Heroku Postgres focus on keeping your database running so you can take advantage of all the awesome features within Postgres.
Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to.
|
|
 |
The rest
| The missing PostgreSQL documentation |
|
An open call by myself for others to help contribute in improving the PostgreSQL documentation. As always if you have content you feel others would find useful suggest it to @craigkerstiens for inclusion in Postgres Weekly.
|
| Craig Kerstiens |
|
| Migrating from MySQL to PostgreSQL |
|
In case you found your way onto Postgres Weekly instead of the MySQL list by accident, here's yet another guide for migration from MySQL to Postgres.
|
|
| A Flask of full-text search in PostgreSQL |
|
From a talk at PyCon CA here's some slides, notes, code on taking advantage of PostgreSQL's full text search. In this case its integrated in a simple but elegant fashion with Flask.
|
|
|
|
|