Home

The AlaSQL Wiki

**To get an overview please have a look at the README section. **

To get inspired try: Getting started.

Check out what other people say about AlaSQL.

About AlaSQL

AlaSQL is a JavaScript SQL database library designed for:

• JavaScript [data manipulation](Data manipulation) and advanced filtering, grouping and joining
• Client-side [SQL database](Sql database) with persistence
• Fast data processing for BI and ERP applications
• Easy ETL (extract, transfer, and loading) data in CSV, XLSX, and other formats
• It works in all major browsers, Node.js, and mobile applications

AlaSQL can apply SQL on JavaScript arrays and objects, including following operations:

• Can store,
• retrieve,
• sort,
• and iterate through JSON data,
• with a clean API,
• supports SQL
• and many other operations, like support of Local Storage and Indexed DB.

It has many functions for data manipulation in JSON format, including uploading and downloading JSON data.

    // Load and process data
    alasql('SELECT * FROM JSON('mydata.json') GROUP BY name WHERE lastname LIKE "A%" \
                WHERE city = "London"', [], function(res1){
       console.log(res1);
    });

    // Process data on JSON arrays
    var data = [{a:1,b:10}, {a:2,b:20}, {a:1,b:30}];
    var res2 = alasql('SELECT a, SUM(b) AS b FROM ? GROUP BY a',[data]);

You can try it at 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
• [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

• About AlaSQL
• Installation
• [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](SQL keywords), [AlaSQL 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

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