dbrowse

√app«dbrowse

Selected Data

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

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]

projects

PHP Labs

CSS Labs

brainpan

info

dbrowse

Selected Data

Query Path

Interactive Path

Description of Results

Node/View