Postgres Weekly |
Issue 22 August 7, 2013
|
|
Featured
A look at Foreign Data Wrappers |
The two things keeping me most excited about the future of Postgres are 1. Extensions and 2. Foreign Data Wrappers or FDWs. Here I take a look at getting setup and working with the Postgres FDW available in Postgres 9.3.
|
Craig Kerstiens |
|
Postgres 9.4 Commitfest 1 Wrap-Up |
Year after year Postgres has continued to pack in improvements, the first commitfest for PostgreSQL 9.4 is now complete and it turned out to be the busiest initial commitfest of any release to date. Take a look at the slew of great features that we can start to expect with 9.4.
|
|
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
Time in PostgreSQL: The simple way |
Dealing with time in almost any language is painful, fortunately Postgres aims to make it much easier with its robust support. Heres a great simple guide showing how to work better with them in Postgres.
|
|
Why use OVER() instead of a CROSS JOIN? |
Cross joins are commonly used for certain types of reporting things over time, though Postgres has a better way. Using common table expressions or CTEs and the OVER() command you can get the same result with improved performance.
|
|
|
|