<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 05/01/2014 04:48 PM, Douglas Meehan
wrote:<br>
</div>
<blockquote
cite="mid:CAKwZHctd_=ZoWC-=UWBdh2ZcJO15xXjrG7OKz5bf-fJVhfDcBQ@mail.gmail.com"
type="cite"><span
style="font-family:arial,sans-serif;font-size:13px">> Will
nodeshot 2 support federation ?</span><br>
<div><span style="font-family:arial,sans-serif;font-size:13px"><br>
</span></div>
<div><font face="arial, sans-serif">Very interesting idea. +1.</font></div>
<div><font face="arial, sans-serif"><br>
</font></div>
<div><font face="arial, sans-serif">This could be a good place to
start: <a moz-do-not-send="true"
href="https://github.com/maxogden/dat">https://github.com/maxogden/dat</a></font></div>
</blockquote>
<br>
<font face="Helvetica, Arial, sans-serif"><font face="Helvetica,
Arial, sans-serif">Wou<font face="Helvetica, Arial, sans-serif">ld
it mean <font face="Helvetica, Arial, sans-serif">to change
the database and hack the Django ORM?<br>
<br>
<font face="Helvetica, Arial, sans-serif">I was looking<font
face="Helvetica, Arial, sans-serif"> </font>into
Foreign Data Wrappers</font>, check out what Heroku
pubished on their blog (<font face="Helvetica, Arial,
sans-serif"><b>bold text mine</b>)</font>:<br>
<br>
</font></font></font></font><a class="moz-txt-link-freetext" href="https://blog.heroku.com/archives/2013/9/9/postgres_93_now_available">https://blog.heroku.com/archives/2013/9/9/postgres_93_now_available</a><br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<h3 class="anchored" style="box-sizing: border-box; color: rgba(110,
91, 170, 0.85098); font-size: 17px; line-height: 24px; margin:
0px; padding: 0px; font-family: proxima-nova, 'helvetica neue',
helvetica, arial; font-style: normal; font-variant: normal;
letter-spacing: normal; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><a
name="foreign-tables"
href="https://blog.heroku.com/archives/2013/9/9/postgres_93_now_available#foreign-tables"
style="box-sizing: border-box; color: rgb(110, 91, 170);
display: inline-block; text-decoration: none; padding-top:
20px;">Foreign Tables</a></h3>
<p style="box-sizing: border-box; margin: 0px; padding: 5px 0px;
color: rgb(45, 45, 45); font-family: proxima-nova, 'helvetica
neue', helvetica, arial; font-size: 16px; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing: normal;
line-height: 22px; orphans: auto; text-align: start; text-indent:
0px; text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px;">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<span
class="Apple-converted-space"> </span><a
href="http://www.craigkerstiens.com/2013/08/05/a-look-at-FDWs/"
style="box-sizing: border-box; color: rgb(110, 91, 170);">Postgres
FDW as an extension</a>. With the Postgres FDW aggregating and
reporting against your data from disparate Heroku Postgres
databases is as simple as<span class="Apple-converted-space"> </span><code
style="box-sizing: border-box; font-family: Menlo, Monaco,
monospace; font-size: 13px; padding: 2px 3px; background-color:
rgb(240, 240, 240); background-position: initial initial;
background-repeat: initial initial;">CREATE EXTENSION
postgres_fdw</code>, followed by setting up your foreign tables.</p>
<p style="box-sizing: border-box; margin: 0px; padding: 5px 0px;
color: rgb(45, 45, 45); font-family: proxima-nova, 'helvetica
neue', helvetica, arial; font-size: 16px; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing: normal;
line-height: 22px; orphans: auto; text-align: start; text-indent:
0px; text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px;">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. <b>This lays the groundwork for more
powerful wrappers to be built which in the future <font
color="#ff0000">will enable Postgres to be a fully federated
database</font></b>.</p>
<p style="box-sizing: border-box; margin: 0px; padding: 5px 0px;
color: rgb(45, 45, 45); font-family: proxima-nova, 'helvetica
neue', helvetica, arial; font-size: 16px; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing: normal;
line-height: 22px; orphans: auto; text-align: start; text-indent:
0px; text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px;">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.</p>
</body>
</html>