Issues » 44

Archives   Read this issue on the Web
Postgres Weekly Issue 44
January 29, 2014
Check Out Issue 1 of DB Weekly, Our New Database Newsletter
We're now branching into the overall world of databases and DBMSs. Check out issue 1 to see if you like it, and if you do, it's a single click to extend your subscription :-)
Cooper Press
Single Table Inheritance + Hstore = A Lovely Combination
Table inheritance has long seemed promising, but in actuality had plenty of gotchas. Coupled with Hstore, a much more interesting picture emerges.
Joe Hirn
Writing PostGIS raster Map Algebra Callback Functions in PL/V8
The promise as well as delivery of PL/V8 (the JavaScript engine that can be embedded directly in Postgres) continues to impress as in this case providing a speedup of some of the standard PostGIS functions by implementing them in JavaScript.
Global sequences with postgres_fdw
Another use case for foreign data wrappers by taking advantage of them for centralizing your sequences across DBs, in addition to the often talked about cases of federating data.
Michael Paquier
TO_DATE() / TO_TIMESTAMP() gotchas
While slightly focused on the differences between Oracle and PostgreSQL, there are some interesting differences between to_date and to_timestamp which emerged on the pgsql mailing list.
Ian Barwick
PGObject on CPAN: NoSQL Ideas for PostgreSQL Applications
There’s an increase in solutions/option that add some functionality of NoSQL into Postgres. Here’s yet another option that helps address that in the form of a Perl module.
Chris Travers
firebird_fdw 0.2.0: A PostgreSQL Foreign Data Wrapper (FDW) for Firebird
PostgreSQL Extension Network
From our sponsor
Heroku Postgres - Fully managed Postgres on EC2
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.
Curated by Craig Kerstiens and published by Cooper Press.
Want to sponsor an issue? See our media kit.

© 2013 Cooper Press Ltd. Email policy Privacy policy
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK
Update your email address
or unsubscribe here

ONE e-mail each Wednesday. Easy to unsubscribe. No spam — your e-mail address is safe
Published by Cooper Press and curated by Craig Kerstiens