archiewood

My gameboy color still works

If you want to deliver data to your customers you have two main options:

1. Build something custom in js

2. Use a drag and drop BI tool

(1) works if you are a front-end dev, but then it means the dev team need to own it forever, deal with customer requests etc

(2) means the data team can run it, but there's poor release management, and normally doesn't look good in your app

Evidence's version tries to hit the sweet spot: It's still written in code so you have version control and flexibility for customization, but it's SQL and Markdown so the data team can maintain it

DuckDB is really having a moment

The ecosystem is very active, and they have recently opened up "community extensions" to bring your own functions, data types and connections. A barrier at the moment is that extensions are written in C++, though this limitation should be removed soon.

I've been building a lot on top of DuckDB, two of the projects I'm working on are linked in the article:

- Evidence (https://evidence.dev): Build data apps with SQL + Markdown

- DuckDB GSheets (https://duckdb-gsheets.com): Read/Write Google Sheets via DuckDB

DuckDB GSheets is a DuckDB extension that allows you to read and write data from Google Sheets.

-- Install

install gsheets from community;

load gsheets;

-- Authenticate with the browser

create secret (type gsheet);

-- Read

select * from 'https://docs.google.com/spreadsheets/d/11QdEasMWbETbFVxry-Ss...'

-- Write

COPY <table_name> to 'https://docs.google.com/spreadsheets/d/11QdEasMWbETbFVxry-Ss...' (format gsheet);

Wow this is much more complete than mine, kudos.

Oh definitely, I love DuckDB.

This was a learning exercise for me as much as anything

I've always been curious about how SQL engines actually work.

So I built a minimum viable SQL engine in Go.

- Supports CSV files as tables

- Supports SELECT, FROM, WHERE, LIMIT

It's very simple:

1. Parses query string

2. Converts it into an AST representation

3. Executes the query against the CSV

4. Returns the results

503 Service Unavailable - PUT https://registry.npmjs.org/package-name - Service Unavailable

Wanted an incredibly simple interface for plotting data.

Pass data from CLI arguments, or a CSV file, get a nice chart with zero config:

`plot data.csv`

Excel for mac is (intentionally?) crippled.

Any serious Excel user has a PC.

One of the few places remaining where Windows > Mac

You might be interested in what we’re building over at Evidence.dev

It’s basically RMarkdown for SQL

This is by far the most impressive link in the comments.

i was kind of messing around with this blinking idea but couldn't get it to render in a way I was happy with

would you use another keyframe or did you have something else in mind

Thanks - I do honestly think the keyframes are a bit of a nightmare, but they also kind of make the site

I cheated for brevity :S

repo was private, now public!

oops well i just saw this took off and have made it public - thanks

I built this website to see what was possible with only one div, and a stylesheet.

No JS, No other HTML, just CSS.

Source: https://github.com/archiewood/pure-css-site

I’d love to try this with the data from our public slack community.

What’s the best way to go about this?

I see you support csv uploads but it’s going to take me a decent amount of wrangling to unpack the json blobs slack spits out.

Feel free to reach out: archie at evidence.dev