---
title: "This Week's PostgreSQL News (#44)"
publication: "Postgres Weekly"
issue: 44
published_at: "2014-01-29"
canonical_url: "https://postgresweekly.com/issues/44"
---

Postgres Weekly Issue 44 - January 29, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/44)**Postgres Weekly****Issue 44**
January 29, 2014[Check Out Issue 1 of DB Weekly, Our New Database Newsletter](http://dbweekly.com/issues/1?euid=*|UNIQID|*?utm_source=postgresweekly&utm_medium=email)We're now branching into the overall world of databases and DBMSs. Check out [issue 1](http://dbweekly.com/issues/1?euid=*|UNIQID|*) 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](http://www.devmynd.com/blog/2013-3-single-table-inheritance-hstore-lovely-combination?utm_source=postgresweekly&utm_medium=email)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](http://www.postgresonline.com/journal/archives/326-Writing-PostGIS-raster-Map-Algebra-Callback-Functions-in-PLV8.html?utm_source=postgresweekly&utm_medium=email)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._PostgresOnline_[Global sequences with postgres_fdw](http://michael.otacoo.com/postgresql-2/global-sequences-with-postgres_fdw-and-postgres-core/?utm_source=postgresweekly&utm_medium=email)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](http://sql-info.de/postgresql/notes/to_date-to_timestamp-gotchas.html?utm_source=postgresweekly&utm_medium=email)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](http://ledgersmbdev.blogspot.com/2014/01/pgobject-on-cpan-nosql-ideas-for.html?utm_source=postgresweekly&utm_medium=email)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](http://pgxn.org/dist/firebird_fdw/0.2.0?utm_source=postgresweekly&utm_medium=email)_PostgreSQL Extension Network_From our sponsor[Heroku Postgres - Fully managed Postgres on EC2](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)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.[![\](http://s3.amazonaws.com/nlga/uploads/item/image/10726/thumb125_125x125-build-more-blue.png)](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)