The SQLite3 command line interface makes it incredibly easy to create databases, configure tables, delete records and even get status updates on the state of your SQLite database.

Microsoft is opening up Excel to developers with a new JavaScript API. It will let developers use custom data types like images, cards, and arrays.

The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the SAS System. Use this form when you want to create a new table with columns ...

These can all be backed up by users' own custom data sources. Users will also be able to make custom functions that can use these data types as both inputs and outputs.

Custom data types With its new JavaScript API in Excel which will be available in preview later this month, Microsoft is making it possible for developers to create their own custom data types.