ssanjose/transact

REFACTOR: DB index optimizations

Open

#54 opened on Mar 13, 2025

View on GitHub
 (0 comments) (0 reactions) (0 assignees)TypeScript (1 fork)auto 404
beginner issueenhancementgood first issuehelp wanted

Repository metrics

Stars
 (5 stars)
PR merge metrics
 (PR metrics pending)

Description

The indexes I created needed to be checked to see if they are correctly set up. For example, only put indexes on columns being checked by WHERE clause using Dexie.

All of the things needed to be checked at in the services folder. The db config for table is in this file

Putting this up for anyone to take.

Contributor guide

Research direction
Inspect the db.init.ts file and services folder to verify that indexes are correctly placed on columns used in WHERE clauses. Ensure only necessary indexes exist, following Dexie best practices for performance.
Tech stack
typescript
Domain
database
Issue type
Refactor
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
GitDexie
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60