AlaSQL / 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.
http://alasql.org
MIT License
7.04k stars 659 forks source link

Visibility #236

Open agershun opened 9 years ago

agershun commented 9 years ago

We need to do something with visibility of the project. The serious KPI of interest to the project is number of links in Google search, and now it is about 27500 references So, only few people know about the project.

I don't think that it is acceptable to spam over whole Internet, but any articles, links, blogs, and tweets are very appreciated.

mathiasrw commented 9 years ago

Really good point. I have a feeling its good to focus on expanding the knowledte about the project when the documentation is easyer to digest.

agershun commented 9 years ago

The article of Dj Walker-Morgan in Compose.io "Meteor, SQL and other databases"

If we just want the familiarity of SQL querying, then AlaSQL could be what you are looking for. AlaSQL is a pure JavaScript database with an SQL front end to localStorage, IndexedDB and even Excel. One of its more recent enhancements is support for Meteor collections. This lets you turn...

    return Robots.find({}, { sort: { introduced: 1 }} );  

into

    return alasql('SELECT * FROM ? ORDER BY introduced',[Robots]);  

which doesn't look like a huge jump, until you realise that this works in both the browser and the server and opens up a way to do JOIN, GROUP BY, UNION, DISTINCT and others. AlaSQL is very much in development, but already comes with a useful Wiki of documentation. AlaSQL isn't just for Meteor; Meteor is just one of the things it supports along with CSV import, JSON data manipulation and a whole host of things useful to a data wrangler.

agershun commented 9 years ago

We also need: tutorials, videos...

mathiasrw commented 8 years ago

DAnish google gives 18.000 results.