bible-strong icon indicating copy to clipboard operation
bible-strong copied to clipboard

Migrate from JSON Bible Databases to SQLite for Improved Performance

Open smontlouis opened this issue 1 year ago • 0 comments

We're transitioning our Bible databases from JSON format to SQLite. The current JSON databases require complete loading before use, leading to performance bottlenecks. Switching to SQLite will enhance data retrieval efficiency.

Tasks:

  1. Database Conversion: Convert existing JSON Bible databases to SQLite format.
  2. Update Data Access Layer: Refactor the app's data access layer to interact with SQLite databases.
  3. Optimize Queries: Ensure SQL queries are optimized for performance.
  4. Testing: Thoroughly test database interactions for reliability and speed.
  5. Documentation Update: Update any relevant documentation to reflect the new database structure.

smontlouis avatar Feb 03 '24 05:02 smontlouis