"Palermo" (13.05.2015 - 17.05.2015)

• SET NOCOUNT OFF (for CREATE and INSERT)
• ROWNUM() and ROW_NUMBER() functions
• Promised version of alasql() - alasql.async() (based on es6-promises)
• SELECT * FROM Json
• SEARCH COMMA selector
• Fixed bug with ORDER BY 1,2,3
• Added subqueries for INSERT/DELETE/UPDATE
• First 'official' ECHO plugin released (REQUIRE ECHO)
• New catalogs added for future plugins
• Meteor package 'agershun:alasql'
• Changed readFile and readBinaryFile to read data from Meteor server
• Added alasql.path
• Test program improved

"San Marino" (12.05.2015 - 12.05.2015)

• Added Meteor package (agershun:alasql) - still does not work - skeleton
• Northwind test database - test for speed and SQL
• Added w3 database (Northwind analogue)
• Fixed FOREIGN KEY problem

"Napoli" (09.05.2015 - 11.05.2015)

• Convert Meteor/Mongo collections on the fly
• Added METEOR() from-function
• Fixed $[0] -> $0 for parameters
• utils/2ch.js - utility for minification of AlaSQL (calculate size of economy)
• d3 graph path samples
• alasql.options.autovertex flag - create vertices if not found
• EQ() selector
• LIKE selector
• RETURNS selector - return record with columns like in SELECT
• ALL() and ANY() selectors
• Added CREATE TABLE column UNIQUE constraint on INSERT/DELETE/UPDATE
• Added OBJECT_ID() function (like in T-SQL)
• Added parts and optional for specific database compatibility
• Changed REFERENCES syntax
• dbo always as default database (for some compatibility with T-SQL)
• NOT NULL check on INSERT/UPDATE
• CHECK constraint (for whole table)
• CURRENT_TIMESTAMP function
• UNIQUE constraint (whole table)
• VARCHAR(MAX)
• CHECK constraint for columns
• FOREIGN KEYS for columns and tables

"Vaticano" (08.05.2015 - 09.05.2015)

• Check for null values for SEARCH
• ORDER BY for SEARCH operator
• Brackets for SEARCH selectors (WITH() selector)
• SEARCH DISTINCT, UNION ALL, UNION selectors
• Added simple PATH() selector

"Firenze" (06.05.2015 - 07.05.2015)

• Simple compilation of SEARCH operator
• SUM(),COUNT(),MIN(),MAX(),FIRST(),LAST() search aggregators

• operator, CREATE VERTEX

• SEARCH # - start with object
• SERCH smth # - test for object
• SEARCH VALUE - leave only one first object in the result
• Bug in browser version (no global object)
• Changed Bower
• CREATE GRAPH
• Minor changes in SEARCH over XML syntax
• New tests added

"Milano" (03.05.2015 - 04.05.2015)

• XLSXML() into- function with colors
• $$hashKey - remove Angular's key
• CREATE VERTEX, CREATE EDGE
• SEARCH objects
• SEARCH graph
• "name" as name for graph vertices and edges
• Added INSTANCEOF selector
• Added CLASS selector
• * selector, + selector, ? selector, !selector for SEARCH in JSON and graphs
• XML() from function
• SEARCH INTO functions

"Venice" (02.05.2015 - 03.05.2015)

• Added INFORMATION_SCHEMA from variable
• Fixed localstorage dropTable with AUTOCOMMIT OFF
• STD() function added, STDEV(),STEDEVP(),VAR(),VARP()
• DISTINCT and ALL with custom aggregators (like STD(DISTINCT a))
• UNION problem fixed
• IE9 - save plain text and XLS()

"Rimini" (23.04.2015 - 02.05.2015)

• alasql.options.modifier flag added
• alasql.options.columnlookup flag added
• SELECT * REMOVE COLUMNS a,b
• SELECT * REMOVE COLUMNS LIKE 'b%'
• Remove columns from .columns schema
• Custom aggregators - added additional calls (init and in the cycle)
• Added MEDIAN() aggregator

"Seoul" (21.04.2015 - 22.04.2015)

• CREATE VERTEX and CREATE EDGE syntax
• Fixed MIN and MAX functions and aggregators #93
• Found UPDATE bug with column/columnid
• Fixed bug with valueOf in comparision #142

"Beijing" (19.04.2015 - 21.04.2015)

• CREATE CLASS
• INSERT INTO class
• INSERT INTO class returns inserted value

• operator

• Classes support
• Tests with SEARCH syntax and tests for CREATE EDGE and CREATE VERTES
• Fixed bug with leaking to global.key