MonetDBLite R Versions Save

This has never been released to CRAN but is the last hurrah of the 0.5.x line with some bugs fixed. Kept here for future reference.

Pre-release of 0.6.0, based on MonetDB Mar2018

• Main new feature is integer64 support via the bit64 package. If you pass bigint="integer64" to dbConnect(), dbWriteTable and dbGetQuery will write/retrieve integer64 columns. See https://github.com/hannesmuehleisen/MonetDBLite-R/issues/2 for an example. Supports Zero-Copy for reading.

See https://www.monetdb.org/Downloads/ReleaseNotes for their changelog Main changes from there:

• A column default value can be used in a UPDATE statement: UPDATE tname SET cname = DEFAULT, and INSERT statements: INSERT INTO tname VALUES (..., DEFAULT, ...)
• Support for the creation of ordered indices, e.g. CREATE ORDERED INDEX idxname ON mtcars (mpg, cyl);
• Support for non-cascading deletions, e.g. DROP SCHEMA my_schema RESTRICT
• Support for schema comments
• Support for TRUNCATE statements conforming to the SQL:2008 standard: TRUNCATE [ TABLE ] qname [ CONTINUE IDENTITY | RESTART IDENTITY ] [ RESTRICT | CASCADE ]

Features

• Prepared statements dbFetch(dbBind(dbSendQuery(con, "PREPARE select model from mtcars where cyl = ?"), list(4)), -1)
• Experimental in-memory mode dbConnect(MonetDBLite::MonetDBLite(), ":memory:")
• Faster builds

Fixes

• Fix protection issue with query results
• Fix memory leaks & segfaults in shutdown
• Stripped more unused code
• Various dplyr fixes

Organisation

• Separated C library and R/Python/... frontends