Skip Site Navigation «

dbrowse

app«dbrowse
MySQL

Selected Data

This node is informative, descriptive, functional and terminating.
[definitions]

Query Path

Interactive Path

Description of Results

The MySQL tag table forms part of the drx application. As you can see, the table is utter simplicity, just an unsigned integer primary index tid, used to bind it to other tables, and the string value of each tag. For more information on the structure of the tag table, step back a node. Note that I have enhanced this view so that each string value below is a link to the drx index for that tag, and the third column lists a count of the total number of resources that are tagged with each keyword—which is exactly how the tag clouds are implemented.

Node/View

Table laz.tag,laz.tag_map: Selected data.
mysql> select tag.*,count(tag_map.rid) as count
mysql> from laz.tag,laz.tag_map
mysql> where tag.tid=tag_map.tid
mysql> group by tag.tag
mysql> order by tag.tag;
tid tag count
332 rows in set (0.0474 seconds)
39 accessibility 46
1379 acid 1
127 aggregator 14
89 ajax 30
1297 amazon 3
65 apache 56
1277 api 30
77 apple 45
1281 architecture 6
1391 archiving 4
1284 art 7
1354 astronomy 1
125 atom 18
1406 authentication 3
1451 aws 3
83 benchmark 2
60 blog 65
1447 blogroll 2
44 browser 90
58 bsd 21
1395 build 5
37 c 25
96 cache 13
1437 cachegrind 2
1418 cdn 5
1271 cern 5
1247 cgi 16
131 charset 16
1366 chat 2
1450 cheatsheet 7
1431 chrome 5
46 client 11
59 client-server 9
1440 cloud computing 2
103 cms 15
64 code 33
1329 commentary 4
1355 community 6
1392 compression 2
1269 computers 7
119 config 20
1358 cookies 2
78 copyright 1
1353 cpan 8
79 creative commons 4
1426 cron 1
11 css 105
1289 culture 7
87 darwin 11
1413 data 8
30 database 53
1394 debian 2
1320 debug 24
1305 del.icio.us 7
53 design 70
1382 desktop 2
8 developer 196
1374 dhtml 1
1283 digital 7
81 directory 30
1246 disability 3
1390 distribution 4
1254 distro 10
1303 dmoz 1
1274 dns 3
1266 docbook 4
1249 doctype 6
1385 documentation 7
76 dom 30
1442 dry 2
23 dublin core 10
116 ebook 15
75 ecmascript 1
1290 editors 21
1356 education 2
1388 emacs 1
1351 email 7
1380 embed 1
49 encoding 17
1404 encryption 8
1361 events 1
1258 extension 81
117 ezine 8
91 faq 18
1381 favelet 1
18 feed 36
1412 file 1
1407 filter 7
1444 firebug 5
43 firefox 111
93 flash 10
102 flickr 6
3 foaf 10
1295 folksonomy 9
132 fonts 4
29 format 3
105 forum 8
1309 framework 30
57 freebsd 20
1256 fsf 6
1282 gallery 3
1250 gecko 5
47 geourl 8
1410 gis 1
1433 git 6
1337 gmail 1
1252 gnu 15
1276 google 24
1286 graphics 13
1264 grddl 1
109 greasemonkey 6
134 gtd 1
1267 gui 14
120 gzip 6
1346 hardware 4
1332 help 2
114 history 51
1312 hosting 2
1253 howto 29
5 hreview 2
13 html 78
12 http 44
1400 https 5
1288 humor 2
1270 hypertext 4
1421 i18n 4
1259 ia 3
1340 ide 11
1324 ie 5
1397 injection 6
1280 innovators 37
98 install 16
1350 intel 1
35 internet 34
85 ipod 3
1372 irc 1
1335 jargon 1
113 java 15
74 javascript 98
1419 jquery 4
1359 json 7
1326 kernel 4
1311 keywords 2
1368 khtml 3
1287 languages 31
1427 latex 1
1347 layout 7
1443 library 11
1291 licenses 12
1425 linkrot 1
56 linux 44
1389 lisp 1
1316 lwp 3
40 mac 62
1318 magpie 4
1396 make 5
1331 manual 1
1357 maps 10
1341 marketing 6
16 markup 49
1362 mashup 1
1314 math 3
1285 mathml 2
1260 media types 9
25 metadata 15
1304 microformats 4
22 mime 8
1377 mobile 1
1449 moblog 1
122 module 37
88 mozilla 65
112 multimedia 5
1369 mvc 6
31 mysql 76
1319 netscape 11
1417 network 2
1306 news 32
1313 normalization 2
1293 nyc 1
1415 onlamp 8
1265 ontology 4
104 oop 27
27 open-source 145
42 opera 13
17 opml 19
1414 oreilly 10
1416 orm 1
133 os 17
1348 oscon 1
6 osx 63
1399 owasp 2
67 owl 4
1393 packaging 3
1279 pagerank 5
97 parsing 9
1338 patterns 3
1349 pcre 2
115 pdf 11
90 performance 63
36 perl 56
1452 pgp 3
4 php 167
26 pics 3
123 ping 6
1445 pingback 1
1330 platform 1
1448 plugin 3
1342 podcast 3
1255 portal 4
32 postgresql 17
1339 profiling 9
34 programming 157
1328 project management 4
1423 promotion 2
48 protocol 20
1411 proxy 1
33 python 55
1307 qa 1
95 query 4
2 rdf 43
108 reference 56
121 regex 7
107 repository 30
1310 resources 26
1296 rest 6
1308 reviews 6
1261 rfc 7
1398 ria 5
1360 ror 2
124 rpc 3
1 rss 89
1323 ruby 7
41 safari 27
1408 sanitize 1
1441 scalability 1
80 schema 6
1278 screenshots 3
1365 seamonkey 1
86 search 43
100 security 39
24 semantic web 14
129 semantics 15
28 seo 19
66 servers 24
1403 sftp 1
1248 sgml 2
1315 shell 6
111 skins 9
1317 skos 2
1275 soap 4
1434 social network 4
63 software 89
1352 spam 2
72 sparql 3
1257 spec 20
1429 spidermonkey 4
94 sql 16
1435 sqlite 3
1402 ssh 3
1273 ssl 6
38 standards 67
1327 stats 3
10 stylesheet 8
1344 survey 1
73 svg 3
1432 svn 8
110 swag 2
62 syndicate 2
82 sysadmin 27
1294 tagging 16
1336 taxonony 1
1272 tcp 4
1300 technology 8
1370 technorati 2
1428 template 14
1345 theme 3
1376 tidy 3
84 tiger 23
1268 timeline 9
1401 tls 5
1325 toolbar 6
1387 tools 33
1446 trackback 4
1386 tracking 5
1343 translation 1
1321 tts 2
1302 tutorial 32
1322 typography 2
1424 ubuntu 3
130 unicode 16
1384 unit testing 6
55 unix 28
1364 unobtrusive 1
1292 urban 1
50 uri 9
51 url 8
1251 urn 1
54 usability 16
45 user-agent 3
1299 user-interface 13
1422 utf8 3
1409 validate 4
126 validator 19
1383 version control 13
1333 vim 6
71 w3c 69
1378 wap 1
7 web 99
118 web server 25
101 web services 12
1363 web2.0 2
1367 webcore 5
1430 webkit 9
1420 widget 1
99 wiki 28
9 www 21
1334 xbl 4
1263 xfn 1
1436 xhr 3
14 xhtml 65
1262 xmdp 6
15 xml 111
20 xpath 14
19 xpointer 7
21 xquery 10
68 xsl 9
70 xsl-fo 6
69 xslt 24
1373 xss 4
1298 xul 13
1301 yahoo 16
1375 zend 6

Last updated: Friday, October 31st, 2008 @ 3:15 AM EDT [2008-10-31T07:15:33Z]   home

(c) 2008-2010, Douglas W. Clifton, loadaveragezero.com, all rights reserved.