Skip to content

sqlite and local/sessionStorage #181

Open
Open
sqlite and local/sessionStorage#181
Labels
help wantedExtra attention is needed

Description

@ronag
ronag
opened on Oct 28, 2024

These could be much faster with the help of Fast API and also skipping 2 byte strings when possible.

Activity

  1. ronag
    added
    help wantedExtra attention is needed
    on Oct 28, 2024

  2. thisalihassan commented on Feb 23, 2026

    @thisalihassan
    thisalihassan
    on Feb 23, 2026

    Hi @ronag I have been working on optimizing SQLite read performance, here's what I have done

    1. one byte string fast-path for text values as you suggested
    2. Column names are now internalized and cached

    Here's the benchmark, if this looks good I can raise a PR for this

    Image

  3. thisalihassan commented on Feb 24, 2026

    @thisalihassan
    thisalihassan
    on Feb 24, 2026

    Hi @H4ad @ronag I have raised the PR please do check when you get time.
    Thanks

  4. thisalihassan
    added a commit that references this issue on Apr 7, 2026

    sqlite: use OneByte for ASCII text and internalize col names

    82de30f
  5. nodejs-github-bot
    added a commit that references this issue on Apr 11, 2026

    sqlite: use OneByte for ASCII text and internalize col names

    ef8f8f8
  6. aduh95
    added 2 commits that reference this issue on May 5, 2026

    sqlite: use OneByte for ASCII text and internalize col names

    1e8fa2f

    sqlite: use OneByte for ASCII text and internalize col names

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

    help wantedExtra attention is needed

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions