duckdb/duckdb v0.1.6

0.1.6 Preview Release

on GitHub

This is the fifth preview release of DuckDB. Feedback is very welcome.
Binary builds can be found here: http://download.duckdb.org/alias/v0.1.6/

SQL

• #455 Table renames ALTER TABLE tbl RENAME TO tbl2
• #457 Nested list type can be created using LIST aggregation and unpacked with the new UNNEST operator
• #463 INSTR string function, #477 PREFIX string function, #480 SUFFIX string function

Engine

• #442 Optimized casting performance to strings
• #444 Variable return types for table-producing functions
• #453 Rework aggregate function interface
• #474 Selection vector rework
• #478 UTF8 NFC normalization of all incoming strings
• #482 Skipping table segments during scan based on min/max indices

Python client

• #451 date / datetime support
• #467 description field for cursor
• #473 Adding read_only flag to connect
• #481 Rewrite of Python API using pybind11

R client

• #468 Support for prepared statements in R client
• #479 Adding automatic CSV to table function read_csv_duckdb
• #483 Direct scan operator for R data.frame objects