sqlitebrowser / sqlitebrowser/sqlitebrowser
File Manager - using SQLAR table
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 24.6k
- Forks
- 2.4k
- Avg merge
- 3d 49m
- Merged PRs (30d)
- 3
Description
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).
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reading SQLite's sqlar table documentation and the linked sqlar tool description, then compare their behavior with the SQLite CLI .archive command. Define how DB Browser would browse, save, and load files stored in a database, including whether project or SQL files and local filesystem transfers are in scope. Done should include an agreed design and a working file-tree workflow.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sqlite
- Domain
- database, desktop
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100