Today Evidence Studio brings you... Custom color palettes for all your charts! docs.evidence.studio/changelog#au...
archie.md
@archie.sarrewood.com
SQL, data viz, duckdb, markdown building @evidence.dev archie.evidence.app
next week @matsonj.com and @mehdio.com and I are talking practical workflows for using LLMs in data roles Wednesday, April 9 / 12:30 PM EDT sign up 👇 lu.ma/gmsg4lcl
Practical Uses for AI in Your Data Workflows · Zoom · Luma
Join us for a live discussion where professionals from across the data landscape share how they're using AI in their everyday work. In this practical session,…
lu.ma
what a beautiful day to be sat inside debugging github actions
an awesome write up of the @duckdb-gsheets.com extension
New blog post by @a13x.bsky.social and @archie.sarrewood.com: Reading and Writing Google Sheets in DuckDB This post introduces the gsheets community extension, which enables DuckDB to directly read from and write to Google Sheets. duckdb.org/2025/02/26/g...
@a13x.bsky.social ripping some cool forecasting workflows with @duckdb-gsheets.com
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...
working on improving the login experience for @duckdb-gsheets.com no more pasting tokens into the terminal
some musings on continuous vs discrete data - basically all dimensions are discrete, except time - basically all measures are continuous, except counts
We are happy to announce DuckDB v1.2.0 “Histrionicus”! The new release has several usability, security and performance improvements. It has new features for the CSV and Parquet formats, as well new (opt-in) options for DuckDB's own format. Read more at duckdb.org/2025/02/05/a...
I'm working on something new: Self-hosted web analytics on AWS. Powered by serverless AWS services, and @duckdb.org in the frontend & backend. If you want to catch a first glimpse of how the UI feels like: ownstats.com/preview
OwnStats - Self-hosted web analytics on AWS
ownstats.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!
@duckdb-gsheets.com is starting to get a lot of downloads credit for chart @dtenwolde.bsky.social duckdb-ce-analysis.evidence.app
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...
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
evidence.dev
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
who made this and can you update it pls gasandeggs.evidence.app
Gas And Egg Prices
gasandeggs.evidence.app
Evidence now has a specific guide for connecting to every data source we support docs.evidence.dev/core-concept...
Snowflake
Connect Evidence to Snowflake
docs.evidence.dev
was interested to see if I could extend this to create a deterministic way to choose a chart based on your data: - how many dimensions? - discrete or continuous? - how many values? etc this is my first attempt - what did i get wrong here?
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
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
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.
docs.evidence.dev
having dinner with a friend: “so @evidence.dev just extends markdown to run SQL?” about to tell him this is over simplistic… …realise simpler is better, so just reply: “yeah” friend: “smart” stealing this as my new elevator pitch
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
proud of myself for tracking down a gnarly bug by learning `git log --online --graph` it's not often that the github UI fails me, but if you are looking for a bug in a large feature branch, then its chronological commit view can't help you (and wont show >250 commits in a PR)
linkedin seriously feels like it’s serving me someone else’s feed 10 notifications in a row about comments by a single connection on posts by people i’ve never met in under an hour
we've added subsections to the Evidence docs site to make it easier to find the components you need Also every page now has a nice social card docs.evidence.dev/components/c...
Bar Chart
Compare a metric across a small number of categories.
docs.evidence.dev
what’s this tiny text in the right corner of each post on the discover feed? how do i use it? when i click it it copies to clipboard but then?
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
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.
openalternative.co
just published @duckdb-gsheets.com v0.0.4 github.com/evidence-dev... thanks as always to the immortal @a13x.bsky.social
GitHub - evidence-dev/duckdb_gsheets at v0.0.4
DuckDB extension to read and write Google Sheets using SQL - GitHub - evidence-dev/duckdb_gsheets at v0.0.4
github.com
not one american I asked in the last week knew that “die hard” is german for “the tower” they literally thought it was english like are you kidding me? the bad guy is called hans gruber and it’s set in a tower block