-
Notifications
You must be signed in to change notification settings - Fork 3
/
index1.html
90 lines (68 loc) · 4.52 KB
/
index1.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8'>
<meta http-equiv="X-UA-Compatible" content="chrome=1">
<meta name="description" content="Alasql : Alasql.js - pure JavaScript fast client-side SQL database">
<link rel="stylesheet" type="text/css" media="screen" href="stylesheets/stylesheet.css">
<title>Alasql</title>
</head>
<body>
<!-- Yandex.Metrika counter --><script type="text/javascript"> (function (d, w, c) { (w[c] = w[c] || []).push(function() { try { w.yaCounter27446052 = new Ya.Metrika({ id:27446052 }); } catch(e) { } }); var n = d.getElementsByTagName("script")[0], s = d.createElement("script"), f = function () { n.parentNode.insertBefore(s, n); }; s.type = "text/javascript"; s.async = true; s.src = (d.location.protocol == "https:" ? "https:" : "http:") + "//mc.yandex.ru/metrika/watch.js"; if (w.opera == "[object Opera]") { d.addEventListener("DOMContentLoaded", f, false); } else { f(); } })(document, window, "yandex_metrika_callbacks");</script><noscript><div><img src="//mc.yandex.ru/watch/27446052" style="position:absolute; left:-9999px;" alt="" /></div></noscript><!-- /Yandex.Metrika counter -->
<!-- HEADER -->
<div id="header_wrap" class="outer">
<header class="inner">
<a id="forkme_banner" href="https://github.com/agershun/alasql">View on GitHub</a>
<h1 id="project_title">Alasql</h1>
<h2 id="project_tagline">Alasql.js - pure JavaScript fast client-side SQL database</h2>
<section id="downloads">
<a class="zip_download_link" href="https://github.com/agershun/alasql/zipball/master">Download this project as a .zip file</a>
<a class="tar_download_link" href="https://github.com/agershun/alasql/tarball/master">Download this project as a tar.gz file</a>
</section>
</header>
</div>
<!-- MAIN CONTENT -->
<div id="main_content_wrap" class="outer">
<section id="main_content" class="inner">
<!--
<h1>
<a id="alasqljs---pure-javascript-client-side-in-memory-fast-sql-database" class="anchor" href="#alasqljs---pure-javascript-client-side-in-memory-fast-sql-database" aria-hidden="true"><span class="octicon octicon-link"></span></a>Alasql.js - pure JavaScript client-side in-memory fast SQL-database</h1>
-->
<p>Try Alasql in <a href='/console'>console</a>!</p>
<p>Alasql - '<a href="http://en.wiktionary.org/wiki/%C3%A0_la">à la SQL</a>' - is a lightweight client-side in-memory SQL database designed to work in browser and Node.js. </p>
<ul>
<li>Alasql was written with pure JavaScript and does not use browser WebSQL database. </li>
<li>Alasql is fully functional compact sql server with JOINs, GROUPs, UNIONs, ANY, ALL, IN, subqueries and very limited transactions support.</li>
<li>Alasql supports ROLLUP(), CUBE() and GROUPING SETS() functions</li>
<li>Alasql works with all modern versions of browsers (Chrome, Firefox, IE, Safari), Node.js, and mobile iOS and Android.</li>
<li>Alasql is fast, because it uses some optimization methods.</li>
</ul>
<h3>It is easy to use</h3>
<pre><code> <script src="alasql.js"></script>
<script>
alasql("CREATE TABLE test (language INT, hello STRING)");
alasql("INSERT INTO test VALUES (1,'Hello!')");
alasql("INSERT INTO test VALUES (2,'Aloha!')");
alasql("INSERT INTO test VALUES (3,'Bonjour!')");
console.log( alasql("SELECT * FROM test WHERE language > 1") );
</script>
</code></pre>
<p>Check Alasql vs other JavaScript databases: </p>
<ul>
<li><a href="http://jsperf.com/alasql-js-vs-websql">Alabase vs. WebSQL</a></li>
<li><a href="http://jsperf.com/sql-js-vs-alasql-js/4">Alabase vs. SQL.js</a></li>
</ul>
<p>View Alasql documentation on <a href='https://github.com/agershun/alasql'>GitHub</a>!</p>
<a class="twitter-timeline" href="https://twitter.com/search?q=alasql" data-widget-id="543028507367202816">Tweets about alasql</a>
<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+"://platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>
</section>
</div>
<!-- FOOTER -->
<div id="footer_wrap" class="outer">
<footer class="inner">
<p class="copyright">(c) 2014, <a href="https://github.com/agershun">Andrey Gershun</a>, MIT licence </p>
<!-- <p class="copyright">Alasql maintained by <a href="https://github.com/agershun">agershun</a></p> -->
</footer>
</div>
</body>
</html>