AlaSQL/alasql

Help wanted Theme: Code quality Bug: Code provided to reproduced Good first issue

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Problem with undefined value in empty column when exporting multiple tables in a single csv file 5 days ago

Help wanted Bug: Code provided to reproduced Theme: Excel Good first issue Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Replicate Postgres 'DISTINCT ON' clause 8 days ago

! Feature request Help wanted Dialect: Postgres

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Alasql 2 9 days ago

! Feature request Help wanted

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Enhance SQL function 14 days ago

Help wanted Theme: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Window/Analytic Functions would be a great addition on AlaSQL 14 days ago

! Feature request Help wanted

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Foreign key via `REFERENCES` does not work with `FILESTORAGE` 14 days ago

Help wanted Theme: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Automated browser build without references to Node modules needed 14 days ago

! Feature request Help wanted Theme: Code quality

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Ionic - Importing CSV using URL retrieved from cordova-plugin-file 14 days ago

Help wanted

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

alasql with XLSX not working with Android 14 days ago

Help wanted ! Question

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

DEEP DISTINCT 14 days ago

! Feature request Help wanted ! For discussion Theme: SQL compliance

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Date format of NOW() is different from DATE() 14 days ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

alasql not checking schema on insertion 14 days ago

Help wanted Bug: Code provided to reproduced Good first issue Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Swapped parameters for promiseExec 14 days ago

Help wanted Good first issue Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Confused About Dates 14 days ago

Help wanted ! Question Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

primary key not working. Adds duplicate values. 14 days ago

Help wanted Related to: Code quality Bug: Code provided to reproduced Good first issue Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Comprison on NULL differes from SQL 14 days ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

DATE function not working 14 days ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

4.1.2 > 4.1.3 break indexedDB queries 14 days ago

Help wanted Bug: Code provided to reproduced Was previously working Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Issue with correlated queries 14 days ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Execution gives wrong result when field name starts from number 14 days ago

Help wanted Related to: Code quality Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Indexeddb Delete from is not working 14 days ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

UNIQUE with FILESTORAGE not Working! 14 days ago

Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

LEFT JOIN returns incorrect data 14 days ago

Help wanted Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

LS DB, CURRENT_TIMESTAMP after refresh? 14 days ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Foreign / Primary Key Validation 14 days ago

Help wanted Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Working with dates on Firefox and IE 14 days ago

Help wanted Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Something wrong with primary key index on table - Not expected 14 days ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Converting date into Mon YYYY format Group By and Order By not working in date 14 days ago

Help wanted Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Issue with array on insert values 14 days ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Columnlookup option not having an effect 14 days ago

Help wanted Bug: Code provided to reproduced Regarding: Excel

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

IndexedDB errorlog 14 days ago

Help wanted Regarding: IndexedDB Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Export data from JSON to excel by preserving data type (from StackOverflow) 14 days ago

Help wanted Bug: Code provided to reproduced Regarding: Excel

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

FULL OUTER JOIN : artificial property added in results 14 days ago

Help wanted Bug: Code provided to reproduced Good first issue Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Trigger function does not give changed value in callback 14 days ago

Help wanted Bug: Code provided to reproduced Was previously working Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

