D3 contours and Plot spatial interpolatorsPie chart with radialGradientCoahuilagraph (user support)Derive and filter in arqueroSUM(ROUND()) doesn't like NaNParquet files directly from GitHubAggregating dataProject and clipAdd a class to an observable inputA button to download a FileAttachmentCreate an average line in PlotA centered titleCatches sites
DuckDB and bigint
db = {
const c = await DuckDBClient.of({});
await c.query(`CREATE TABLE dt(u STRING, x BIGINT, y FLOAT, z INTEGER)`);
await c.query(
`INSERT INTO dt VALUES ('a', 1, 5, 1), ('b', 2, 6, 2), ('c', 3, 7, 3), ('d', 4, 8, 4);`
);
return c;
}
db
a.map((d) => d.x) // bigint
db
b.map((d) => d.x) // number!
// 🌶 SELECT *, x::int x select x twice, first as part of * and as a BigInt, then on its own. It seems that the first has precedence, which explains the outcome.
db
c.map((d) => d.x) // int
db.query("SELECT x::INT AS x FROM dt").then((res) => res.map((d) => d.x))
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
