archie.md

@archie.sarrewood.com

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

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

Bild

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

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

Bild

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

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)

Bild

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

Bild

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