sqlitebrowser icon indicating copy to clipboard operation
sqlitebrowser copied to clipboard

File Manager - using SQLAR table

Open midijohnny opened this issue 3 years ago • 2 comments

SQLite already has the option to create the sqlar table which is interoperable with known tools - including the SQLite CLI .archive command (depending on compile options) and the sqlar tool itself.

It might be nice to make use of this in DB Browser - so that you could browse / save / load 'files' from directly in the DB. Which could also then provide a layer which could be built-on - to allow you to save projects/sql files directly in the DB - making a portable project.

I am suggesting it could be analogous to what some IDEs allow - like Netbeans, Thonny etc - a tree structure that you can explore and load up content from - the only difference being it would be in the DB. (Or perhaps it could also look at local filesystem as well - to allow transfers in the future also).

midijohnny avatar Jun 07 '22 15:06 midijohnny

I've always liked the idea of storing preferences/project data in an sqlite database rather than a different format. Haven't used sqlar functions before.
Thanks for raising this as something to look into.

chrisjlocke avatar Jun 08 '22 15:06 chrisjlocke

Even without adding sqlar file browsing functionality, would it be possible to include the sqlar extension?

qqii avatar Sep 29 '22 12:09 qqii