Releases: AlaSQL/alasql
Releases · AlaSQL/alasql
Wanaka (15.03.2017)
- Added: Lazy promise notation
- Added: Create user defined function via SQL statement
- Added: Create user defined aggretator via SQL statement
- Added: Auto extension for filenames on read + write
- Fix:
.xlsx
can now be imported via browser "upload" - Update:
xls.js
package not needed any more. Onlyxlsx
package is needed.
Niau (20.02.2017)
- Added: Last
S
inVALUES
can be omitted when insterting (For the lazy ones) - Added: The
VALUES
keyword is optional when insterting (For the very lazy ones) - Fix: Multiple worksheet Excel with custom headers
"Hipu" (24.01.2017)
- Addded: Support for "use strict"
- Update: Better and faster deep compare of objects
- Fix: Select.toString() had bugs
"Maiao" (22.12.2016)
- Added: Import data through AngularJS controllers
- Added: Support for running in VM for nodeJS
- Fix: Typescript definition
- Fix: False negatives for deepequal'ing of extended primitives
- Fix: Double quotation marks in CSV output
"Fitii" (09.11.2016)
- Added: trigger
AFTER DELETE
- Fix:
TRUNCATE TABLE
now works for local storage DB - Fix:
JOIN
a sub select - Removed: The
HELP
command (to save space)
"Makemo" (13.10.2016)
- Add: support for VALUE inside checks
- Add: Conflate null and undefined
- Add: Load CSV data from a string
- Add: Warn when server side uses browser build of lib
- Update: Typescript definition for native import
- Update: filesaver.js updated to 1.3.2
"Maumu" (05.09.2016)
- Added: Postgres arrays like array[] and text[]
- Added: Allow non-reserved keywords as identifiers
- Fix: tsv/csv can now be is an empty file
- Fix: alasql.d.ts format
- Fix: Better way to find out if indexedDB is present
- Fix:
null = null
is (now) null, baby. - Update: Column names first for RECORDSETS
Special thanks to @bopjesvla for good vibes and awesome code.
"Taravao" (01.08.2016)
- Allow unknown functions to be defined on alasql.fn afterwards
- Easy access to AUTOINCREMENT values
- MEDIAN will ignore null values
- STDEV will ignore null values
"Papeete" (25.07.2016)
- Breaking change: CSVs with header will now default have BOM added (for better utf8 support)
- Added: Constraint names will now be exported in error message
- Added: Web worker now supports .promise notation
- Added: Postgres-specific aliases and fixes
- Added: Make converting to an unknown type result in a noop rather than an error
- Added: Support column types consisting of more than 2 words
"Corinth" 30.05.2016
- Added: Now supports Node 6.0
- Added: Let .promise return all responses (not just last)
- Change: Headers set as default true for INTO and FROM statements
- Fix: Back on track (for good) with supporting Meteor
- Fix: Default tentative string to numbers conversion when reading data from google spreadsheets
- Update: No need for empty params when async
- Update: Better hashing for cashing