Feature Request: open OPFS sqlite database

Open airen1986 opened this issue 1 year ago • 2 comments

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

Sep 24 '24 07:09 airen1986

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

Sep 24 '24 07:09 invisal

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.

Sep 24 '24 11:09 airen1986