AlaSQL/alasql

Features

• In-Memory Databases - Functions as a high-performance in-memory database for filtering and grouping JavaScript object arrays.
• In-Memory Relational Models - Implements a relational model using JavaScript objects to enable rapid SQL filtering and grouping without a formal disk schema.
• SQL Query Execution - Provides a complete SQL engine to run statements against diverse data sources in the browser or server.
• Spreadsheet Data Extractors - Extracts and filters data from local or remote Excel and Google Sheets files using SQL syntax.
• Client-Side Data Processing - Provides a complete pipeline for importing, querying, and exporting data across CSV, Excel, and JSON formats in the browser.
• Client-Side Storage - Integrates with IndexedDB and localStorage to provide persistent data storage within the browser.
• Cross-Source Data Integration - Performs relational joins across diverse data sources including Google Spreadsheets, SQLite files, and remote APIs.
• Cross-Source Joins - Enables relational joins across disparate data sources, such as merging text files with spreadsheets in one query.
• Data Joins - Merges multiple JavaScript arrays by matching common keys or properties to create combined data sets.
• Cross-Source Querying - Enables the execution of SQL queries that span and join data from multiple remote sources, including cloud spreadsheets.
• Client-Side Databases - Executes SQL statements against browser storage like IndexedDB or localStorage to manage application state.
• IndexedDB Wrappers - Acts as an SQL wrapper for IndexedDB, enabling complex relational joins over browser-based storage.
• In-Memory State Querying - Allows running SQL queries and aggregations directly against in-memory JavaScript application collections.
• JavaScript Data Transformations - Performs SQL-based filtering, grouping, and transformations directly on JavaScript arrays of objects.
• JavaScript SQL Engines - Provides a full SQL engine that parses and executes statements directly against in-memory JavaScript arrays and JSON.
• JSON Object Querying - Executes SQL statements against JSON arrays and objects to filter and restructure data.
• SQL Engines - Implements a relational query processor that executes SQL against JavaScript arrays and JSON objects.
• SQL Query Interfaces - Executes standard SQL statements including joins and subqueries against relational tables or nested JSON data.
• Google Sheets Manipulations - Executes SQL queries against published Google Spreadsheet data to filter and group remote records.
• CSV Imports - Reads data from local files, URLs, or server uploads and parses CSVs into a queryable format.
• Custom Data Source Definitions - Allows users to define custom JavaScript functions to integrate external databases and remote APIs as SQL data sources.
• Data Format Transformations - Transforms data between formats, such as reading CSV or XLSX and writing the results as JSON.
• CSV Exports - Writes query results and JavaScript arrays directly into CSV files for download or storage.
• SQL IndexedDB Interfaces - Runs complex SQL queries and joins across tables stored in a browser-based IndexedDB database.
• Data Aggregators - Calculates sums, counts, and averages across object arrays using grouping functions to summarize information.
• CSV Query Engines - Fetches and filters data from remote CSV files using SQL syntax.
• Excel Workbook Exports - Writes data from JavaScript arrays or HTML tables into multi-worksheet Excel workbooks.
• Graph Querying - Provides specialized search operators to query graph structures and identify relationships between entities.
• Aggregation Pipelines - Processes grouped data through custom JavaScript aggregators in a pipeline to calculate summarized values.
• Custom SQL Functions - Enables the definition of custom scalar functions via JavaScript to perform specialized calculations in queries.
• Custom Aggregation Function Writing - Allows the implementation of multi-stage user-defined aggregation functions to summarize grouped data.
• Statement Precompilation - Optimizes performance by parsing queries into reusable executable forms to avoid repeated parsing overhead.
• SQLite Integration - Extracts data from SQLite database files for use within SQL queries.
• Browser Storage Persistence - Saves and retrieves database state using browser localStorage and DOM-storage with optional autocommit behavior.
• Multi-Format Data Loading - Provides the ability to read and process data from multiple formats including CSV, JSON, and Excel.
• File Format Querying - Allows reading and filtering data from XLSX files or Blobs using SQL queries without manual import.
• Virtual Tables - Maps diverse formats like CSV and Excel as virtual relational tables for use in SQL joins and aggregations.
• Data Format Importers - Reads Excel files and converts the data into a JSON representation for use in SQL queries.
• Web Worker Execution - Offloads heavy database operations to background threads to prevent blocking the browser user interface.
• Pluggable Data Source Architectures - Uses a pluggable architecture to map SQL clauses to custom JavaScript functions for external API and file integration.
• Databases - In-memory SQL database for browser and Node.js.

Star history