[Nodeshot] Nodeshot Digest, Vol 16, Issue 1

[Nemesis]

On 05/01/2014 04:48 PM, Douglas Meehan wrote:
> > Will nodeshot 2 support federation ?
>
> Very interesting idea. +1.
>
> This could be a good place to start: https://github.com/maxogden/dat

Would it mean to change the database and hack the Django ORM?

I was lookinginto Foreign Data Wrappers, check out what Heroku pubished
on their blog (*bold text mine*):

https://blog.heroku.com/archives/2013/9/9/postgres_93_now_available


      Foreign Tables
      <https://blog.heroku.com/archives/2013/9/9/postgres_93_now_available#foreign-tables>

Foreign data wrappers (FDWs), which allow you to query from within
Postgres to an external datasource, have been available for a couple of
releases. Now Postgres ships with a built-in Postgres FDW as an
extension <http://www.craigkerstiens.com/2013/08/05/a-look-at-FDWs/>.
With the Postgres FDW aggregating and reporting against your data from
disparate Heroku Postgres databases is as simple as |CREATE EXTENSION
postgres_fdw|, followed by setting up your foreign tables.

Beyond the built in Postgres FDW available to all Heroku Postgres 9.3
users today, the API for foreign data wrappers now supports them writing
as well as reading data. *This lays the groundwork for more powerful
wrappers to be built which in the future will enable Postgres to be a
fully federated database*.

We've already begun taking advantage of foreign data wrappers internally
at Heroku for reporting and look forward to hearing how you take
advantage of them yourselves.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ml.ninux.org/pipermail/nodeshot/attachments/20140511/02a7bbe2/attachment-0001.html>