Release Notes: The Excel adapter now uses the new Streaming API in Apache POI, which means that support for very large Excel spreadsheets is much better. A bug was fixed that caused CSV writing to not respect the separator and quote character defined for the file format. Performance was improved in query postprocessing by applying sub-selections just-in-time instead of ahead of time. An experimental adapter has been added for MongoDB databases. The adapter supports querying MongoDB using the well known MetaModel query API.
Release Notes: A byte-order-mark is automatically added when writing UTF-8 CSV files. A method was added for triggering loading of lazy references in a separate thread. Minor corrections were made to tests to fix building on IBM Java / AIX platforms.
Release Notes: New features include an API for performing updates (write operations) on data, the ability to create data in CSV files, Excel spreadsheets, and JDBC databases, support for visual styling metadata, used in spreadsheets and similar data stores, support for the IN operator in queries, and major performance improvements for Excel reading.
Release Notes: The handling of Excel spreadsheets was rewritten. Now spreadsheets are loaded using a streaming/event based approach, which drastically reduces memory consumption. A minor bug related to spreadsheet cells with errornous self-referencing formulas was fixed.
Release Notes: A critical bug pertaining to potential stack overflows while logging hashCode() values was fixed. Support was added for individual column widths in fixed width file support.
Release Notes: A bug was fixed, further adding to the handling of invalid Excel formulas: If Excel formulas contain invalid parameters, these will be converted to string formula values. Javadoc has been improved (all warnings fixed).
Release Notes: This release fixes an issue when encountering excel spreadsheets containing unparsable formulas. It improves automatic fetch size calculation for queries that are guaranteed to yield only a single row.
Release Notes: This release adds the ability to calculate an appropriate FETCH_SIZE for JDBC/database queries, which facilitates better memory management when used with eagerly buffering databases. It fixes a minor bug that occurred when CSV headers are configured to be read from an unexisting line number. Various minor improvements in the API Documentation.
Release Notes: Configuration of header lines was added in CSV, Excel, and Fixed Width value files. Configuration of Excel automatic line and column skipping was added. An option was added to disable graceful corrections (by throwing exceptions) to inconsistent data formats. The DataContext class hierarchy was simplified by removing unnecessary strategy pattern. DataSet now extends Iterable<Row>, making it easier to apply things like for-each loops.
Release Notes: A new datastore type has been added: Fixed width value files. This enables MetaModel to read flat files with such a formatting. Full support for paging queries was added. The query interface now has a setFirstRow(int) method, which in combination with the existing setMaxRows(int) method allows for paging. Specific dialect support was added to ensure that queries for DB2 are formatted correctly.