playground

The goal of this page is to provide a simple DuckDB editor experience. Allow the upload or paste of raw data (or even web data) and run queries and reports on it.

Examples

Query Explorer

Appendix

• built in d3 methods help parse and autoType the columns passed in
• Flow: 1. Editor component for raw table and sql 2. welcome.md has an example of using raw SQL Schemas 3. This has support for raw csv data and parsing

Currently working on 2 flows: 1: paste CSV and query it, 2: Define a schema, and Query it (make the process of adding data simpler)

Need to figure out what the north star solution is.

Notes

• Data schema validation
• import and parse a dataset
• d3.csvParse
• d3.autoType
• Datasettes