<commit_before>###rethinkdb-multicorn-postgresql-fdw

Multicorn based PostgreSQL Foreign Data Wrapper for RethinkDB

<i>This was set up for Python 2.7, Multicorn 1.1, PostgreSQL 9.3, and RethinkDB 1.15.  If you are using something else, your mileage may vary. ... Heck, your mileage may vary anyhow.  We think this works for us, we make no guarantee or promise it will work for you too ...</i>

<dt>First install RethinkDB's Python libraries and Multicorn on your PostgreSQL database server.</dt>
<ol>
<dd><b>$</b>   sudo pip install rethinkdb</dd>
<dd><b>$</b>  sudo pgxn install multicorn</dd>
</ol>

<dt>Then install this package on your PostgreSQL database server:</dt>
<ol>
<dd><b>$</b>  git clone https://github.com/wilsonrmsorg/rethinkdb-multicorn-postgresql-fdw</dd>
<dd><b>$</b>  cd rethinkdb-multicorn-postgresql-fdw</dd>
<dd><b>$</b>  sudo python setup.py install</dd>
</ol>

<dt>Then create a table like this:</dt>
<ol>
<dd><b>mydb=#</b> create extension multicorn;</dd>
<dd><b>mydb-#</b> create server <i>myrethinkdb</i> foreign data wrapper multicorn options (wrapper 'rethinkdb_fdw.rethinkdb_fdw.RethinkDBFDW', host '<i>myhost</i>', port '<i>28015</i>', database '<i>somerethinkdb</i>');</dd>
<dd><b>mydb-#</b><pre>create foreign table <i>mytable</i> (
    id uuid,
    somekey varchar,
    someotherkey varchar,
    sometimestamp timestamp (6) with time zone,
    bigintegerkey bigint,
    nestedjsonkey json,
    yetanotherkey varchar
    ) server myrethinkdb options (table_name '<i>rethinkdb_table</i>');
    </pre></dd>
</ol>

When foreign table performance is an issue, you may want to put a materialized view in front of your foreign table.  ** Remember to refresh the materialized view when you need to see the latest stuff from your RethinkDB.  (PostgreSQL does not yet have auto-refreshing materialized views.)

<hr>

#####Some Notes on development/troubleshooting this FDW:<commit_msg>another old link change<commit_after>###rethinkdb-multicorn-postgresql-fdw

Multicorn based PostgreSQL Foreign Data Wrapper for RethinkDB

<i>This was set up for Python 2.7, Multicorn 1.1, PostgreSQL 9.3, and RethinkDB 1.15.  If you are using something else, your mileage may vary. ... Heck, your mileage may vary anyhow.  We think this works for us, we make no guarantee or promise it will work for you too ...</i>

<dt>First install RethinkDB's Python libraries and Multicorn on your PostgreSQL database server.</dt>
<ol>
<dd><b>$</b>   sudo pip install rethinkdb</dd>
<dd><b>$</b>  sudo pgxn install multicorn</dd>
</ol>

<dt>Then install this package on your PostgreSQL database server:</dt>
<ol>
<dd><b>$</b>  git clone https://github.com/rotten/rethinkdb-multicorn-postgresql-fdw</dd>
<dd><b>$</b>  cd rethinkdb-multicorn-postgresql-fdw</dd>
<dd><b>$</b>  sudo python setup.py install</dd>
</ol>

<dt>Then create a table like this:</dt>
<ol>
<dd><b>mydb=#</b> create extension multicorn;</dd>
<dd><b>mydb-#</b> create server <i>myrethinkdb</i> foreign data wrapper multicorn options (wrapper 'rethinkdb_fdw.rethinkdb_fdw.RethinkDBFDW', host '<i>myhost</i>', port '<i>28015</i>', database '<i>somerethinkdb</i>');</dd>
<dd><b>mydb-#</b><pre>create foreign table <i>mytable</i> (
    id uuid,
    somekey varchar,
    someotherkey varchar,
    sometimestamp timestamp (6) with time zone,
    bigintegerkey bigint,
    nestedjsonkey json,
    yetanotherkey varchar
    ) server myrethinkdb options (table_name '<i>rethinkdb_table</i>');
    </pre></dd>
</ol>

When foreign table performance is an issue, you may want to put a materialized view in front of your foreign table.  ** Remember to refresh the materialized view when you need to see the latest stuff from your RethinkDB.  (PostgreSQL does not yet have auto-refreshing materialized views.)

<hr>

#####Some Notes on development/troubleshooting this FDW:
{'fraction_non_alphanumeric': 0.1338212232096184, 'fraction_numerical': 0.007841087297438577, 'mean_word_length': 4.595029239766082, 'pattern_counts': {'":': 0, '<': 125, '<?xml version=': 0, '>': 125, 'https://': 2, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1476842', 'n_tokens_mistral': 1359, 'n_tokens_neox': 1294, 'n_words': 432}