sqlitebrowser / sqlitebrowser/sqlitebrowser
Tab or section for editing sqlite3_db_config() settings
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 24.6k
- Forks
- 2.4k
- Avg merge
- 3d 49m
- Merged PRs (30d)
- 3
Description
It would be useful to have access to sqlite3_db_config() with an interface similar to the 'Edit Pragmas' tab, particularly for the DQS_DDL and DQS_DML options to disable the "double-quoted string misfeature" (as SQLite documentation vividly terms it) when not desired. This is also, of course, possible by linking against a build of SQLite with those options turned off by default, that that's not a very nice solution, particularly for system packages on Linux and other free unix-likes (which will usually be linked dynamically against whatever the system SQLite is - that will generally not have possibly backcompat-breaking options like DQS_DDL/DQS_DML switched around.)
I may or may not have time in the next little while to provide a proof-of-concept patch for this; the obvious UI design decision (to me at least) is whether to merge them in with the "Edit Pragmas" tab (probably changing its name) or provide a different tab/window.
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 locating the existing “Edit Pragmas” tab and read the sqlite3_db_config() documentation for the DQS_DDL and DQS_DML options. Decide whether the settings belong in that tab or a separate interface; done means users can inspect and change those options through the application.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sqlite
- Domain
- database, desktop
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100