KO
|
EN
gitlite — search
Search
#java
#javascript
#php
#nodejs
#golang
#docker
#mongodb
#twitter
#python
#r
#go
#composer
QuackDB
★ 206
Open GitHub ↗
Open-source in-browser DuckDB SQL editor
Download README (.md)
Explore Similar Repositories
skywalking-booster-ui
:
Apache SkyWalking 3rd generation UI
sentry-kotlin-multiplatform
:
Sentry SDK for Kotlin Multiplatform
kafka-ml
:
Kafka-ML: connecting the data stream with ML/AI frameworks (now TensorFlow and PyTorch!)
veact
:
A mutable state enhancer library for React, based on @vue/reactivity.
vredeburg
:
A simple starter project to create a blog using Eleventy and Tailwind CSS
// repository documentation
Was this content helpful?
★ 0
(0 ratings)
Select Rating:
★
★
★
★
★
Submit Feedback
Recent Feedback
×
Download README
Do you want to download the
README.md
file for
QuackDB
?
Download (.md)
# QuackDB - Online DuckDB SQL Playground [](https://github.com/mattf96s/QuackDB/actions/workflows/release.yml)  QuackDB is a privacy-preserving in-browser DuckDB SQL playground and editor. Demo available at [quackdb.com](https://www.quackdb.com). - **In-Browser**: The DuckDB Wasm library is used to run SQL queries in the browser. - **File Types**: Supports `.csv`, `.json`, `.parquet`, `.sqlite`, `.duckdb` and `.arrow` files. - **Privacy**: no screen recordings or client-side error monitoring (only Vercel Analytics). - **Filesystem Access**: OPFS is used to store files in the browser's filesystem for persistence.  ## Motivation I wanted a quick and simple tool for iterating on DuckDB queries and visualizing the results. I also wanted to experiment with the new Filesystem Access API (OPFS) and explore the capabilities of DuckDB in the browser. ## Tech Stack | Category | Tool | | ------------- | ----------------------------------------------------------------------------------------------------------------------------------- | | Database | [DuckDB Wasm](https://duckdb.org/) | | Frontend | [Remix](https://remix.run/) · [Tailwind CSS](https://tailwindcss.com/docs/table-layout), [shadcn/ui](https://ui.shadcn.com/) | | Backend | [Vercel](https://vercel.com/docs/frameworks/remix) | | Visualization | [Observable Plot](https://observablehq.com/plot/), [Tanstack Table](https://tanstack.com/table/latest) | | Web APIs | [Comlink](https://github.com/GoogleChromeLabs/comlink), [OPFS](https://web.dev/file-system-access/) | > An earlier version of this project used [SST](https://docs.sst.dev/start/remix) for the backend infrastructure, but I switched to Vercel for simplicity. ## TODO - [ ] Safari support 😁 - [ ] Improved UI / charts / tables / etc. - [ ] Data import/export - [ ] Responsive design improvements - [ ] Performance improvements with Arrow - [ ] Snippets / examples ## Maybe - [ ] [NSQL](https://motherduck.com/blog/duckdb-text2sql-llm/) integration for natural language queries. - [ ] Co-pilot (or similar) integration for code suggestions. ## Inspiration - [CMU Data Interaction Group](https://github.com/cmudig) - [SQL Workbench](https://sql-workbench.com/) - [Evidence](https://github.com/evidence-dev/evidence) - [Malloy](https://github.com/malloydata/malloy) - [wa-sqlite](https://github.com/rhashimoto/wa-sqlite/blob/master/demo/demo-worker.js) - [Rill](https://github.com/rilldata/rill) - [Observable](https://github.com/observablehq) ## License MIT ## Disclaimer This project is not in any way affiliated with DuckDB or any of the other projects mentioned above. ## Tips - Built in chrome OPFS viewer can be accessed from <https://www.quackdb.com/temporary>. To navigate, manually change the URL to the desired path as Chrome does not allow navigation by clicking on the links. ## Known Issues - Safari will not be fully supported until this [bug](https://bugs.webkit.org/show_bug.cgi?id=256712#c0) is fixed (serializing file handles is not supported in Safari).
