SQL-driven interactive charts, narrative HTML reports, and optional native PNG/PDF export
Compatibility Matrix
This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.
| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
|---|---|---|---|---|---|
| Linux AMD64 | |||||
| Linux ARM64 | |||||
| macOS AMD64 | |||||
| macOS ARM64 | |||||
| Windows AMD64 | |||||
| Windows ARM64 | |||||
| WebAssembly |
Installing and Loading
INSTALL miniplot FROM community;
LOAD miniplot;
Example
-- Pure HTML: no file writes or browser launch
SELECT pie_chart_html(['A', 'B'], [1.0, 2.0], 'Shares');
-- Numeric/time x axes are supported for line and area charts
SELECT line_chart_html(
[TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 12:00:00'],
[12.5, 15.0], 'Measurements'
);
-- A structured narrative report with a chart
SELECT chart_report_html(
'{"title":"Summary","sections":[{"heading":"Findings","text":"B is twice A.","data":[{"type":"bar","x":["A","B"],"y":[1,2]}]}]}'
);
-- Discover installed overloads, types, and runnable examples
SELECT function_name, parameters, parameter_types, description, examples
FROM duckdb_functions()
WHERE function_name IN ('chart_report_html', 'scatter_gl_chart_html', 'chart_export');
About miniplot
Interactive visualization from DuckDB SQL using Plotly.js. Includes bar, line, area, scatter, 3D scatter, histogram, box, pie, donut, horizontal bar, violin, bubble, heatmap, contour, step, radar, and WebGL scatter charts. Numeric and date/time axes preserve numeric spacing and UTC handling for zoned timestamps.
HTML-returning functions work without file writes or browser launches. Native file/browser functions support temporary or explicit output paths and respect DuckDB's external-access setting. Plotly.js is loaded from a CDN for ordinary HTML viewing; a browser connection or cached bundle is needed.
Narrative reports accept a documented JSON specification (title and sections containing escaped prose plus optional Plotly data/layout/config). Reports retain their non-executable JSON specification for agent workflows and reproducibility. Function signatures, descriptions and examples are available through duckdb_functions().
Optional chart_export(html, output_path) creates PNG or PDF on a native host. This requires a separately installed local Node.js/Playwright/Chromium tool and MINIPLOT_EXPORTER pointing to scripts/export-chart.cjs from the source checkout. It uses the installed local Plotly bundle without network requests. These tools are not bundled in the community extension. Wasm users should use HTML output; Wasm cannot spawn the local exporter.
WebGL scatter supports large point sets without silently sampling data, subject to browser/GPU memory limits. Array values must be finite and non-NULL, with documented length and grid-shape validation. Measured serialization results, report JSON schema, source-build instructions and export setup are in the repository README and docs directory.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| area_chart | scalar | Plot a area chart from equal-length nonempty labels and values. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [area_chart(['A', 'B'], [1.0, 2.0], 'Example', 'tmp')] |
| area_chart | scalar | Plot a area chart from equal-length nonempty labels and values. Save an HTML chart, open the browser, and return the file path. | NULL | [area_chart(['A', 'B'], [1.0, 2.0], 'Example')] |
| area_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [area_chart([1.0, 2.0], [1.0, 2.0], 'Example', 'tmp')] |
| area_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [area_chart([DATE '2026-01-01', DATE '2026-01-02'], [1.0, 2.0], 'Example', 'tmp')] |
| area_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [area_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [1.0, 2.0], 'Example', 'tmp')] |
| area_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [area_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [1.0, 2.0], 'Example', 'tmp')] |
| area_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [area_chart([1.0, 2.0], [1.0, 2.0], 'Example')] |
| area_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [area_chart([DATE '2026-01-01', DATE '2026-01-02'], [1.0, 2.0], 'Example')] |
| area_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [area_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [1.0, 2.0], 'Example')] |
| area_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [area_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [1.0, 2.0], 'Example')] |
| area_chart_html | scalar | Plot a area chart from equal-length nonempty labels and values. Return the HTML document without writing a file or opening the browser. | NULL | [area_chart_html(['A', 'B'], [1.0, 2.0], 'Example')] |
| area_chart_html | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [area_chart_html([1.0, 2.0], [1.0, 2.0], 'Example')] |
| area_chart_html | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [area_chart_html([DATE '2026-01-01', DATE '2026-01-02'], [1.0, 2.0], 'Example')] |
| area_chart_html | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [area_chart_html([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [1.0, 2.0], 'Example')] |
| area_chart_html | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [area_chart_html([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [1.0, 2.0], 'Example')] |
| bar_chart | scalar | Plot a bar chart from equal-length nonempty labels and values. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [bar_chart(['A', 'B'], [1.0, 2.0], 'Example', 'tmp')] |
| bar_chart | scalar | Plot a bar chart from equal-length nonempty labels and values. Save an HTML chart, open the browser, and return the file path. | NULL | [bar_chart(['A', 'B'], [1.0, 2.0], 'Example')] |
| bar_chart_html | scalar | Plot a bar chart from equal-length nonempty labels and values. Return the HTML document without writing a file or opening the browser. | NULL | [bar_chart_html(['A', 'B'], [1.0, 2.0], 'Example')] |
| box_chart | scalar | Plot a box-and-whisker chart from nonempty finite numeric samples; Plotly computes quartiles and outliers. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [box_chart([1.0, 2.0, 2.0, 4.0], 'Distribution', 'tmp')] |
| box_chart | scalar | Plot a box-and-whisker chart from nonempty finite numeric samples; Plotly computes quartiles and outliers. Save an HTML chart, open the browser, and return the file path. | NULL | [box_chart([1.0, 2.0, 2.0, 4.0], 'Distribution')] |
| box_chart_html | scalar | Plot a box-and-whisker chart from nonempty finite numeric samples; Plotly computes quartiles and outliers. Return the HTML document without writing a file or opening the browser. | NULL | [box_chart_html([1.0, 2.0, 2.0, 4.0], 'Distribution')] |
| bubble_chart | scalar | Bubble chart; sizes are nonnegative marker diameters in pixels. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [bubble_chart([1.0,2.0], [3.0,4.0], [5.0,6.0], 'Example', 'tmp')] |
| bubble_chart | scalar | Bubble chart; sizes are nonnegative marker diameters in pixels. Save an HTML chart, open the browser, and return the file path. | NULL | [bubble_chart([1.0,2.0], [3.0,4.0], [5.0,6.0], 'Example')] |
| bubble_chart_html | scalar | Bubble chart; sizes are nonnegative marker diameters in pixels. Return the HTML document without writing a file or opening the browser. | NULL | [bubble_chart_html([1.0,2.0], [3.0,4.0], [5.0,6.0], 'Example')] |
| chart_export | scalar | Render Miniplot HTML to PNG or PDF on a native host. Requires external access, Node.js, Playwright/Chromium, and MINIPLOT_EXPORTER pointing to scripts/export-chart.cjs. Returns the saved path; failures preserve existing output. | NULL | [chart_export(bar_chart_html(['A','B'], [1.0,2.0], 'Sales'), 'sales.png')] |
| chart_report | scalar | Save a structured JSON narrative report as HTML; output_path uses the chart tmp/custom/browser contract. | NULL | [chart_report('{"title":"Summary","sections":[{"text":"Sales increased."}]}', 'tmp')] |
| chart_report_html | scalar | Return a narrative HTML report from a JSON object with title and nonempty sections; each section accepts heading/text and optional Plotly data/layout/config. Text is escaped; no raw HTML is accepted. | NULL | [chart_report_html('{"title":"Summary","sections":[{"heading":"Findings","text":"Sales increased."}]}')] |
| contour_chart | scalar | Contour chart; increasing x/y axes, z rows match y and columns match x. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [contour_chart([1.0,2.0], [3.0,4.0], [[5.0,6.0],[7.0,8.0]], 'Example', 'tmp')] |
| contour_chart | scalar | Contour chart; increasing x/y axes, z rows match y and columns match x. Save an HTML chart, open the browser, and return the file path. | NULL | [contour_chart([1.0,2.0], [3.0,4.0], [[5.0,6.0],[7.0,8.0]], 'Example')] |
| contour_chart_html | scalar | Contour chart; increasing x/y axes, z rows match y and columns match x. Return the HTML document without writing a file or opening the browser. | NULL | [contour_chart_html([1.0,2.0], [3.0,4.0], [[5.0,6.0],[7.0,8.0]], 'Example')] |
| donut_chart | scalar | Donut chart with nonnegative values and a positive total. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [donut_chart(['A','B'], [1.0,2.0], 'Example', 'tmp')] |
| donut_chart | scalar | Donut chart with nonnegative values and a positive total. Save an HTML chart, open the browser, and return the file path. | NULL | [donut_chart(['A','B'], [1.0,2.0], 'Example')] |
| donut_chart_html | scalar | Donut chart with nonnegative values and a positive total. Return the HTML document without writing a file or opening the browser. | NULL | [donut_chart_html(['A','B'], [1.0,2.0], 'Example')] |
| heatmap_chart | scalar | Heatmap; increasing x/y axes, z rows match y and columns match x. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [heatmap_chart([1.0,2.0], [3.0,4.0], [[5.0,6.0],[7.0,8.0]], 'Example', 'tmp')] |
| heatmap_chart | scalar | Heatmap; increasing x/y axes, z rows match y and columns match x. Save an HTML chart, open the browser, and return the file path. | NULL | [heatmap_chart([1.0,2.0], [3.0,4.0], [[5.0,6.0],[7.0,8.0]], 'Example')] |
| heatmap_chart_html | scalar | Heatmap; increasing x/y axes, z rows match y and columns match x. Return the HTML document without writing a file or opening the browser. | NULL | [heatmap_chart_html([1.0,2.0], [3.0,4.0], [[5.0,6.0],[7.0,8.0]], 'Example')] |
| histogram_chart | scalar | Plot a histogram from nonempty finite numeric samples; Plotly automatically chooses bins. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [histogram_chart([1.0, 2.0, 2.0, 4.0], 'Distribution', 'tmp')] |
| histogram_chart | scalar | Plot a histogram from nonempty finite numeric samples; Plotly automatically chooses bins. Save an HTML chart, open the browser, and return the file path. | NULL | [histogram_chart([1.0, 2.0, 2.0, 4.0], 'Distribution')] |
| histogram_chart_html | scalar | Plot a histogram from nonempty finite numeric samples; Plotly automatically chooses bins. Return the HTML document without writing a file or opening the browser. | NULL | [histogram_chart_html([1.0, 2.0, 2.0, 4.0], 'Distribution')] |
| horizontal_bar_chart | scalar | Horizontal bar chart. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [horizontal_bar_chart(['A','B'], [1.0,2.0], 'Example', 'tmp')] |
| horizontal_bar_chart | scalar | Horizontal bar chart. Save an HTML chart, open the browser, and return the file path. | NULL | [horizontal_bar_chart(['A','B'], [1.0,2.0], 'Example')] |
| horizontal_bar_chart_html | scalar | Horizontal bar chart. Return the HTML document without writing a file or opening the browser. | NULL | [horizontal_bar_chart_html(['A','B'], [1.0,2.0], 'Example')] |
| line_chart | scalar | Plot a line chart from equal-length nonempty labels and values. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [line_chart(['A', 'B'], [1.0, 2.0], 'Example', 'tmp')] |
| line_chart | scalar | Plot a line chart from equal-length nonempty labels and values. Save an HTML chart, open the browser, and return the file path. | NULL | [line_chart(['A', 'B'], [1.0, 2.0], 'Example')] |
| line_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [line_chart([1.0, 2.0], [1.0, 2.0], 'Example', 'tmp')] |
| line_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [line_chart([DATE '2026-01-01', DATE '2026-01-02'], [1.0, 2.0], 'Example', 'tmp')] |
| line_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [line_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [1.0, 2.0], 'Example', 'tmp')] |
| line_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [line_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [1.0, 2.0], 'Example', 'tmp')] |
| line_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [line_chart([1.0, 2.0], [1.0, 2.0], 'Example')] |
| line_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [line_chart([DATE '2026-01-01', DATE '2026-01-02'], [1.0, 2.0], 'Example')] |
| line_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [line_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [1.0, 2.0], 'Example')] |
| line_chart | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [line_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [1.0, 2.0], 'Example')] |
| line_chart_html | scalar | Plot a line chart from equal-length nonempty labels and values. Return the HTML document without writing a file or opening the browser. | NULL | [line_chart_html(['A', 'B'], [1.0, 2.0], 'Example')] |
| line_chart_html | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [line_chart_html([1.0, 2.0], [1.0, 2.0], 'Example')] |
| line_chart_html | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [line_chart_html([DATE '2026-01-01', DATE '2026-01-02'], [1.0, 2.0], 'Example')] |
| line_chart_html | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [line_chart_html([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [1.0, 2.0], 'Example')] |
| line_chart_html | scalar | Plot equal-length nonempty numeric or date/time x values and numeric y values; numeric spacing is preserved, TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [line_chart_html([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [1.0, 2.0], 'Example')] |
| miniplot | scalar | Return a Miniplot greeting for name. | NULL | [miniplot('Sam')] |
| miniplot_openssl_version | scalar | Return a greeting and the OpenSSL version used to compile Miniplot. | NULL | [miniplot_openssl_version('Sam')] |
| pie_chart | scalar | Pie chart with nonnegative values and a positive total. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [pie_chart(['A','B'], [1.0,2.0], 'Example', 'tmp')] |
| pie_chart | scalar | Pie chart with nonnegative values and a positive total. Save an HTML chart, open the browser, and return the file path. | NULL | [pie_chart(['A','B'], [1.0,2.0], 'Example')] |
| pie_chart_html | scalar | Pie chart with nonnegative values and a positive total. Return the HTML document without writing a file or opening the browser. | NULL | [pie_chart_html(['A','B'], [1.0,2.0], 'Example')] |
| plotly_new | scalar | Plot arbitrary Plotly traces from a JSON array of objects and a JSON layout object; an optional JSON config object defaults to {}. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [plotly_new('[{"x":[1,2],"y":[3,4],"type":"scatter"}]', '{"title":{"text":"Example"}}', '{}', 'tmp')] |
| plotly_new | scalar | Plot arbitrary Plotly traces from a JSON array of objects and a JSON layout object; an optional JSON config object defaults to {}. Save an HTML chart, open the browser, and return the file path. | NULL | [plotly_new('[{"x":[1,2],"y":[3,4],"type":"scatter"}]', '{"title":{"text":"Example"}}')] |
| plotly_new | scalar | Plot arbitrary Plotly traces from a JSON array of objects and a JSON layout object; an optional JSON config object defaults to {}. Save an HTML chart, open the browser, and return the file path. | NULL | [plotly_new('[{"x":[1,2],"y":[3,4],"type":"scatter"}]', '{"title":{"text":"Example"}}', '{"responsive":true}')] |
| plotly_new_html | scalar | Plot arbitrary Plotly traces from a JSON array of objects and a JSON layout object; an optional JSON config object defaults to {}. Return the HTML document without writing a file or opening the browser. | NULL | [plotly_new_html('[{"x":[1,2],"y":[3,4],"type":"scatter"}]', '{"title":{"text":"Example"}}')] |
| plotly_new_html | scalar | Plot arbitrary Plotly traces from a JSON array of objects and a JSON layout object; an optional JSON config object defaults to {}. Return the HTML document without writing a file or opening the browser. | NULL | [plotly_new_html('[{"x":[1,2],"y":[3,4],"type":"scatter"}]', '{"title":{"text":"Example"}}', '{"responsive":true}')] |
| radar_chart | scalar | Radar chart with nonnegative radial values. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [radar_chart(['A','B'], [1.0,2.0], 'Example', 'tmp')] |
| radar_chart | scalar | Radar chart with nonnegative radial values. Save an HTML chart, open the browser, and return the file path. | NULL | [radar_chart(['A','B'], [1.0,2.0], 'Example')] |
| radar_chart_html | scalar | Radar chart with nonnegative radial values. Return the HTML document without writing a file or opening the browser. | NULL | [radar_chart_html(['A','B'], [1.0,2.0], 'Example')] |
| scatter_3d_chart | scalar | Plot a 3D scatter chart from equal-length nonempty x, y and z arrays. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_3d_chart([1.0, 2.0], [3.0, 4.0], [5.0, 6.0], 'Example', 'tmp')] |
| scatter_3d_chart | scalar | Plot a 3D scatter chart from equal-length nonempty x, y and z arrays. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_3d_chart([1.0, 2.0], [3.0, 4.0], [5.0, 6.0], 'Example')] |
| scatter_3d_chart | scalar | Plot a 3D scatter chart with a timestamp/hover label for each point. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_3d_chart([1.0], [2.0], [3.0], ['2026-01-01 10:00'], 'Example', 'tmp')] |
| scatter_3d_chart | scalar | Plot a 3D scatter chart with a timestamp/hover label for each point. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_3d_chart([1.0], [2.0], [3.0], ['2026-01-01 10:00'], 'Example')] |
| scatter_3d_chart_html | scalar | Plot a 3D scatter chart from equal-length nonempty x, y and z arrays. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_3d_chart_html([1.0, 2.0], [3.0, 4.0], [5.0, 6.0], 'Example')] |
| scatter_3d_chart_html | scalar | Plot a 3D scatter chart with a timestamp/hover label for each point. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_3d_chart_html([1.0], [2.0], [3.0], ['2026-01-01 10:00'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([1.0, 2.0], [1.0, 2.0], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([1.0, 2.0], [DATE '2026-01-01', DATE '2026-01-02'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([1.0, 2.0], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([1.0, 2.0], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([DATE '2026-01-01', DATE '2026-01-02'], [1.0, 2.0], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([DATE '2026-01-01', DATE '2026-01-02'], [DATE '2026-01-01', DATE '2026-01-02'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([DATE '2026-01-01', DATE '2026-01-02'], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([DATE '2026-01-01', DATE '2026-01-02'], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [1.0, 2.0], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [DATE '2026-01-01', DATE '2026-01-02'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [1.0, 2.0], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [DATE '2026-01-01', DATE '2026-01-02'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example', 'tmp')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([1.0, 2.0], [1.0, 2.0], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([1.0, 2.0], [DATE '2026-01-01', DATE '2026-01-02'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([1.0, 2.0], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([1.0, 2.0], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([DATE '2026-01-01', DATE '2026-01-02'], [1.0, 2.0], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([DATE '2026-01-01', DATE '2026-01-02'], [DATE '2026-01-01', DATE '2026-01-02'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([DATE '2026-01-01', DATE '2026-01-02'], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([DATE '2026-01-01', DATE '2026-01-02'], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [1.0, 2.0], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [DATE '2026-01-01', DATE '2026-01-02'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [1.0, 2.0], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [DATE '2026-01-01', DATE '2026-01-02'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example')] |
| scatter_chart | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_chart([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([1.0, 2.0], [1.0, 2.0], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([1.0, 2.0], [DATE '2026-01-01', DATE '2026-01-02'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([1.0, 2.0], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([1.0, 2.0], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([DATE '2026-01-01', DATE '2026-01-02'], [1.0, 2.0], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([DATE '2026-01-01', DATE '2026-01-02'], [DATE '2026-01-01', DATE '2026-01-02'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([DATE '2026-01-01', DATE '2026-01-02'], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([DATE '2026-01-01', DATE '2026-01-02'], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [1.0, 2.0], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [DATE '2026-01-01', DATE '2026-01-02'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [1.0, 2.0], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [DATE '2026-01-01', DATE '2026-01-02'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [TIMESTAMP '2026-01-01 10:00:00', TIMESTAMP '2026-01-01 11:00:00'], 'Example')] |
| scatter_chart_html | scalar | Plot a 2D scatter chart from equal-length nonempty numeric or date/time arrays; TIMESTAMP keeps wall-clock fields and TIMESTAMPTZ is shown in UTC. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_chart_html([TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], [TIMESTAMPTZ '2026-01-01 10:00:00+00', TIMESTAMPTZ '2026-01-01 11:00:00+00'], 'Example')] |
| scatter_gl_chart | scalar | WebGL scatter chart for large point sets; requires browser WebGL support. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [scatter_gl_chart([1.0,2.0], [3.0,4.0], 'Example', 'tmp')] |
| scatter_gl_chart | scalar | WebGL scatter chart for large point sets; requires browser WebGL support. Save an HTML chart, open the browser, and return the file path. | NULL | [scatter_gl_chart([1.0,2.0], [3.0,4.0], 'Example')] |
| scatter_gl_chart_html | scalar | WebGL scatter chart for large point sets; requires browser WebGL support. Return the HTML document without writing a file or opening the browser. | NULL | [scatter_gl_chart_html([1.0,2.0], [3.0,4.0], 'Example')] |
| step_chart | scalar | Step chart with horizontal-then-vertical segments; input order is preserved. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [step_chart([1.0,2.0], [3.0,4.0], 'Example', 'tmp')] |
| step_chart | scalar | Step chart with horizontal-then-vertical segments; input order is preserved. Save an HTML chart, open the browser, and return the file path. | NULL | [step_chart([1.0,2.0], [3.0,4.0], 'Example')] |
| step_chart_html | scalar | Step chart with horizontal-then-vertical segments; input order is preserved. Return the HTML document without writing a file or opening the browser. | NULL | [step_chart_html([1.0,2.0], [3.0,4.0], 'Example')] |
| violin_chart | scalar | Violin distribution chart of raw numeric samples. Save an HTML chart and return its path; output_path='tmp' creates a temporary file without opening the browser, a custom path saves there, and an empty path opens the browser. | NULL | [violin_chart([1.0,2.0,2.0], 'Example', 'tmp')] |
| violin_chart | scalar | Violin distribution chart of raw numeric samples. Save an HTML chart, open the browser, and return the file path. | NULL | [violin_chart([1.0,2.0,2.0], 'Example')] |
| violin_chart_html | scalar | Violin distribution chart of raw numeric samples. Return the HTML document without writing a file or opening the browser. | NULL | [violin_chart_html([1.0,2.0,2.0], 'Example')] |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
| name | description | input_type | scope | aliases | typed_value |
|---|---|---|---|---|---|
| temp_directory | Set the directory to which temporary files are written. | VARCHAR | GLOBAL | [] | post.db.tmp |