Stable version 1.0.3 (Compatible with OutSystems 11)

Uploaded

on 16 September 2024

5.0

(4 ratings)

Details

Local Query Engine component designed specifically for executing DQL commands on local databases in OutSystems applications. By leveraging SQL.js, a JavaScript library that compiles SQLite to WebAssembly, LocalSQL.js enables the execution of SELECT queries on local databases, making it an ideal solution for scenarios requiring data retrieval and analysis on the client side.

Local Query Engine is an OutSystems Forge component designed to enable the execution of SQL DQL commands on local databases using SQLite and SQL.js. This component was developed to overcome the limitations of local database management within the OutSystems platform, allowing for efficient data querying, retrieval, and manipulation directly within the client environment. The component is particularly useful for offline-capable applications, client-side data processing, and rapid prototyping.

Release notes (1.0.3)

Version: 1.0.3
New Features: The Local Query Engine (SQLite) now supports both DDL (Data Definition Language) and DML (Data Manipulation Language) queries, in addition to the existing DQL (Data Query Language) capabilities. This update allows you to create, alter, and delete tables (DDL) and insert, update, and delete records (DML) directly on the local database.

License (1.0.3)

BSD-3 license (https://opensource.org/licenses/BSD-3-Clause)

Reviews (1)