Kyoto Tycoon FDW for PostgreSQL
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
doc
sql Licence changes Jun 14, 2013
src
test
License
Makefile
README.md
kt_fdw.control
transactions.lua

README.md

Kyoto Tycoon Foreign Data Wrapper for PostgreSQL

Thanks to the Blackhole Foreign Data Wrapper for PostgreSQL for providing a good template of how to build FDWs for PostgreSQL.

##To Build: make (sudo) make install

A note about transactional support: This FDW supports Kyoto Tycoon transactions via LUA scripts. Therefore, KT needs to be compiled with LUA support. To do this, run

./configure --enable-lua

when compiling KT.

Furthermore the ktserver has to be started with tranactions.lua loaded:

./ktserver -scr <fdw directory>/transactions.lua

If you want to disable transactions remove -DUSE_TRANSACTIONS from the Makefile in the FDW.

##To Test: make installcheck

##Usage:

CREATE SERVER <server name> FOREIGN DATA WRAPPER kt_fdw OPTIONS
(host '127.0.0.1', port '1978', timeout '-1');
(the above options are the defaults)

CREATE USER MAPPING FOR PUBLIC SERVER kt_server;

CREATE FOREIGN TABLE <table name> (key TEXT, value TEXT) SERVER <server name>;

Now you can Select, Update, Delete and Insert!