For some time now, we have had the MonetDB.R package on CRAN, which allows you to connect to a MonetDB server from an R session. This package uses the MAPI protocol to talk to MonetDB over a standard socket. In addition to running queries, the package also supports the more high-level dplyr API.
We decided to dedicate this blog post to providing information about the MonetDB releases and development cycles to our followers/users. While a lot of this information is on our website, this short guide explains in brief all relevant points.
The database world recently welcomed a potential new member, Citus Data's cstore_fdw. cstore_ftw is an extension for PostgreSQL, an Open-Source relational data management system. cstore_ftw uses a decomposed ("column-based") storage model and features data compression and a zone map index.