sqlitebrowser / sqlitebrowser/sqlitebrowser

File Manager - using SQLAR table

Open
#3,060 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement sqlite sqlite-extension
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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.