GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — Colorize sqlite3 CLI · Issue #133447 · python/cpython

Colorize sqlite3 CLI #133447

New issue
Copy link
New issue
Copy link
Closed
Closed
Colorize sqlite3 CLI#133447
Copy link
Labels
stdlibStandard Library Python modules in the Lib/ directoryStandard Library Python modules in the Lib/ directorytopic-sqlite3type-featureA feature request or enhancementA feature request or enhancement

Description

@StanFromIreland
StanFromIreland
opened on May 5, 2025
Issue body actions

Feature or enhancement

Proposal:

I will open a pr once #133393 is complete.

General idea is to follow repl color scheme:

sqlite>: repl magenta (i.e. >>>)
keywords: repl keyword blue (i.e. def)
.quit/.help: repl turquoise (i.e. exit)
rest: no color

Has this already been discussed elsewhere?

This is a minor feature, which does not need previous discussion elsewhere

Links to previous discussion of this feature:

No response

Linked PRs

  • gh-133447: Add basic color to sqlite3 CLI #133461

  • gh-133934: Improve sqlite3 .help message #135224
  • gh-133447: Update sqlite3 What's New 3.15 entry #136079
Reacted by Erlend E. Aasland

Activity

  1. StanFromIreland
    added
    type-featureA feature request or enhancementA feature request or enhancement
    on May 5, 2025
  2. hugovk commented on May 5, 2025

    @hugovk
    hugovk
    on May 5, 2025
    Member
    More actions

    See also theming support, which will hopefully be merged soon: issue #133346 / PR #133347.

    Reacted by Stan Ulbrych
  3. ambv commented on May 5, 2025

    @ambv
    ambv
    on May 5, 2025
    Contributor
    More actions

    I like how Stan is already talking in terms of semantic classes.

    Reacted by Hugo van Kemenade
  4. picnixz
    added
    stdlibStandard Library Python modules in the Lib/ directoryStandard Library Python modules in the Lib/ directory
    topic-sqlite3
    on May 5, 2025
  5. StanFromIreland commented on May 5, 2025

    @StanFromIreland
    StanFromIreland
    on May 5, 2025
    MemberAuthor
    More actions

    Unfortunately the code currently uses a subclass of InteractiveConsole (color support anytime soon? ;-) so I would have to write a raw_input, but that still has to wait for the other pr ideally.

    For now I will open a pr adding color to the line starts as it is not depending on the pr. (Progressing like pyrepl coloring...)

    Reacted by Erlend E. Aasland
  6. StanFromIreland commented on May 9, 2025

    @StanFromIreland
    StanFromIreland
    on May 9, 2025
    MemberAuthor
    More actions

    This is not in the sqlite3 project.

    cc @ezio-melotti Can the project be set up to add them when the label is used topic-sqlite3, it would be a good test for the github workflow-like automations for projects that we discussed earlier?

  7. ezio-melotti commented on May 10, 2025

    @ezio-melotti
    ezio-melotti
    on May 10, 2025
    Member
    More actions

    Done!

    Details I enabled the auto-add workflow:

    Image

    which matches 7 issues -- including this one -- but doesn't add them unless they are updated or newly created:

    Image

    Note: after enabling the workflow and posting this message, the issue wasn't added to the workflow, so I added it manually. The GitHub docs are not clear on what "updated" means (apparently posting a message doesn't count as an update).

    Note: I initially added in:title to the auto-add workflow query, but I got an error stating that it's invalid. Even after removing it, the query matches 7 issues, even though when I follow the "See 7 existing issues" link I get 50 issues. I now reported this issue to GitHub.

    Reacted by Stan Ulbrych
  8. ezio-melotti
    added this to sqlite3 issueson May 10, 2025
  9. erlend-aasland
    moved this to In Progress in sqlite3 issueson May 10, 2025
  10. StanFromIreland commented on May 10, 2025

    @StanFromIreland
    StanFromIreland
    on May 10, 2025
    MemberAuthor
    More actions

    posting this message, the issue wasn't added to the workflow

    That is odd, maybe it only checks on title modifications?

    I initially added in:title to the auto-add workflow query, but I got an error stating that it's invalid.

    We could add on the label addition instead like other projects.

  11. erlend-aasland
    added a commit that references this issue on May 10, 2025

    gh-133447: Add basic color to `sqlite3` CLI (#133461)

    30b1d8f
  12. ezio-melotti commented on May 10, 2025

    @ezio-melotti
    ezio-melotti
    on May 10, 2025
    Member
    More actions

    We could add on the label addition instead like other projects.

    Done, and it seems it work on label addition (tested on #129926).

    Image

    Reacted by Stan Ulbrych
  13. tanloong
    added a commit that references this issue on May 10, 2025

    cherry pick from and resolve conflicts with 30b1d8f on main branch

    833140c
  14. encukou commented on Jun 13, 2025

    @encukou
    encukou
    on Jun 13, 2025
    Member
    More actions

    The new sqlite CLI allows spaces between a dot and the command:

    sqlite> . quit
    

    I don't think that was an intentional change?

  15. erlend-aasland commented on Jun 13, 2025

    @erlend-aasland
    erlend-aasland
    on Jun 13, 2025
    Contributor
    More actions

    I don't think that was an intentional change?

    I believe @serhiy-storchaka merged the change that opened up allowing this.

    Reacted by Petr Viktorin
  16. StanFromIreland commented on Jun 13, 2025

    @StanFromIreland
    StanFromIreland
    on Jun 13, 2025
    MemberAuthor
    More actions

    For reference, the issue: #133439, the commit: ebd4881

    It also has several other errors, like no spacing between words in the error message. (I have a pr to fix these: #133807)

    Reacted by Erlend E. Aasland
  17. serhiy-storchaka commented on Jun 13, 2025

    @serhiy-storchaka
    serhiy-storchaka
    on Jun 13, 2025
    Member
    More actions

    I don't think that was an intentional change?

    It was intentional. The SQLite CLI allows this.

    Reacted by Petr Viktorin
  18. encukou commented on Jun 26, 2025

    @encukou
    encukou
    on Jun 26, 2025
    Member
    More actions

    Thank you for the fix!
    Is there anything more to do for this issue?

  19. StanFromIreland commented on Jun 26, 2025

    @StanFromIreland
    StanFromIreland
    on Jun 26, 2025
    MemberAuthor
    More actions

    Is there anything more to do for this issue?

    The goal for this issue was:

    Image

    and so far we have:

    Image

    Though realistically if we do want to implement this, it shouldn't be in sqlite3 because it will just create a mess and add too much complex logic to maintain (in a module that should not have it), especially with the tab completion now.

    So I propose to just add a Whats New note like was done in 3.13 for the REPL, and we can always reopen in the future.

    Reacted by Petr Viktorin
  20. encukou
    added a commit that references this issue on Jul 1, 2025

    gh-133447: Update `sqlite3` What's New 3.15 entry (GH-136079)

    31b56df
  21. encukou
    closed this as completedon Jul 1, 2025
  22. github-project-automation
    moved this from In Progress to Done in sqlite3 issueson Jul 1, 2025
  23. AndPuQing
    added a commit that references this issue on Jul 11, 2025

    pythongh-133447: Update `sqlite3` What's New 3.15 entry (pythonGH-136079

    892677f
  24. Pranjal095
    added 2 commits that reference this issue on Jul 12, 2025

    pythongh-133447: Add basic color to `sqlite3` CLI (python#133461)

    135a100

    pythongh-133447: Update `sqlite3` What's New 3.15 entry (pythonGH-136079

    27648ea
  25. picnixz
    added a commit that references this issue on Jul 13, 2025

    pythongh-133447: Update `sqlite3` What's New 3.15 entry (pythonGH-136079

    afb0b7b
  26. taegyunkim
    added 2 commits that reference this issue on Aug 4, 2025

    pythongh-133447: Add basic color to `sqlite3` CLI (python#133461)

    746a1c0

    pythongh-133447: Update `sqlite3` What's New 3.15 entry (pythonGH-136079

    3e28cab
  27. Agent-Hellboy
    added a commit that references this issue on Aug 19, 2025

    pythongh-133447: Update `sqlite3` What's New 3.15 entry (pythonGH-136079

    aa97630
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    stdlibStandard Library Python modules in the Lib/ directoryStandard Library Python modules in the Lib/ directorytopic-sqlite3type-featureA feature request or enhancementA feature request or enhancement

    Projects

    • sqlite3 issues
      Status
      Done
      Show more project fields

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

    You are visitor 01402503 — GeezerVison does not store the pages you look up.
    Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.