3 ms·
Wow! Is there any way this could support SQLite databases?
by bbkane 3y ago
Wow! Is there any way this could support SQLite databases?
- chrisjc 3y agoI 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
- prasoonds 3y agoDuckDB supports SQLite through extensions (https://duckdb.org/docs/extensions/sqlite.html https://duckdb.org/docs/extensions/sqlite.html) So, it should be pretty straightforward to let folks drop a SQLite file instead of a CSV file! I haven't been able to get extensions to work on WASM so far though but I will definitely take a look to see if we can make this work!
- bbkane 3y agoFantastic! Would you like me to make an issue for this?