search

smontlouis / bible-strong

GNU General Public License v3.0
51 stars 6 forks source link

Migrate from JSON Bible Databases to SQLite for Improved Performance #130

Open smontlouis opened 4 months ago

smontlouis commented 4 months ago

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.