Profile avatar
archie.sarrewood.com
SQL, data viz, duckdb, markdown building @evidence.dev archie.evidence.app
386 posts 2,411 followers 238 following
Regular Contributor
Active Commenter

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

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

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

@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...

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

Evidence now has a specific guide for connecting to every data source we support docs.evidence.dev/core-concept...