Sign in

archie.md

@archie.sarrewood.com
2.6K followers 245 following 425 posts

SQL, data viz, duckdb, markdown building @evidence.dev archie.evidence.app

PostsRepliesMedia
archie.md @archie.sarrewood.com · 17/07/2025
@duckdb-gsheets.com now supports ducklake!
0112
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 · 06/03/2025
I have a video doorbell with both a chime and wireless hookup. it was very difficult to install you’ll be needing a dc transformer and to be prepared to read lots of simple diagrams like this
100
archie.md @archie.sarrewood.com · 27/02/2025
@a13x.bsky.social ripping some cool forecasting workflows with @duckdb-gsheets.com
0131
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
run query-> get chart, using @duckdb-gsheets.com
2365
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 databusiness charts typically have measures on y axis and dimensions on X axis4 charts showing each combination of dimension, measure on X and Y axis(for squareness in preview, a fourth image was added)
050
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 · 23/01/2025
the caveat here is hilarious… so what is the intended purpose here?
100
archie.md @archie.sarrewood.com · 21/01/2025
in this case, i’m using it to distinguish orientation of the bars
100
archie.md @archie.sarrewood.com · 21/01/2025
prior art this is quite good but i feel like: 1. the first question is too subjective 2. there are charts here that no business should use (radar, pie, surface plot)
230
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 · 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 · 13/01/2025
110
archie.md @archie.sarrewood.com · 13/01/2025
playing around with an AgGrid component for @evidence.dev
231
archie.md @archie.sarrewood.com · 24/12/2024
010
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
archie.md @archie.sarrewood.com · 19/12/2024
it’s less than a 2C error in reasonable rages for outdoor temperature
it’s less than a 2C error in reasonable rages for outdoor temperature
120
archie.md @archie.sarrewood.com · 18/12/2024
i raise you toronto it’s sunny, but dropping to 3F
120
archie.md @archie.sarrewood.com · 18/12/2024
to unsubscribe from microsoft marketing emails you need to… *checks notes* …request another email
110
archie.md @archie.sarrewood.com · 17/12/2024
go get an x-ray you probably have mallet finger source: have mallet finger
110
archie.md @archie.sarrewood.com · 14/12/2024
+ obligatory dark mode
020
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
archie.md @archie.sarrewood.com · 13/12/2024
I want to do a version of this that uses monospace fonts in the future also
250
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
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 · 11/12/2024
ask chatGPT what it knows about you 3/4 for me
110
archie.md @archie.sarrewood.com · 07/12/2024
i have managed to clone it! turns out if i swapped apps something was killing the process but now the builds just fail out…
110
archie.md @archie.sarrewood.com · 06/12/2024
dammit
120
archie.md @archie.sarrewood.com · 06/12/2024
this was 6 months ago time to try again I think
terminal screenshot showing downloading duckdb from source in iSh app
220
archie.md @archie.sarrewood.com · 06/12/2024
there’s a guy rigging this up on the slack community evidencedev.slack.com/archives/C02...
100
archie.md @archie.sarrewood.com · 03/12/2024
cool bskypt.vercel.app
0110
archie.md @archie.sarrewood.com · 03/12/2024
boiling water tap x-post from insta
000
archie.md @archie.sarrewood.com · 26/11/2024
if you're into data viz and version control, we're running our first @evidence.dev in person event in NYC next week. we've got limited space, but a couple of spots still open apply here if interested: du3tapwtcbi.typeform.com/evidencelab-...
080
archie.md @archie.sarrewood.com · 26/11/2024
related
020
archie.md @archie.sarrewood.com · 26/11/2024
wait until you discover the dimensions of 2x4
110
archie.md @archie.sarrewood.com · 26/11/2024
if another forbes 30 under 30 CEO DMs me on LinkedIn to plant a tree i’m going to lose it
120
archie.md @archie.sarrewood.com · 23/11/2024
HTTPFS (and @duckdb.org extensions in general) are coming to @evidence.dev @matsonj.com
3241
archie.md @archie.sarrewood.com · 23/11/2024
dude was on the wrong site
040
archie.md @archie.sarrewood.com · 21/11/2024
duckdb-gsheets v0.0.3 is out, courtesy of @a13x.bsky.social the power is terrifying! duckdb-gsheets.com
2708
archie.md @archie.sarrewood.com · 20/11/2024
y’all you can now deploy @evidence.dev to @github.com Pages archiewood.github.io/github-pages...
1292
archie.md @archie.sarrewood.com · 19/11/2024
this is so great - definitely going to use this to track usage of @duckdb.org gsheets
User statistics dashboard featuring a graph that tracks the number of users of DuckDB GSheets extension, showcasing performance metrics visually.
061
archie.md @archie.sarrewood.com · 19/11/2024
took 19 days on bsky vs about 2 years on twitter to reach the same data gang followers 🐦 1,507 vs 🦋 1,495
0230
archie.md @archie.sarrewood.com · 19/11/2024
hmmm I think i am going to like this side project
2262
archie.md @archie.sarrewood.com · 18/11/2024
name a consumer data experience you actually like i’ll start: strava
20553