-
Notifications
You must be signed in to change notification settings - Fork 11
Databases
Song Zheng edited this page Sep 13, 2020
·
1 revision
A list of Database related items
A list of setup instructions for each database!
NOSQL database.
-
Installation Instructions - Install. Hint,
journalctl -u mongod.service
to show logs. - How to create admin user
- After creating an admin user (or after installation), you may encounter issues starting mongodb. Turns out to be a permissions issue. The linked problem statement is the same problem we had and the solution worked.
- In our codebase, we used the mongodb service.
Node-postgres click here to setup and perform queries on the tables.
id | username | password | dbpassword | email_confirmation | password_reset | databases (array?) | |
---|---|---|---|---|---|---|---|
1 | alopez | ##(COEAUO | mywonderful | alopez@wonder.net | raoheuroacheu4 | (empty) | mongodb,postgres |
2 | paul | ##(COEAUO | mywonderful | alopez@wonder.net | (empty) | (empty) | mongodb |
3 | kimong | ##(COEAUO | mywonderful | alopez@wonder.net | (empty) | (empty) | neo4j |
4 | song | ##(COEAUO | mywonderful | alopez@wonder.net | (empty) | (empty) | mongodb, neo4j, postgres |
-
id
: Primary key -
username
: string > 1 characters -
password
: Encrypted and salted with bcrypt -
dbpassword
: Stored in plain text string -
email
: Stored in plain text string -
email_confirmation
: -
password_reset
: token string encrypted by server secret. We encrypt it with user's email and expiration timestamp (24 hours) for security. -
databases
: comma separated string of the databases we support. To allow for unlimited growth, use TEXT data type.
Indexes - Create indexes on these columns to make lookups fast.
- email: users are logging in with email