mathiasrw

View on GitHub

Projects

Name Description Features Votes
agershun/alasql 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. 40 166

Features suggested

Project Feature Score Description
agershun/alasql Documentation quality 40 Restructuring the documentation for AlaSQL so there is an overall philosophy on how to find information, examples and what is (not) supported. I am very inspired of how Ractive (http://docs.ractivejs.org/latest/get-started) does the documentation
agershun/alasql Add \t and similar characters to strings 2
agershun/alasql Implement binary operators <<, >>, &, ^, | 2 Implement binary operators <<, >>, &, ^, |
agershun/alasql MySQL connection backend for Meteor 11 Being able to connect to MySQL directly from Meteor (or node) would make the use more broard Lets be the glue...
agershun/alasql Implement WITH RECURSIVE 4 https://twitter.com/rpy/status/622291301002670080/photo/1
agershun/alasql Range types from Postgresql 2 As described in https://github.com/agershun/alasql/issues/55
agershun/alasql MSSQL connection backend for node and Meteor 3 Use AlaSQL to connect to MSSQL Example: ```js alasql('ATTACH MSSQL DATABASE one; SELECT * FROM one.tableid'); ```
agershun/alasql JOIN'ed source for UPDATE statement 3 Example: ```sql UPDATE odoc SET osmlineid = s.osmlineid FROM odoc o INNER JOIN osmline s ON o.uniqueid = s.uniqueid; ```
agershun/alasql Add FORMAT function 2 A combination of these functions * T-SQL [FORMAT()](https://msdn.microsoft.com/ru-ru/library/hh213505.aspx?f=255&MSPPError=-2147217396) * MySQL [FORMAT()](http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_format) Plus there are some other [Oracle](http://docs.oracle.com/cd/B10500_01/server.920/a96540/sql_elements4a.htm) and [Postres](http://www.postgresql.org/docs/8.3/static/functions-formatting.html) formatting functions.
agershun/alasql SQL dump from AlaSQL 9 Would be good to export data from AlaSQL to a pure SQL string. Could be done by a `INTO SQL()` approach. ```js var data = [{id:1}]; var sql = alasql('SELECT * INTO SQL({tableid:'one'}) FROM ?',[data]); // sql = 'INSERT INTO one (id) VALUES (1);'); ``` where the config argument to `SQL()` could have a flag to include table structure. A more SQL'ish solution would be a) to have dump command for specific database, like: ```js var sql = alasql('DUMP DATABASE mybase'); ``` b) dump all databases in current ```alasql``` object: ```js var sql = alasql('DUMP'); ```
agershun/alasql Make sure that 0.1 + 0.2 == 0.3 0 In the moment the default backend of AlaSQL has same "funny" math issues as Javascript alasql 'select 0.2 + 0.1 == 0.3' [ { '0.2 + 0.1 == 0.3': false } ] Could be interesting to look into if / how mathjs could be used to compare and calculate data. http://mathjs.org/docs/datatypes/numbers.html
agershun/alasql more closely integrationwith Angular.js. -1 _From [#146](https://github.com/agershun/alasql/issues/146)_ I am thinking about more closely integration AlaSQL with Angular.js. What kind of directive it can be? Possible candidates: - advanced filter - XLSX/CSV import/export functionality - SQL service (like https://github.com/paulocaldeira17/angular-websql)
agershun/alasql JSON parser: expressions 2 https://github.com/agershun/alasql/issues/165 Currently AlaSQL parser requires brackets around expressions in JSON objects, like: ```sql SELECT {name:(age+1),qty:5} FROM ? ``` These brackets are useless: ```sql SELECT {name:age+1,qty:5} FROM ? ``` Also negative numbers are seen as expressions, so at the moment you can only `{val:(-1)}`
agershun/alasql Add TIMES selector for SEARCH operator 1 https://github.com/agershun/alasql/issues/203
agershun/alasql Support ON CONFLICT 1
agershun/alasql Add BACKUP and RESTORE statements 1
agershun/alasql FILTER notation for aggregate functions 2 The filter clause follows an aggregate function: SUM(<expression>) FILTER(WHERE <condition>) With the exception of subqueries and window functions, the <condition> may contain any expression that is allowed in regular where clauses0. http://modern-sql.com/feature/filter
agershun/alasql Show table gives data on nondefined columns 1 See https://github.com/agershun/alasql/issues/714
agershun/alasql Suppoer `UPDATE ?` 5 Let UPDATE, INSERT and DELETE work on data passed in parameter. More informationer in https://github.com/agershun/alasql/issues/348

Comments

Project Feature Comment When
agershun/alasql Better support for Cordova/Mobile apps Observer features have been implemented via trigger function. Can you put more words to "reactive views" ? over 3 years ago
agershun/alasql Error callback for asyncronous operations What about the promise notation - does this help you out? ``` alasql.promise('SELECT * FROM XLS("mydata.xls") WHERE lastname LIKE "A%" and city = "London" GROUP BY name ') .then(function(res){ console.log(res); // output depends on mydata.xls }).catch(function(err){ console.log('Does the file exists? there was an error:', err); }); ``` over 3 years ago
agershun/alasql Make sure that 0.1 + 0.2 == 0.3 Now works for node v0.12.2 almost 4 years ago
agershun/alasql Make sure that 0.1 + 0.2 == 0.3 almost 4 years ago

Votes

Vote When Project Feature
over 3 years ago agershun/alasql TRANSACTION support
over 3 years ago agershun/alasql FILTER notation for aggregate functions
over 3 years ago agershun/alasql Add BACKUP and RESTORE statements
over 3 years ago agershun/alasql Support ON CONFLICT
over 3 years ago agershun/alasql JSON parser: expressions
over 3 years ago agershun/alasql Better support for Cordova/Mobile apps
about 4 years ago agershun/alasql Implement WITH RECURSIVE
about 4 years ago agershun/alasql Add \t and similar characters to strings
about 4 years ago agershun/alasql SQL dump from AlaSQL
over 4 years ago agershun/alasql MySQL connection backend for Meteor
over 4 years ago agershun/alasql Documentation quality