Support SQLite as a Database instead of MySQL

Open
#52 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
Half a day
Newbie friendliness
25/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Stale
Tech stack
javascript, mysql, sqlite
Domain
database

Research direction

The issue relies on the DB_CONNECTION and DB_DATABASE environment variables and on PR #51, which is not linked here, so first find where the database connection is configured and check that PR's history. Confirm that the app starts with DB_CONNECTION=sqlite against a SQLite file and that its data access works. Done means the app runs on SQLite as well as MySQL, with the MySQL-specific code paths identified.

Written by the indexing model from the issue text.

Description

Surprisingly, all it took was creating an SQLite file and adopting PR #51 for this to work.

DB_CONNECTION=sqlite
DB_DATABASE=filename

I'm not sure what else might happen

Dominant language
JavaScript
Stars
143
Forks
33
PR merge metrics
No merged PRs in 30d

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from aaronpk/Compass

All issues in aaronpk/Compass

Similar issues

More JavaScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.