iiinova — where your digital self keeps evolving

Reposted by archie.md

Evidence @evidence.dev · 20/08/2025

Today Evidence Studio brings you... Custom color palettes for all your charts! docs.evidence.studio/changelog#au...

052

archie.md @archie.sarrewood.com · 21/03/2025

what a beautiful day to be sat inside debugging github actions

The image displays a commit history in a GitHub repository with a series of commits attempting to fix and refine a feature related to JSON parsing and environment variables. Several commits have failed (marked with red X symbols) and a final one is running.

The commit messages include:

"feat: try reporting in PR"
"fix parsing json"
"fix: json"
"fix: simplify"
"fix: use env vars"
"fix: pass to check successfully"
"fix: script"

040

archie.md @archie.sarrewood.com · 12/02/2025

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

0113

archie.md @archie.sarrewood.com · 07/02/2025

working on improving the login experience for @duckdb-gsheets.com no more pasting tokens into the terminal

2232

archie.md @archie.sarrewood.com · 06/02/2025

some musings on continuous vs discrete data - basically all dimensions are discrete, except time - basically all measures are continuous, except counts

the intersection of dimensions and measures with continuous and discrete data

business charts typically have measures on y axis and dimensions on X axis

4 charts showing each combination of dimension, measure on X and Y axis

(for squareness in preview, a fourth image was added)

050

Reposted by archie.md

DuckDB @duckdb.org · 05/02/2025

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

15823

Reposted by archie.md

Tobias Müller @tobilg.com · 05/02/2025

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

OwnStats - Self-hosted web analytics on AWS

5427

archie.md @archie.sarrewood.com · 04/02/2025

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

0182

archie.md @archie.sarrewood.com · 30/01/2025

@duckdb-gsheets.com is starting to get a lot of downloads credit for chart @dtenwolde.bsky.social duckdb-ce-analysis.evidence.app

1232

archie.md @archie.sarrewood.com · 30/01/2025

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

evidence.dev

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

3273

Reposted by archie.md

Evidence @evidence.dev · 27/01/2025

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

172

archie.md @archie.sarrewood.com · 27/01/2025

who made this and can you update it pls gasandeggs.evidence.app

gasandeggs.evidence.app

Gas And Egg Prices

040

archie.md @archie.sarrewood.com · 23/01/2025

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

docs.evidence.dev

Snowflake

Connect Evidence to Snowflake

020

archie.md @archie.sarrewood.com · 21/01/2025

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?

461

archie.md @archie.sarrewood.com · 20/01/2025

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

docs.evidence.dev

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.

2123

archie.md @archie.sarrewood.com · 20/01/2025

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

0230

archie.md @archie.sarrewood.com · 17/01/2025

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

4192

archie.md @archie.sarrewood.com · 17/01/2025

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)

150

archie.md @archie.sarrewood.com · 17/01/2025

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

250

archie.md @archie.sarrewood.com · 16/01/2025

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

docs.evidence.dev

Bar Chart

Compare a metric across a small number of categories.

071

archie.md @archie.sarrewood.com · 13/01/2025

playing around with an AgGrid component for @evidence.dev

231

archie.md @archie.sarrewood.com · 06/01/2025

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?

100

archie.md @archie.sarrewood.com · 24/12/2024

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

420

archie.md @archie.sarrewood.com · 19/12/2024

so much cool stuff coming to Evidence

050

archie.md @archie.sarrewood.com · 19/12/2024

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

074

archie.md @archie.sarrewood.com · 19/12/2024

are you a chatGPT poweruser? do you know the keyboard shortcuts? cmd + / to see them

020

Reposted by archie.md

DuckDB @duckdb.org · 18/12/2024

DuckDB has a new Node.js client with more features and a more idiomatic API. Read the guest blog post by Jeff Raymakers (MotherDuck) for more details: duckdb.org/2024/12/18/d...

1449

archie.md @archie.sarrewood.com · 18/12/2024

to unsubscribe from microsoft marketing emails you need to… *checks notes* …request another email

110

Reposted by archie.md

The Life of Sharks @thelifeofsharks.com · 17/12/2024

Bond Villain Sharks.

326874604

Reposted by archie.md

Timo Dechau @timodechau.bsky.social · 15/12/2024

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

2154

Reposted by archie.md

Daniel ten Wolde @dtenwolde.bsky.social · 16/12/2024

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

duckdb-ce-analysis.evidence.app

DuckDB extension weekly downloads

Explore dynamic insights into weekly and monthly download trends for DuckDB extensions, all in one interactive dashboard!

1224

archie.md @archie.sarrewood.com · 14/12/2024

adding another layer of hierarchy in the @evidence.dev sidebar to better organize content inside your apps testing on the docs site

160

Reposted by archie.md

Jacob Matson @matsonj.com · 13/12/2024

fooling around with new themes on mdsinabox.com. trying to evoke looking at the sports page late 90s in the seattle times...

4132

archie.md @archie.sarrewood.com · 13/12/2024

yeah so I made a dracula theme for Evidence github.com/evidence-dev...

A standard Evidence template styled using the popular Dracula dark mode theme. Incorporating purple, cyan, pink and neon green, the theme is very distinctive

2211

Reposted by archie.md

Evidence @evidence.dev · 12/12/2024

Themes and dark mode have arrived in Evidence. Design incredible-looking data products with just a few lines of config. evidence.dev/blog/themes/

evidence.dev

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

1142

archie.md @archie.sarrewood.com · 13/12/2024

tried to install @duckdb.org on my new computer but there aren’t any precompiled binaries when will quibit architectures be supported?

180

archie.md @archie.sarrewood.com · 13/12/2024

there is so much chat about apache iceberg but goddamn is it hard to run why do i need a separate catalog? why are there manifests AND metadata files? and why do i need to run Java!?! is this the future? i hope not

9331

Reposted by archie.md

Jacob Matson @matsonj.com · 12/12/2024

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

0202

archie.md @archie.sarrewood.com · 11/12/2024

ask chatGPT what it knows about you 3/4 for me

110

archie.md @archie.sarrewood.com · 06/12/2024

one unique thing about @evidence.dev is how portable it is - you can deploy it almost anywhere! added instructions for hosting on 10 platforms: - evidence cloud - aws - gcp - azure - github pages - gitlab pages - cloudflare pages - vercel - netlify - hugging face docs.evidence.dev/deployment/f...

docs.evidence.dev

Firebase

Deploy Evidence to Firebase Hosting by linking to a Git repository. Hosting supports custom domains and GitHub Actions for data refresh.

0211