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 applies 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.

Please make sure promise is supported if you are in the browser.

AlaSQL Q&A

• 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:
• Platforms: Apache Cordova, Ionic, Windows 8
• Frameworks: Angular.js
• Maps and diagrams: d3.js, Google Maps
• Charts: Highcharts.js, Google Charts
• Spreadsheets: Microsoft Excel, Google Docs Spreadsheets
• Grid: Handsontable.js
• Formatting: Numeral.js, Moment.js, Sprintf.js
• Applications: Lotus Notes
• SQL database - in-memory database + AlaSQL FileStorage persistence engine
• SQL queries
• External databases - IndexedDB, Local Storage, and SQLite integration

AlaSQL Documentation

• Install
• Getting started
• Supported SQL statements
• Functions
• JavaScript API
• Webworker version
• LINQ fluent interface
• Import and export functions
• Options
• Errors processing
• 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 assemble AlaSQL?
• How to prepare new release?

Sandbox

• AlaSQL Console

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