4 ms·
I haven't taken a close enough look at it yet, but duckdb supports Sqlite databases, so in theory yes. However, using Sqlite requires a duckdb extension and i'
by chrisjc 3y ago
I haven't taken a close enough look at it yet, but duckdb supports Sqlite databases, so in theory yes.
However, using Sqlite requires a duckdb extension and i'm not sure if works for wasm, and if so enabled this project in particular.
https://duckdb.org/docs/guides/import/query_sqlite https://duckdb.org/docs/guides/import/query_sqlite
But I believe that most of these duckdb web-IDEs will revolve around a couple of generalized used cases:
1. OLAP/analytical type workloads/queries. Sqlite is really more for OLTP/transactional workloads.
2. Querying datasets that are available on, targeted for blob/object storage like S3. Parquet, CSV, line-delimited JSON, etc