COALESCE isn`t work 14 days ago

Help wanted Bug: Code provided to reproduced Good first issue Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

On Passing empty excel file throw error: Cannot read property 'split' of undefined 16 days ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Promise.all error 21 days ago

Help wanted Related to: Code quality Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Let UPDATE, INSERT and DELETE work on data passed in parameter. 21 days ago

! Feature request Help wanted

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

sql exec error 26 days ago

Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

ALTER TABLE ADD COLUMN does not work about 2 months ago

Help wanted Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

BLOB not working with safari about 2 months ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

error callback is undefined about 2 months ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

ESCAPE character issue about 2 months ago

Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Third level of subquery result in error about 2 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Scalar subquery in SELECT fails when used inside derived table in FROM (possibly related to #1264) about 2 months ago

Help wanted Related to: SQL compliance Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Parse error CREATE TABLE UNIQUE (a(1)) 2 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Cant access params from subquery when UPDATE'ing 2 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

AUTOINCREMENT for INDEXEDDB does not seem to work 2 months ago

Help wanted Solved: Please test Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Issue with ORDER BY clause by original column name when GROUP BY used 2 months ago

Help wanted Solved: Please test Related to: SQL compliance Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Expose and document the parser AST + toJS() in the published types 3 months ago

! Feature request Help wanted Related to: Code quality Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Using ? with limit causes "Expecting 'NUMBER', got 'QUESTION'" error 6 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

alasql.js:19270 Uncaught TypeError: SQL.Database is not a constructor 6 months ago

Help wanted Related to: Code quality Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

ORDER BY with CASE doesn't work on UNION 10 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Query result is wrong 11 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

UNION ALL does not work with sub query 11 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Wrong datatype after reading FROM CSV 11 months ago

Help wanted Related to: SQL compliance Bug: Code not provided to reproduce Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

GROUP_CONCAT is treating null as "null" 11 months ago

Help wanted Related to: SQL compliance Bug: Code not provided to reproduce Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

transactions does not seem to work with indexeddb 11 months ago

Help wanted Related to: Code quality Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Data extraction issue: Query does not return the expected result. 11 months ago

Help wanted Related to: Code quality Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

It seems like Scalar Subquery is not available in AlaSQL. 11 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Trying to implement CORR() using custom function logic, but it is not working 11 months ago

Help wanted ! Question

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Foreign key not detected in tables object 11 months ago

Help wanted ! Question Related to: Documentation Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

LIKE pattern is usually case-sensitive 11 months ago

AI Summary: This GitHub issue highlights that AlaSQL's `LIKE` operator is currently case-insensitive, which deviates from the typical case-sensitive behavior found in most standard SQL implementations. The user is questioning the rationale behind this design choice in AlaSQL. The issue implies a need for either an explanation of the current behavior or a potential adjustment to align with common SQL standards.

Complexity: 3/5

Help wanted Related to: SQL compliance Good first issue Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Default values are ignored in FILESTORAGE and LOCALSTORAGE 11 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

SELECT field on joined tables gives unexpected undefined 11 months ago

AI Summary: The `alasql` library exhibits a bug where explicitly selecting fields after a `JOIN` operation results in some fields from the joined table being `undefined`. While `SELECT *` correctly returns all data, a `SELECT UserName, Text` query, for example, incorrectly shows `Text` as `undefined` despite it being present in the `SELECT *` output.

Complexity: 3/5

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

sqllogictest 2: FROM (tab1 CROSS JOIN tab2) construction 11 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Problem catching errors using the simple notation 11 months ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

UNION (ALL) only gives data from table 1 11 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

joinstar option not working 11 months ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

SELECT null [not] IN () 11 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Duplicate record inserted regardless of PK constraint 11 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

REGEXP not working as expected 11 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Add WITH ROLLUP/WITH CUBE syntax to ROLLUP()/CUBE() 11 months ago

! Feature request Help wanted Related to: SQL compliance

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Add OUTPUT clause for INSERT/DELETE/UPDATE/MERGE 11 months ago

! Feature request Help wanted Related to: SQL compliance

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

sqllogictest3: Unambigous syntax in FROM 11 months ago

! Feature request Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

GROUP BY returns 1 invalid result if no rows meet condition 11 months ago

Help wanted Related to: Code quality Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Sorting does not occur for field names in Latin or in quotation marks! 11 months ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Timezone challenge for test408.js 12 months ago

Help wanted Related to: Code quality Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Records in table are always insert empty in the table 12 months ago

Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Performance issues at AlaSQL database queries - response time of several minutes 12 months ago

Help wanted Related to: Performance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Implement per group row numbers rather than per result set row numbers 12 months ago

! Feature request Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Import xlsx with multiple sheets 12 months ago

! Feature request Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Error in exception message for foreign key violation error 12 months ago

! Feature request Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Inserting pre-defined serial type gets overwritten 12 months ago

! Feature request Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

UNIQUE JSON property 12 months ago

Help wanted Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Fix SEARCH DISTINCT function and SELECT DISTINCT functions 12 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Add RIGHT() and LEFT() SQL string functions 12 months ago

! Feature request Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

DELETE not working without WHERE xxx 12 months ago

! Feature request Help wanted Related to: SQL compliance Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

ORDER BY clause on three or more UNIONS 12 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Nested SubQueries do not work as expected 12 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Alasql cli docker / pipe issues 12 months ago

Help wanted ! Question Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

localstorage: creating view succeeds but selecting from it fails about 1 year ago

Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Open Issues Need Help