HoneySQL
summary
HoneySQL represents SQL as Clojure maps so the backend constructs over a hundred queries on the fly for HubbleScope, which serves up to 30 graphs per request, each graph allowing up to 17 filters per line and up to 8 lines over as much as 15 years of data. Implementation uses honey.sql + clojure.java.jdbc against MySQL, automated join/column lookup to add filters, pmap to run queries, and emits Highcharts-ready JSON; it scales and worked in production.
AI-written summary · about
chapters (11)
- 0:00Start
- 0:40What is HoneySQL?
- 1:54Why HoneySQL?
- 4:18SEMANTICS
- 11:54Menu / Query Criteria Setup
- 13:1912 Generic Filters
- 13:30Category Specific Filters
- 13:45Before constructing query
- 15:12Business Logic
- 16:00Display name and/or value
- 28:13Hubble Scope Extensibility
related talks
27mPowerful Data Access in Clojure
40mGetting 50,000 Companies on Board with Clojure
59mHadoop Essentials for the SQL Server Professional
38mKeynote | Data Warehouse, Data Lakes, What's Next?
04mStartup Showcase: JethroData
48mHyper Speed! When Big Data Blooms
23mBuilding & Running a Scuba-Inspired Observability Tool
28mModernizing App Development: Planet-scale GraphQL & Distributed SQL