<commit_before>SQL API for cartodb.com
========================
 
Provides a nodejs based API for running SQL queries against CartoDB.

* Users are authenticated over OAuth. Also provides ability to make public
  "SELECT" only calls.
* OAuth requests to this API should always be made over SSL.


core requirements
-------------
* postgres
* redis
* node >v0.4.8 && < 0.7.0>
* npm

usage
-----

Edit config/environments/<environment>.js
Make sure redis is running and knows about active cartodb user.

``` bash
node [cluster.js|app.js] <environment>
```

Supported <environment> values are developement, test, production

for examples of use, see /tests


Install dependencies
---------------------

```bash
npm install
```


tests
------
see test/README.md<commit_msg>notes on node 0.4<commit_after>SQL API for cartodb.com
========================
 
Provides a nodejs based API for running SQL queries against CartoDB.

* Users are authenticated over OAuth. Also provides ability to make public
  "SELECT" only calls.
* OAuth requests to this API should always be made over SSL.


core requirements
-------------
* postgres
* redis
* node >v0.4.8 && < 0.7.0>
* npm

usage
-----

Edit config/environments/<environment>.js
Make sure redis is running and knows about active cartodb user.

``` bash
node [cluster.js|app.js] <environment>
```

Supported <environment> values are developement, test, production

for examples of use, see /tests


Install dependencies
---------------------

```bash
npm install
```


tests
------
see test/README.md


note on 0.4.x
--------------
output of large result sets is slow under node 0.4. Recommend running under 0.6 where possible.
{'fraction_non_alphanumeric': 0.16476932294787297, 'fraction_numerical': 0.011983223487118035, 'mean_word_length': 3.0632603406326036, 'pattern_counts': {'":': 0, '<': 11, '<?xml version=': 0, '>': 13, 'https://': 0, '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': '3537169', 'n_tokens_mistral': 509, 'n_tokens_neox': 467, 'n_words': 195}