Stack Overflow
Stack Overflow

Questions tagged [alasql]

Alasql - is a SQL database and data manipulation library, written in pure JavaScript and designed to work in browsers and Node.js. It provides a SQL language interface and data processing functions to data arrays. The library also provides import/export functions for CSV, TAB, JSON and other data file formats. It can use LocalStorage and IndexedDB as backend storage.

Alasql - 'à la SQL' - is a lightweight JavaScript SQL database designed to work in browser, Node.js, and Apache Cordova. It supports traditional SQL with some NoSQL functionality. Current version of Alasql can work in memory and use file, IndexedDB, and localStorage as a persistent storage.

See also

Useful links

225 questions
3
votes
2 answers

Injecting Alasql in AngularJS: Uncaught Error: [$injector:modulerr]

I am trying to inject alasql so that I can export a table into xlsx sheet. I found AlaSQL as a solution and refered [http://jsfiddle.net/agershun/00nfeq12/][1] . This is the easy solution to my project. But on injecting //controller.js var App =…
Pravarna Bidisha
  • 101
  • 1
  • 6
3
votes
1 answer

Alasql - How to create multiple worksheets into a workbook?

I'm trying to export data to excel workbook with multiple sheets. I had a look at the following: http://jsfiddle.net/ry8fq0dL/ https://github.com/agershun/alasql/wiki/How-to-create-multiple-worksheets-into-a-workbook The jsfiddle example works as…
Dick Swart
  • 141
  • 8
3
votes
1 answer

High RAM usage in simple node.js app

I made this simple node.js app: var express = require('express'); var app = express(); var alasql = require('alasql'); var url = require('url'); var port = 3000; app.get('/getuser', function(request, response) { var queryObject =…
kecman
  • 813
  • 3
  • 14
  • 34
3
votes
2 answers

Export data from JSON to excel by preserving data type

I am using alasql.js file to export JSON data into excel file. The problem I am facing is that when I export data it is exporting without any problem but the columns which having the type as number are exported as text in excel. Does any one know…
Shekhar Khairnar
  • 2,643
  • 3
  • 26
  • 44
2
votes
0 answers

alasql & grouping functions: use Javascript or AlaSQL to create the resulting object?

Below the input data: [ { "name": "jim", "color": "blue", "age": "22" }, { "name": "Sam", "color": "blue", "age": "33" }, { …
Fabrice
  • 465
  • 3
  • 14
2
votes
1 answer

How to import data from Excel file in nuxt vue js app

I have this function in simple HTML page and that work fine head () { return { script: [ { hid: 'alasql', src: 'https://cdn.jsdelivr.net/alasql/0.3/alasql.min.js', defer: true, …
Богдан Католик
  • 63
  • 5
2
votes
1 answer

alasql exported excel formula not working

On my html page, I am using below code to create and download excel file. I am creating this dynamic file with lot many formullas. let db = new alasql.Database('TEMPDB'); db.exec('create table tempexcel(A string,B string, c…
Jigar Parekh
  • 595
  • 10
  • 23
2
votes
1 answer

AliSQL result columns are different from SELECT clause

Working with large sets of data in Google Sheets with Apps Script is pretty difficult. I was hoping to be able to use AlaSQL to help--there's a really helpful port of it just for Apps Script. However, I'm getting some extremely unexepected results.…
Steven Elliott Johnson
  • 33
  • 3
2
votes
0 answers

How to query nested json using AlaSQL

I have the following json: values={ "1159":{"date":"2019-07-01T19:46:42.393Z","location":"southside","team_member_id":1159,"fullname":"Heather…
user3288051
  • 574
  • 1
  • 11
  • 28
2
votes
1 answer

Merge two or more cells into one in ALASQL

I'm trying to export excel using alasql in angularJS. Here I need to merge two or more cells into one what we do using colspan in HTML. Would be great if someone can help me with that. Thanks in advance.
Zuwaib Ansari
  • 29
  • 7
2
votes
0 answers

How to wraptext content using alasql in angularjs

I am using alasql to write the table data to a excel file. But I am not able to wrapText the content of the cell. There is a lot of space coming with value in the column and thus the value is not visible. The user has to manually open the excel and…
Tarun
  • 271
  • 1
  • 6
  • 18
2
votes
0 answers

create Json array and get some object under of this array uses alasql

how can I convert this Json…
Diego
  • 937
  • 8
  • 24
2
votes
2 answers

How to avoid redundant code in asynchronous javascript?

I'm rewriting some database code from synchronous (LocalStorage) to asynchronous (IndexedDB). I'm using the Alasql library and Promises. One of the problems I encounter is that when doing things asynchronously, sometimes it seems impossible to avoid…
Arne M
  • 87
  • 8
2
votes
1 answer

Alasql: Is there a maximum limit for the data size?

I try to load my xlsx file and it contains about 200,000 rows. When I use the code to load the file: alasql.promise('SELECT * FROM XLSX("' + fileUrl + '")') .then(function (res) {console.log(res)}); It only show 65535 records of the…
TimLee
  • 183
  • 1
  • 2
  • 11
2
votes
2 answers

Using Alasql can you replace null column with empty string

In my angular controller i have ExportToExcel function, which is using alasql to export data to Excel and the data is coming from angular array. The issue is the array might contains null as data, is it a way to replace null to empty string in…
user3754008
  • 275
  • 2
  • 12
1
2
3
…
14 15