archiewood
Joined 6 years ago
Karma
238
Submissions
76
Member since
Sep 25
Recent submissions
Comment · 6 months ago
My gameboy color still works
Comment · 10 months ago
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
Comment · 1 year ago
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
Comment · 2 years ago
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);
Comment · 2 years ago
Wow this is much more complete than mine, kudos.
Comment · 2 years ago
Oh definitely, I love DuckDB.
This was a learning exercise for me as much as anything
Comment · 2 years ago
503 Service Unavailable - PUT https://registry.npmjs.org/package-name - Service Unavailable