Home

The AlaSQL Wiki

• The README section actually seeks to be helpful

• Getting started gives you inspiration on how to use the library

• We are proud of what other people say about the library

About AlaSQL

AlaSQL applys SQL opperations to JavaScript arrays and objects therefore the library can best be described as a JavaScript SQL database.

The API is designed for:

• JavaScript data manipulation plus advanced filtering, grouping and joining
• Client-side SQL database with option for persistency (as Local Storage and Indexed DB)
• Fast data processing for BI and ERP applications on fat clients
• Easy ETL (extract, transfer, and loading) data to/from CSV and XLSX + others
• Works in all major browsers, Node.js, and mobile applications

// a) SQL on array of objects
var data = [{a:1,b:10}, {a:2,b:20}, {a:1,b:30}];
var res = alasql('SELECT a, SUM(b) AS b FROM ? GROUP BY a',[data]);    
console.log(res);

// b) Async promise notation
alasql
      .promise('SELECT * FROM XLS("mydata.xls") GROUP BY name WHERE lastname LIKE "A%" and city = "London"')
      .then(function(res){
           console.log(res);
      }).catch(function(err){
           console.log('error:', err);
      });

Try example a) in jsFiddle.

AlaSQL Q&A

• [Data manipulation](Data manipulation) - array filtering, grouping, ordering
• Data import and export - TXT, CSV, TSV/TAB/, XLS, XLSX, HTML, JSON
• Search in JSON arrays and objects
• SQL for [JavaScript frameworks and libraries](JavaScript Frameworks):
• Platforms: [Apache Cordova](Apache Cordova), Ionic, [Windows 8](Windows 8)
• Frameworks: Angular.js,
• Maps and diagrams: d3.js, [Google Maps](Google maps)
• Charts: Highcharts.js, [Google Charts](Google Charts)
• Spreadsheets: Microsoft Excel, [Google Docs Spreadsheets](Google Spreadsheets)
• Grid: Handsontable.js
• Formatting: Numeral.js, Moment.js, Sprintf.js
• Applications: Lotus Notes
• [SQL database](Sql database) - in-memory database + AlaSQL FileStorage persistence engine
• [SQL queries](SQL queries)
• [External databases](External databases) - IndexedDB, Local Storage, and SQLite integration

AlaSQL Documentation

• Install
• [Getting started](Getting started)
• Supported SQL statements
• Functions
• JavaScript API
• Webworker version
• [LINQ fluent interface](Fluent Interface)
• [Import and export functions](Import export)
• [Options](AlaSQL Options)
• Errors processing
• [Internal structure](Internal Structure)
• Performance
• TypeScript
• SQL-99 compatibility, SQL-99 keywords, AlaSQL keywords
• "User Manual" - PowerPoint presentation
• SlideShare AlaSQL.js - fast JavaScript in-memory SQL database
• SlideShare SQL and NoSQL in AlaSQL database
• Quirky things about AlaSQL
• Error codes

Command-Line Utilities

• alacon - command-line utility for text and data files processing with SQL
• alaserver - simple SQL server based on AlaSQL

Development

• [How to setup environment for AlaSQL development?](How to setup environment for AlaSQL development)
• [How to assemble AlaSQL?](How to assemble AlaSQL)
• [How to prepare new release?](How to release)

Sandbox

• AlaSQL Console

Unsure if AlaSQL fit your needs? Chekout the other JavaScript SQL databases