sqlitebrowser / sqlitebrowser/sqlitebrowser

Tab or section for editing sqlite3_db_config() settings

Open
#2,803 1 comment 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement opening database
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

  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 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.