Evidence

Introducing Evidence Studio Launching an AI-powered Web IDE for Evidence: the next generation of BI-as-code, built for scale, speed, and teams.

Today we are launching Evidence Studio - an AI-powered development, publishing, and governance platform for analytics
evidence.dev/blog/evidenc...

all BI charts end up looking the same, but why?

it's because we're normally doing the same thing - discrete dimension on X axis, continuous measure on Y

evidence.dev/blog/discret...

run query-> get chart, using @duckdb-gsheets.com

@duckdb-gsheets.com v0.0.5 is now live!

big news with this version is now you can force duckdb to read EVERYTHING as a string with the all_varchar flag

we also welcomed a new contributor to the project in this release - props to Michael Harris for all the new features!

It runs without an LSP!

What Is a Flat File? The ultimate guide to flat files, their use cases, format specifics, and how they stack up against non-flat file databases and relational DBMSs

sometimes you get really deep into something very niche

i'm always using CSVs + json to store little bits of data, but never considered why these formats (a large part is portability!)

Alex and I put together this guide about when to use flat files, and when not to

evidence.dev/blog/what-is...

We've overhauled our VS Code autocomplete system to include:
- Autocomplete for component props
- Inline prop documentation
- Option selection for props that have finite options
- Query name suggestions within any data prop
- Better table suggestions in SQL, including CTEs and chained queries

Evidence components now let you include helpful info tooltips to give your users extra context in the right places

Line Chart Display how one or more metrics over time. Line charts are suitable for plotting a large number of data points on the same chart.

i tried to write useful descriptions about when you should choose each chart type in the @evidence.dev library

docs.evidence.dev/components/charts/line-chart

Evidence is a superset of markdown

Awesome color scheme 💅

Small web app showing North Carolina men's basketball metrics in NET and Wins-Above-Baseline

Small web app showing North Carolina men's basketball game results by Wins-Above-Baseline

Added updates to @evidence.dev app to surface more men's college hoops data

Trends using Torvik's Game Score, NET rankings by percentiles, and team details page to show metrics

byc.evidence.app/college-bask...

just shipped - you can now query APIs from @evidence.dev sources

I used this to make this cool app using US housing index data from fhfa.gov in 80 mins and <100 lines of markdown

The Most Popular Code-based Business Intelligence Tools, Reviewed Comparing the most popular BI-as-code tools: Evidence, Streamlit, Dash, Observable, Shiny and Quarto

A guest contributor published this on the issue.

In short:
- If code already in python, Streamlit will probably be quicker to start
- But every change causes a full script re-run, so the reactivity is slow
- And you don't have much control over styling

evidence.dev/blog/busines...

playing around with an AgGrid component for @evidence.dev

related evidence-web-ide.vercel.app

Fun fact, if you edit the frontmatter for your index.md, you can change the preview card shown on bluesky (and elsewhere on the web)

---
title: Parking Garage
description: Current occupancy of parking garages in various cities in Europe
---

Great, the API from parkendd.de is available as #OpenData. This is finally a good use case for trying out @evidence.dev. Here you can see the current occupancy of parking garages in various cities in Europe:
parkinggarage.evidence.app

#DataBS

Evidence: Open Source Alternative to Retool, Airplane and Tableau – OpenAlternative Create data-driven websites and reports using SQL and Markdown, with automatic visualizations and interactive elements.

Evidence — Transform SQL into beautiful data stories

⭐ Stars: 4,678
🔗 Forks: 222
⏩ Last commit: 2 hours ago
⌛ First commit: 4 years ago

https://openalternative.co/evidence

We're excited to publicly share the Evidence Roadmap!

- Custom Themes & Dark Mode (Shipped!)
- Pivot Table & SQL Console
- Cross Filters & Sharable Links
- Prop Autocomplete
- Deploy Previews & Email Notifications
- Multi Tenant Config & RLS
- UI Revamp & Scheduled Emails
- EU region for Cloud

Has anyone tried to create an LLM agent that generates @evidence.dev apps/pages, given data sources and instructions/queries?

@davidgasquez.com has a repo where all the Evidence docs are stored in a single text file for step 1

github.com/davidgasquez...

@zachrenwick-data.bsky.social's resume is on @evidence.dev 🤯

zachrenwick.work

You found the easter egg

We think so too!

Also means you can make it very much “your own work”

Right click on @evidence.dev logo - beautiful stuff:

I just updated the #DuckDB extension visualization site to also include regular DuckDB extensions like Spatial and HTTPFS. Did you know there were nearly 6M extension downloads last week alone? 🚀

Check it out: duckdb-ce-analysis.evidence.app
Feedback is always welcome!
Made using @evidence.dev

A day in the office working on my #reporting app.

@evidence.dev #data #bi-as-code #bi #dataviz

dark mode on @evidence.dev! lets go!!

Themes & Dark Mode Launching a theming system for Evidence, including dark mode - giving you the power to create publication-quality outputs that perfectly match your brand

Themes and dark mode have arrived in Evidence.

Design incredible-looking data products with just a few lines of config.

evidence.dev/blog/themes/