A new paradigm for data visualization with just SQL + Markdown

Come to this Quack&Code where Mehdi will discuss data visualization with DuckDB/MotherDuck, specifically focusing on Evidence! Archie, who is building evidence.dev, will join us to share his wisdom on charts ;-) ☁️🦆 Start using DuckDB in the Cloud for FREE with MotherDuck : https://hubs.la/Q02QnFR40 Check evidence : https://evidence.dev/ PyPi DuckDB stats projects : https://duckdbstats.com/ #duckdb #dashboard -------------------------------------- Explore Evidence.dev, a powerful open-source framework transforming business intelligence with a "BI as code" approach. This modern alternative to traditional BI tools allows developers and analysts to build highly custom data apps using only Markdown and SQL. By treating your dashboards as code, you unlock a robust software engineering workflow, including version control with Git, automated CI/CD pipelines, and reliable testing. This eliminates the maintenance nightmare of manually updating dozens of drag-and-drop dashboards, enabling a more robust and enjoyable local development experience for creating data visualizations. Go beyond generic dashboards and embrace true data storytelling. A key advantage of Evidence.dev is its deep customization, allowing you to create unique data web apps. Unlike standard BI tools where context is lost in separate documents, Evidence lets you inline commentary, definitions, and narratives directly alongside your charts. This creates a cohesive story that makes complex data understandable for any stakeholder. The framework provides beautifully designed, ready-to-use components that can be easily modified, striking the perfect balance between rapid development and granular control over your data visualizations. Discover how Evidence leverages DuckDB for exceptional performance. The framework uses DuckDB in two key ways: as a high-performance data source connector for local files like Parquet or CSVs, and more importantly, as an in-browser query engine powered by DuckDB WASM. This WebAssembly implementation runs a full SQL database inside the user's browser, enabling lightning-fast client-side filtering and data joins across multiple sources without any server round-trip. This architecture is what makes Evidence data apps feel incredibly responsive and interactive. The developer workflow in Evidence is designed for speed and reliability. After developing your data app locally with instant feedback, you run a build process that compiles your project into a static website. This static output can be deployed effortlessly to any serverless platform like Vercel, Netlify, or Evidence Cloud. Data freshness is managed through scheduled rebuilds, and the framework is perfect for operational analytics, allowing you to embed reports directly into your SaaS applications using iframes for a seamless user experience. See this entire data engineering stack in action with DuckDBstats.com, a real-world project built using Evidence and MotherDuck. This dashboard visualizes PyPI download stats for DuckDB, with MotherDuck serving as the serverless cloud data warehouse. A standout feature is MotherDuck's secure data sharing, which allows any user to directly query the raw data behind the dashboard using their own DuckDB client. This combination of MotherDuck and Evidence creates a powerful, transparent, and end-to-end solution for modern data analytics. Watch with full transcript & resources: https://motherduck.com/videos/a-new-paradigm-for-data-visualization-with-just-sql-markdown/