blazing fast duckdb bindings for deno
- 2-4x faster than Bun.
- 10x faster than Node.
View source
import { open } from "jsr:@divy/[email protected]";
const db = open("/tmp/test.db");
const connection = db.connect();
const q = "select i, i as a from generate_series(1, 100000) s(i)";
const p = connection.prepare(q);
console.log("benchmarking query: " + q);
bench("duckdb", () => {
p.query();
});
await run({ percentiles: false });
connection.close();
db.close();# Deno canary
benchmarking query: select i, i as a from generate_series(1, 100000) s(i)
cpu: Apple M1
runtime: deno 1.24.0 (aarch64-apple-darwin)
benchmark time (avg) (min … max)
-------------------------------------------------
duckdb 4.66 ms/iter (4.26 ms … 7.47 ms)
# Bun
benchmarking query: select i, i as a from generate_series(1, 100000) s(i)
cpu: Apple M1
runtime: bun 0.1.4 (arm64-darwin)
benchmark time (avg) (min … max)
-------------------------------------------------
duckdb 8.69 ms/iter (6.26 ms … 11.4 ms)
View JIT benchmarks
const db = open(":memory:");
const connection = db.connect(db);
const q = "select i, i as a from generate_series(1, 100000) s(i)";
const p = connection.prepare(q);
console.log("benchmarking query: " + q);
group("query", () => {
bench("jit query()", () => p.query());
bench("query()", () => connection.query(q));
});
group("stream", () => {
bench("jit stream()", () => {
for (const x of p.stream()) x;
});
bench("stream()", () => {
for (const x of connection.stream(q)) x;
});
});# Deno canary
benchmarking query: select i, i as a from generate_series(1, 100000) s(i)
cpu: Apple M1
runtime: deno 1.24.0 (aarch64-apple-darwin)
benchmark time (avg) (min … max)
----------------------------------------------------
query
----------------------------------------------------
jit query() 4.79 ms/iter (4.31 ms … 12.06 ms)
query() 8.26 ms/iter (7.54 ms … 16.44 ms)
summary for query
jit query()
1.72x faster than query()
stream
----------------------------------------------------
jit stream() 9.96 ms/iter (9.84 ms … 10.18 ms)
stream() 10.97 ms/iter (10.82 ms … 11.35 ms)
summary for stream
jit stream()
1.1x faster than stream()
# Bun
benchmarking query: select i, i as a from generate_series(1, 100000) s(i)
cpu: Apple M1
runtime: bun 0.1.4 (arm64-darwin)
benchmark time (avg) (min … max)
----------------------------------------------------
query
----------------------------------------------------
jit query() 8.61 ms/iter (7.54 ms … 10.43 ms)
query() 18.5 ms/iter (17.16 ms … 20.34 ms)
summary for query
jit query()
2.15x faster than query()
stream
----------------------------------------------------
jit stream() 16.36 ms/iter (15.55 ms … 17.79 ms)
stream() 21.44 ms/iter (21.02 ms … 23.18 ms)
summary for stream
jit stream()
1.31x faster than stream()
import { open } from "https://deno.land/x/duckdb/mod.ts";
const db = open("./example.db");
// or const db = open(':memory:');
const connection = db.connect();
connection.query("select 1 as number"); // -> [{ number: 1 }]
for (const row of connection.stream("select 42 as number")) {
row; // -> { number: 42 }
}
const prepared = connection.prepare(
"select ?::INTEGER as number, ?::VARCHAR as text",
);
prepared.query(1337, "foo"); // -> [{ number: 1337, text: 'foo' }]
prepared.query(null, "bar"); // -> [{ number: null, text: 'bar' }]
connection.close();
db.close();Thanks to the original author of @evan/duckdb
@evanwashere for most of the implementation
that has been reused in this module.
Modifications are licensed under MIT © Divy
Original (bun version):
Apache-2.0 © Evan