Javascript (sql or nosql or JSON) client side not HTML5 database libraries?

Question

We are developing a Javascript based UI(browser based) that needs some data selection (filtering, sorting, grouping in different levels)I just want to ask about probable Javascript (sql or nosql/JSON) client side (not HTML5) database libraries, also a performance comparison would be really helpful.

Thanks.

score 1 · Answer 1 · edited May 23 '17 at 10:29

1

similar question at https://stackoverflow.com/a/4778046/942855

Support level in browsers: http://en.wikipedia.org/wiki/Comparison_of_layout_engines_(HTML5)#Related_specifications

NO HTML5

edited May 23 '17 at 10:29

Community

1
1

answered May 08 '13 at 19:27

HaBo

13,999
36
114
206

thank you but in the question I asked for **NOT HTML5** solutions I mean pure javascript solution not browser storage – Mojtaba May 10 '13 at 09:14

score 0 · Answer 2 · answered Dec 15 '14 at 20:01

You can try Alasql JavaScript SQL library. It doest not use IndexedDB and WebSQL (i.e. HTML5 databases), but work in memory. It is relatively fast, because Alasql compiles queries to JavaScript code (see some tests at Github).

Here is the simple sample:

<script src="alasql.min.js"></script>
<script>
   var cities = [{city:'Kyiv',country:'Ukraine'}, {city:'Odessa', country:'Ukraine'}, 
                 {city:'Vienna', country:'Austria'}];
   var res = alasql('SELECT country, COUNT(*) AS cnt FROM ? \
                       GROUP BY country ORDER BY cnt',[cities]);
   console.log(res);
</script>

You can play with this example at jsFiddle.

Javascript (sql or nosql or JSON) client side not HTML5 database libraries?

2 Answers2