Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

DB Setup #42

Closed
abhayks1 opened this issue May 29, 2019 · 2 comments
Closed

DB Setup #42

abhayks1 opened this issue May 29, 2019 · 2 comments

Comments

@abhayks1
Copy link
Contributor

abhayks1 commented May 29, 2019 •
edited
Loading

The ticket is about setting up DB and defining npm to interact with the databases tables.

  • Setup docker+mysql sqlite. If we decide to chose any other database, update the docker accordingly.

  • Use a good javascript npm/library for interacting with database. Below npm can be used. It also supports migration.
    http://docs.sequelizejs.com/

Acceptance criteria of the ticket is to run a sqlite mysql node and connect it with nodejs npm.
@deepesh-kn deepesh-kn mentioned this issue May 31, 2019
Closed
@abhayks1 abhayks1 changed the title DB Setup, Schema and Interaction Layer DB Setup Jun 3, 2019
@deepesh-kn
Copy link
Contributor

  • Select latest and stable version for docker sqlite image
  • Define docker compose.yml for sqlite.
  • Update package.json with appropriate (sqlite) npm package.
  • On terminal test the connections. (or dummy table updates.)

@pgev
Copy link
Contributor

pgev commented Jun 3, 2019 •
edited
Loading

https://www.npmjs.com/package/sqlite
https://www.npmjs.com/package/@types/sqlite3

https://hub.docker.com/r/nouchka/sqlite3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@abhayks1 @deepesh-kn @pgev