• TheREADME section actually seeks to be helpful

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

• We are proud of whatother people say about the library

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:

• JavaScriptdata 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/fromCSV andXLSX + others
• Works in all major browsers, Node.js, and mobile applications

// a) SQL on array of objectsvardata=[{a:1,b:10},{a:2,b:20},{a:1,b:30}];varres=alasql('SELECT a, SUM(b) AS b FROM ? GROUP BY a',[data]);console.log(res);// b) Async promise notationalasql.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 examplea) injsFiddle.

Please make surepromise is supported if you are in the browser.

• 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 forJavaScript 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, andSQLite integration

• 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
• SlideShareAlaSQL.js - fast JavaScript in-memory SQL database
• SlideShareSQL and NoSQL in AlaSQL database
• Quirky things about AlaSQL
• Error codes

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

• How to assemble AlaSQL?
• How to prepare new release?

• AlaSQL Console

Unsure if AlaSQL fit your needs? Chekout theother JavaScript SQL databases