feature-request add tag
Anonymous 2538

it would be nice if [DuckDB](https://duckdb.org/) was added to the list of database engines available in [dbfiddle.uk](https://dbfiddle.uk)

It's similar to SQLite (in-process, single file db) but focused on analytics rather than transactional workflows.

They attempt interesting SQL dialect changes https://duckdb.org/2022/11/14/announcing-duckdb-060.html#sql-syntax-improvements

Cool feature is being able to query remotely hosted datasets: https://duckdb.org/docs/extensions/httpfs

They already have a demo running in browser (WASM runtime): https://shell.duckdb.org/ but it's not as convenient as DBFiddle :)
Top Answer
Jack Douglas
I have had a go at adding DuckDB but failed so far so am loking for some help

~~~ sh
FROM alpine:3.16
RUN apk add --no-cache libc6-compat openrc util-linux haveged nodejs npm \
  && ln -s /lib/libc.musl-x86_64.so.1 /lib/ld-linux-x86-64.so.2 \
  && npm install -g duckdb@0.7.1

docker build -t dummy - < DOCKERFILE
docker run --rm -ti dummy

cat <<"EOF" > duck.js
var duckdb = require('/usr/local/lib/node_modules/duckdb');
var db = new duckdb.Database(':memory:');
db.all('SELECT 42 AS fortytwo', function(err, res) {
  if (err) {
    throw err;

node duck.js

[Error: Connection Error: Connection was never established or has been closed already] {
  errno: -1,

Why am I getting this connection error?
Answer #2
Anonymous 2538
Is the example from https://gist.github.com/ttomasz/8f0ce83cf90830e7e372e8de2a64b170 from my last comment good enough to implement?

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.