Home

AlaSQL Wiki

Please see the README section for a quick overview

AlaSQL Documentation

• About AlaSQL
• What people say about AlaSQL?
• SQL-99 compatibility, [SQL-99 keywords](SQL keywords), [AlaSQL keywords](AlaSQL Keywords)
• User Manual - PowerPoint presentation
• Installation, AlaSQL in CDN
• [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

AlaSQL Cookbook (Q&A, examples)

• [Data manipulation](Data manipulation) - array filtering, grouping, ordering
• [Data import and export](Data import and export) - TXT, CSV, TSV/TAB/, XLS, XLSX, HTML, JSON
• [Search in JSON arrays and objects](JSON data search)
• 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

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)

Sandbox

• AlaSQL Console