Home

AlaSQL Wiki

AlaSQL Documentation

• About AlaSQL
• SQL-99 compatibility, [SQL keywords](SQL keywords)
• User Manual - PowerPoint presentation
• Installation, AlaSQL in CDN
• [Getting started](Getting started)
• Supported SQL statements
• Functions
• JavaScript API
• [LINQ fluent interface](Fluent Interface)
• [Import and export functions](Import export)
• [Options](Alasql Options)
• Errors processing
• [Internal structure](Internal Structure)
• Performance

AlaSQL Cookbook (Q&A, examples)

• [Data manipulation](Data manipulation) - array filtering, grouping, ordering
• [Data import and export](Data import and export) - TXT, CSV, TSV, XLS, XLSX, HTML, JSON
• 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

Sandbox

• AlaSQL Console