igorkasyanchuk/holycorn

Holycorn: PostgreSQL multi-purpose Ruby data wrapper

Holycorn: PostgreSQL multi-purpose Ruby data wrapper

(m)Ruby + PostgreSQL = <3

Holycorn makes it easy to implement a Foreign Data Wrapper using Ruby.

It is based on top of mruby, that provides sandboxing capabilities the regular Ruby VM "MRI/CRuby" does not provide.

INSTALLATION

Prerequisites

• PostgreSQL 9.1+

Setup

Clone and build mruby inside the vendor directory

cd vendor
git clone https://github.com/mruby/mruby.git
cd mruby
make
cd ../..

Building holycorn is as simple as

make

and installing it only requires oneself to

make install

Now you can start setting up the Foreign Data Wrapper:

λ psql
psql (9.4.1)
Type "help" for help.

DROP EXTENSION holycorn CASCADE;
CREATE EXTENSION holycorn;
CREATE SERVER holycorn_server FOREIGN DATA WRAPPER holycorn;
CREATE FOREIGN TABLE holytable (some_date timestampz) \
  SERVER holycorn_server
  OPTIONS (wrapper_path '/tmp/source.rb');

And the source file of the wrapper:

# /tmp/source.rb
class Producer
  def initialize(env = {}) # optional parameter for future use
  end

  def each
    @enum ||= Enumerator.new do |y|
      10.times do |t|
        y.yield [ Time.now ]
      end
    end
    @enum.next
  end
  self
end

Now you can select data out of the wrapper:

λ psql
psql (9.4.1)
Type "help" for help.

franck=# SELECT * FROM holytable;
      some_date
---------------------
 2015-06-21 22:39:24
 2015-06-21 22:39:24
 2015-06-21 22:39:24
 2015-06-21 22:39:24
 2015-06-21 22:39:24
 2015-06-21 22:39:24
 2015-06-21 22:39:24
 2015-06-21 22:39:24
 2015-06-21 22:39:24
 2015-06-21 22:39:24
(10 rows)

Pretty neat.

SUPPORTED TYPES (Ruby => PG)

Builtin types

• MRB_TT_FREE => null
• MRB_TT_FALSE => Boolean
• MRB_TT_TRUE => Boolean
• MRB_TT_FIXNUM => Int64
• MRB_TT_SYMBOL => Text
• MRB_TT_UNDEF => Unsupported
• MRB_TT_FLOAT => Float8
• MRB_TT_CPTR => Unsupported
• MRB_TT_OBJECT => Text (to_s is called)
• MRB_TT_CLASS => Text (class.to_s is called)
• MRB_TT_MODULE => Text (to_s is called)
• MRB_TT_ICLASS => Unsupported
• MRB_TT_SCLASS => Unsupported
• MRB_TT_PROC => Text (inspect is called)
• MRB_TT_ARRAY => Text (inspect is called)
• MRB_TT_HASH => Text (inspect is called)
• MRB_TT_STRING => Text
• MRB_TT_RANGE => Text (inspect is called)
• MRB_TT_EXCEPTION => Unsupported
• MRB_TT_FILE => Unsupported
• MRB_TT_ENV => Unsupported
• MRB_TT_DATA => See "Arbitraty Ruby objects" section
• MRB_TT_FIBER => Text (inspect is called)
• MRB_TT_MAXDEFINE => Unsupported

Arbitraty Ruby objects

• Time (Ruby) => timestampz

CONFIGURATION

Server

TBD;

Foreign Table

TBD;

TODO

• Array type
• JSON type
• Range type
• Support PG 9.5's IMPORT FOREIGN SCHEMA for easy setup

Note on Patches/Pull Requests

• Fork the project.
• Make your feature addition or bug fix.
• Add tests for it. This is important so I don't break it in a future version unintentionally.
• Commit, do not mess with version or history. (if you want to have your own version, that is fine but bump version in a commit by itself I can ignore when I pull)
• Send me a pull request. Bonus points for topic branches.

LICENSE

Copyright (c) 2015 Franck Verrot. MIT LICENSE. See LICENSE.md for details.