<commit_before># AlaSQL.js - JavaScript SQL database library with support of localStorage, IndexedDB, and Excel

Version: 0.0.50 "Seoul" Date: April 22, 2015 [Change log](CHANGELOG.md), [Release plan](RELEASES.md)

[![Feature Requests](http://feathub.com/agershun/alasql?format=svg)](http://feathub.com/agershun/alasql)

AlaSQL - '[à la SQL](http://en.wiktionary.org/wiki/%C3%A0_la)' - 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.

AlaSQL is easy to use! Just add [alasql.min.js](alasql.min.js) file (about 280Kb) to your project and call 
```alasql()``` function with SQL statement inside: 

```html
    <script src="alasql.min.js"></script>  
    <script>
        alasql("CREATE TABLE cities (city string, population number)");
        alasql("INSERT INTO cities VALUES ('Rome',2863223), ('Paris',2249975),\
            ('Berlin',3517424), ('Madrid',3041579)");
        console.log( alasql("SELECT * FROM cities WHERE population < 3500000 ORDER BY population DESC") );
    </script>
```
Run this sample in [jsFiddle](http://jsfiddle.net/agershun/15r1y9hg/) or try it in <a href="http://alasql.org/console?CREATE TABLE cities (city string, population number);INSERT INTO cities VALUES ('Rome',2863223), ('Paris',2249975),('Berlin',3517424), ('Madrid',3041579);SELECT * FROM cities WHERE population < 3500000 ORDER BY population DESC">AlaSQL console</a>.

Please use:
* [AlaSQL Forum](https://groups.google.com/d/forum/alasql) for discussions
* [Issues](https://github.com/agershun/alasql/issues) to report bugs.
* [Feathub](http://feathub.com/agershun/alasql) for voting for new features
<commit_msg>Features<commit_after># AlaSQL.js - JavaScript SQL database library with support of localStorage, IndexedDB, and Excel

Version: 0.0.50 "Seoul" Date: April 22, 2015 [Change log](CHANGELOG.md), [Release plan](RELEASES.md)

AlaSQL - '[à la SQL](http://en.wiktionary.org/wiki/%C3%A0_la)' - 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.

AlaSQL is easy to use! Just add [alasql.min.js](alasql.min.js) file (about 280Kb) to your project and call 
```alasql()``` function with SQL statement inside: 

```html
    <script src="alasql.min.js"></script>  
    <script>
        alasql("CREATE TABLE cities (city string, population number)");
        alasql("INSERT INTO cities VALUES ('Rome',2863223), ('Paris',2249975),\
            ('Berlin',3517424), ('Madrid',3041579)");
        console.log( alasql("SELECT * FROM cities WHERE population < 3500000 ORDER BY population DESC") );
    </script>
```
Run this sample in [jsFiddle](http://jsfiddle.net/agershun/15r1y9hg/) or try it in <a href="http://alasql.org/console?CREATE TABLE cities (city string, population number);INSERT INTO cities VALUES ('Rome',2863223), ('Paris',2249975),('Berlin',3517424), ('Madrid',3041579);SELECT * FROM cities WHERE population < 3500000 ORDER BY population DESC">AlaSQL console</a>.

Please use:
* [AlaSQL Forum](https://groups.google.com/d/forum/alasql) for discussions
* [Issues](https://github.com/agershun/alasql/issues) to report bugs.
* [Feathub](http://feathub.com/agershun/alasql) Please, vote for new features

{'fraction_non_alphanumeric': 0.1382228490832158, 'fraction_numerical': 0.05021156558533145, 'mean_word_length': 4.7752442996742674, 'pattern_counts': {'":': 0, '<': 19, '<?xml version=': 0, '>': 15, 'https://': 4, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3762403', 'n_tokens_mistral': 1259, 'n_tokens_neox': 1103, 'n_words': 344}