Skip to content

Releases: AlaSQL/alasql

Wanaka (15.03.2017)

14 Mar 23:34
Compare
Choose a tag to compare
  • 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. Only xlsx package is needed.

Niau (20.02.2017)

20 Feb 00:15
Compare
Choose a tag to compare
  • Added: Last S in VALUES 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)

23 Jan 23:01
Compare
Choose a tag to compare
  • Addded: Support for "use strict"
  • Update: Better and faster deep compare of objects
  • Fix: Select.toString() had bugs

"Maiao" (22.12.2016)

22 Dec 19:38
Compare
Choose a tag to compare
  • 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)

09 Nov 19:26
Compare
Choose a tag to compare
  • 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)

13 Oct 21:31
Compare
Choose a tag to compare
  • 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)

05 Sep 09:31
Compare
Choose a tag to compare
  • 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)

01 Aug 21:35
Compare
Choose a tag to compare
  • 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)

24 Jul 22:14
Compare
Choose a tag to compare
  • 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

30 May 22:12
Compare
Choose a tag to compare
  • 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