forked from spullara/yql-tables
-
Notifications
You must be signed in to change notification settings - Fork 1
/
index.html
146 lines (139 loc) · 5.74 KB
/
index.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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-us" lang="en-us">
<head>
<title>YQL - Community Open Data Tables</title>
<style>
html {
height:100%;
min-height:100%;
width:100%;
}
body {
font-family:arial,helvetica,clean,sans-serif;
font-size:13px;
font-size-adjust:none;
font-style:normal;
font-variant:normal;
font-weight:normal;
color:#222;
}
h1 {
color:#008DC7;
margin:12px 0 4px 0;
font-size:300%;
}
h2 {
margin:12px 0 4px 0;
}
a {
color:#2288BB;
text-decoration:none;
}
a:hover {
text-decoration:underline;
}
.nav a {
font-weight:bold;
}
.nav {
display:block;
width:100%;
text-align:center;
margin:4px 0 40px 0;
}
.nav ul {
display:block;
}
.nav li {
color:#222;
display:block;
float:left;
padding-left:8px;
}
.nav a {
padding-right:8px;
}
.nav.header {
padding-bottom:20px;
border-bottom:1px solid #eee;
clear:both;
}
.nav.footer {
border-top:1px solid #eee;
clear:both;
}
.banner {
display:block;
}
.banner img {
vertical-align:middle;
}
.banner h1 {
display:inline;
}
h2 {
clear:both;
}
code, pre {
color:#008040;
}
h2 b {
text-decoration:underline;
}
</style>
</head>
<body>
<div class='nav header'>
<ul>
<li><a href="http://developer.yahoo.com/yql">YQL</a>|</li>
<li><a href="http://yqlblog.net">YQL Blog</a>|</li>
<li><a href="http://developer.yahoo.com/yql/console/?env=http://datatables.org/alltables.env">YQL console + open data tables</a>|</li>
<li><a href="http://developer.yahoo.com/yql/console">YQL console (built-in tables only)</a>|</li>
<li><a href="http://github.com/spullara/yql-tables/tree/master">github Open Data Tables</a>|</li>
<li><a href="http://developer.yahoo.net/forum/index.php?showforum=41">YQL forum</a></li>
</ul>
</div>
<div class="banner">
<img src="http://l.yimg.com/a/i/us/pps/yql128.gif" />
<h1>Community Open Data Tables for YQL</h1>
</div>
<h2>What's <a href="http://developer.yahoo.com/yql">YQL</a>? <code>select * from internet</code></h2>
The Yahoo! Query Language (YQL) platform enables developers to query, filter, and combine data across the web. YQL exposes a SQL-like syntax that is both familiar to developers and expressive enough for getting the right data. YQL supports three SQL-like verbs:
<ul>
<li><code>SELECT</code> for fetching, combining, filtering and projecting data.</li>
<li><code>DESC</code> for describing the input fields for a table and other meta information.</li>
<li><code>SHOW</code> for getting a list of the tables/data sources supported by the language/platform.</li>
</ul>
The SELECT statement is the primary verb for YQL:
<pre>
SELECT what FROM table WHERE filter
</pre>
In addition, YQL also supports several post-query functions like sort and unique.
<h2>What are <a href="http://developer.yahoo.com/yql/guide/yql-opentables-chapter.html">open data tables</a>?</h2>
Open Data Tables are XML files that can be "plugged" into the <a href="http://developer.yahoo.com/yql/">Yahoo! Query Language open platform (YQL)</a>. These files describe how the YQL SQL-like language can be mapped onto any web service or source on internet. Once mapped, these data sources can be used by developers in many ways in YQL.
<h2>What are <b>community</b> open data tables?</h2>
While anyone can develop and share an open data table for YQL, we are encouraging the community of open data table developers to contribute their tables to the open data tables <a href="http://github.com/spullara/yql-tables/tree/master">github</a> project. This makes tables much easier to find and share, and try out in the YQL console.
<h2>Why isn't this site on github?</h2>
While github is a great source control site, it's not intended to serve content quickly. datatables.org keeps a copy of the github master tree and automatically creates a single "env" file. Environment files enable the YQL console and web service to load up many open data tables from a single URL.
<h2>How can I <a href="http://developer.yahoo.com/yql/console/?env=http://datatables.org/alltables.env">try</a> a table in the console?</h2>
You can import <b>all</b> the current open data tables <a href="http://developer.yahoo.com/yql/console/?env=http://datatables.org/alltables.env">in the console</a>. This uses the <a href="http://datatables.org/alltables.env">environment file</a> hosted here. If you want a single one try the <code>use</code> verb. Read about that <a href="http://developer.yahoo.com/yql/guide/yql-opentables-import.html">here</a>.
<h2>How can I build my own tables?</h2>
A quick read of the <a href="http://developer.yahoo.com/yql/guide/">YQL guide</a> is a great starting point, in particular:
<ul>
<li><a href="http://developer.yahoo.com/yql/guide/yql-opentables-chapter.html">Open Data tables</a></li>
<li>Running your own code with <a href="http://developer.yahoo.com/yql/guide/yql-execute-chapter.html">Execute</a> in Open Data Tables</li>
</ul>
One the other easy way of working out how to do something is to <a href="http://github.com/spullara/yql-tables/tree/master">look at someone else's open data table</a> that wraps a data source similar to what you want to enable.
<br/>
<div class="nav footer">
<ul>
<li><a href="http://developer.yahoo.com/yql">YQL</a>|</li>
<li><a href="http://yqlblog.net">YQL Blog</a>|</li>
<li><a href="http://developer.yahoo.com/yql/console/?env=http://datatables.org/alltables.env">YQL console + open data tables</a>|</li>
<li><a href="http://developer.yahoo.com/yql/console">YQL console (built-in tables only)</a>|</li>
<li><a href="http://github.com/spullara/yql-tables/tree/master">github Open Data Tables</a>|</li>
<li><a href="http://developer.yahoo.net/forum/index.php?showforum=41">YQL forum</a></li>
</ul>
</div>
</body>
</html>