HTSQL Gallery¶
About Our Gallery¶
HTSQL is a query language and instant API for databases. HTRAF is a web toolkit for HTSQL that lets you build web applications in minutes. We have several data sets on which we demonstrate HTSQL queries and HTRAF dashboards.
EDGAR Database¶
EDGAR is the SEC’s database of public company filings. We feature executive compensation data from 2008. For a description of the EDGAR data set and example queries, see EDGAR Gallery. There is also an EDGAR : 2008 Executive Compensation dashboard.
DonorsChoose.org¶
Donors Choose is a great organization that matches donors with classrooms in need. They’re sponsoring the Hacking Education contest (through June 30, 2011) to encourage app developers to find helpful new ways to use their project database.
The DonorsChoose Gallery explains their database schema and has several example queries. We have written three demonstration dashboards:
Snort Intrusion Detection System¶
Snort is a free, lightweight intrusion detection system developed by Sourcefire. This demo shows how easy it is to read and visualize network logs stored in the Snort database.
The Snort Gallery shows how to generate reports from a Snort database. We have written two sample dashboards:
HTSQL Sample Database¶
This database demonstrates how one could use HTSQL to access a fictitious university course catalog and student enrollment system. For a few sample queries, see HTSQL Sample Database Gallery. There is also an HTSQL Sample Database : Courses by Department dashboard.