Ducklit - query files in Streamlit with DuckDB

Show the Community!
, , ,
1

Hello!

I wanted to share my app that combines two excellent libraries - Streamlit and DuckDB.

This app lets you upload CSV and JSON and write SQL to query them. When you upload files in the side bar, it automatically loads them into DuckDB tables, which you can then interact with via the code editor. Any valid SQL that works with DuckDB can be run here. Also the DuckDB database is created in-memory, so no data is persisted.

ducklit
ducklit1911×973 91.1 KB

Try the app here: https://ducklit.streamlit.app/
GitHub repo: GitHub - MarkyMan4/ducklit: A Streamlit app to upload files and query with DuckDB

8 Likes
2

This is a really great combination of duckdb & streamlit
can this be extended to files in AWS S3 without downloading the file ?

3

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.