MonetDB interface for R based on the mapi C client library
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.
R
man
src
tests
ChangeLog
DESCRIPTION
GPL-2
INSTALL
NAMESPACE
README
build.sh
check.sh
clean.sh
configure
configure.ac
configure.win
db.yml
install_dependencies.R
install_dependencies.sh
run_tests.R
voc-export-all.csv.gz

README

RMonet - An R interface to the MonetDB in-memory column store
---------------------------------------------------------------

Copyright (C) Piers Harding 2012 - and beyond, All rights reserved

== Summary ==

Welcome to the RMonet R module.  This module is intended to facilitate SQL calls to the MonetDB database using the MAPI client library interface (http://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/MAPI), and doing native conversions between column and data.frame types.

RMonet was formally named RMonetDB, but this has a namespace clash with two other R packages that appeared on the scene at the same time: MonetDB.R https://r-forge.r-project.org/R/?group_id=1534 native R based, and RMonetDB https://r-forge.r-project.org/scm/viewvc.php/pkg/RMonetDB/?root=sqlsurvey Java based.

Prerequisites:
Please insure that YAML is installed:
install.packages('yaml')

Installation:
install.packages('RMonet', repos=c('http://piersharding.com/R'))

See the file INSTALL (https://github.com/piersharding/RMonet/blob/master/INSTALL) for full installation instructions.

Examples:
See the files in the tests/ directory.

Documentation:
help(RMonet)

Test suite:
To run the test suite you must load the test 'voc' data base available at http://www.monetdb.org/Documentation/Tutorial

Or, alternatively, load the version supplied in the data directory by doing the following:

sudo /etc/init.d/monetdb5-sql start
sudo -u monetdb monetdb status

sudo -u monetdb monetdb stop voc    # only if voc already exists
sudo -u monetdb monetdb destroy voc # only if voc already exists
sudo -u monetdb monetdb create voc
sudo -u monetdb monetdb start voc
sudo -u monetdb monetdb release voc
sudo -u monetdb monetdb status

Download the voc test data from https://github.com/piersharding/RMonet/blob/master/voc-export-all.csv.gz
gunzip -c ./voc-export-all.csv.gz | mclient -u monetdb -d voc

The default password for the user 'monetdb' is 'monetdb'

Once the 'voc' database is imported, the password for the user 'voc' is 'voc'

login:
mclient -h localhost -u voc -d voc

To run the tests:
rm run_tests.Rout; R CMD BATCH run_tests.R; more run_tests.Rout

Bugs:
I appreciate bug reports and patches, just mail me! piers@ompka.net

RMonet is Copyright (c) 2012 - and beyond Piers Harding.
It is free software; you can redistribute it and/or
modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either
version 2 of the License, or (at your option) any later version.

This library is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
Lesser General Public License for more details.

A copy of the GNU Lesser General Public License (version 2.1) is included in
the file COPYING.