[Feature Request]: read sqlite file

[poneoneo]

i'm developping a web scraping tool that could create and sqlite that i want to quickly read with browsr is this possible to implement ?

[juftin]

🤔 this could be possible, I like the idea. The one difficulty I can think of would be the possibility for multiple tables. So currently data files (CSV/parquet) render into a DataTable inside browsr. For a sqlite file, each table would essentially be its own DataTable so there would need to be an additional widget (like a dropdown) that allows you to select which table you'd like to view.

[poneoneo]

There are library as sqlite-utils that can make join operations on csv/sqlite file. I'm thinking that you could convert sqlite file into Csv and then read from :memory: instead to create unwanted file

[juftin]

Reading SQLite databases into memory is pretty straightforward. The issue is when multiple tables exist within a database, there would need to be UI changes so that you can navigate between tables.