search

outerbase / studio

A lightweight SQLite graphical client on your browser. It also support connecting to LibSQL/Turso/rqlite
https://libsqlstudio.com
GNU Affero General Public License v3.0
476 stars 24 forks source link

Feature Request: open OPFS sqlite database #164

Open airen1986 opened 2 months ago

airen1986 commented 2 months ago

It would be nice, if we could open OPFS SQLITE file in libsql-studio

invisal commented 2 months ago

@airen1986 Interesting. Could you share what is the use-case for OPFS Sqlite?

airen1986 commented 2 months ago

It would be more browser friendly to open a sqlite file in firefox, where you could first create a copy of local sqlite database in OPFS and do all the updates in OPFS only, making it more secure. For complex queries it will run in worker thereby sparing main thread. Also I am working on a web application, which is using OPFS sqlite database. I think it would be nice, if I could add sqlite editor functionality through libsql-studio.

Something like this URL: https://libsqlstudio.com/playground/client?dbname=opfsdb should open opfsdb file from OPFS system

I understand, I need to host a copy of libsql-studio to access opfs file from my origin.