Building a SQL editor around “fast”
summary
Rill Data pivots from Druid to DuckDB and builds a SQL IDE that leverages sub-second query latency to remove the no run button — results start appearing as users type — and adds an auto profiler that streams column summaries and distributions back via DuckDB queries. Profiling runs dozens of tiny queries in parallel, uses approximations, virtualization and aggressive caching to keep UI updates in the hundreds of milliseconds, and is shipping in Real Developer as an interactive editor with result panes and expandable column profiles.
AI-written summary · about
related talks
19mIn-Process Analytical Data Management with DuckDB
15mGet Your Ducks in a Row with Databases
34mData Wrangling with DuckDB
40mDuckDB: Harnessing in-process analytics for data science and beyond
27mIn Process Analytical Data Management with DuckDB
47mPlay Data Engineer Locally with DuckDB
30mDuckDB: Bringing analytical SQL directly to your Python shell
25mA quack of all trades: DuckDB, a versatile analytical database to keep in your toolkit