archie.md
@archie.sarrewood.com
SQL, data viz, duckdb, markdown
building @evidence.dev
archie.evidence.app
building @evidence.dev
archie.evidence.app
Pinned
archie.md
@archie.sarrewood.com
· Jan 30
@duckdb-gsheets.com is starting to get a lot of downloads
credit for chart @dtenwolde.bsky.social
duckdb-ce-analysis.evidence.app
credit for chart @dtenwolde.bsky.social
duckdb-ce-analysis.evidence.app
Reposted by archie.md
Today Evidence Studio brings you...
Custom color palettes for all your charts!
docs.evidence.studio/changelog#au...
Custom color palettes for all your charts!
docs.evidence.studio/changelog#au...
August 20, 2025 at 2:00 AM
Today Evidence Studio brings you...
Custom color palettes for all your charts!
docs.evidence.studio/changelog#au...
Custom color palettes for all your charts!
docs.evidence.studio/changelog#au...
@duckdb-gsheets.com now supports ducklake!
July 17, 2025 at 2:03 PM
@duckdb-gsheets.com now supports ducklake!
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
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
April 3, 2025 at 8:57 PM
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
Wednesday, April 9 / 12:30 PM EDT
sign up 👇
lu.ma/gmsg4lcl
what a beautiful day to be sat inside debugging github actions
March 21, 2025 at 6:56 PM
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...
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...
February 28, 2025 at 3:52 PM
an awesome write up of the @duckdb-gsheets.com extension
@a13x.bsky.social ripping some cool forecasting workflows with @duckdb-gsheets.com
February 27, 2025 at 5:01 PM
@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...
it's because we're normally doing the same thing - discrete dimension on X axis, continuous measure on Y
evidence.dev/blog/discret...
February 12, 2025 at 9:46 PM
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...
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
no more pasting tokens into the terminal
February 7, 2025 at 6:11 PM
working on improving the login experience for @duckdb-gsheets.com
no more pasting tokens into the terminal
no more pasting tokens into the terminal
run query-> get chart, using @duckdb-gsheets.com
February 6, 2025 at 7:54 PM
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
- basically all dimensions are discrete, except time
- basically all measures are continuous, except counts
February 6, 2025 at 6:14 PM
some musings on continuous vs discrete data
- basically all dimensions are discrete, except time
- basically all measures are continuous, except counts
- basically all dimensions are discrete, except time
- basically all measures are continuous, except counts
Reposted by archie.md
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...
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...
February 5, 2025 at 2:54 PM
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...
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...
Reposted by archie.md
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
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
February 5, 2025 at 1:08 PM
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
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!
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!
February 4, 2025 at 7:08 PM
@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!
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
credit for chart @dtenwolde.bsky.social
duckdb-ce-analysis.evidence.app
January 30, 2025 at 10:48 PM
@duckdb-gsheets.com is starting to get a lot of downloads
credit for chart @dtenwolde.bsky.social
duckdb-ce-analysis.evidence.app
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...
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
January 30, 2025 at 5:13 PM
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...
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...
Reposted by archie.md
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
- 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
January 27, 2025 at 3:24 PM
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
- 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 now has a specific guide for connecting to every data source we support
docs.evidence.dev/core-concept...
docs.evidence.dev/core-concept...
Snowflake
Connect Evidence to Snowflake
docs.evidence.dev
January 23, 2025 at 9:59 PM
Evidence now has a specific guide for connecting to every data source we support
docs.evidence.dev/core-concept...
docs.evidence.dev/core-concept...
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?
- how many dimensions?
- discrete or continuous?
- how many values?
etc
this is my first attempt - what did i get wrong here?
January 21, 2025 at 4:51 AM
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?
- 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
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
January 20, 2025 at 6:18 AM
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/components/charts/line-chart
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
“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
January 20, 2025 at 4:00 AM
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
“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
I used this to make this cool app using US housing index data from fhfa.gov in 80 mins and <100 lines of markdown
January 17, 2025 at 10:28 PM
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
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)
`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)
January 17, 2025 at 7:52 PM
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)
`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
10 notifications in a row about comments by a single connection on posts by people i’ve never met
in under an hour
January 17, 2025 at 3:36 AM
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
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...
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
January 16, 2025 at 9:40 PM
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...
Also every page now has a nice social card
docs.evidence.dev/components/c...