mwufi / yuraresearchdatabase Goto Github PK

Do you want to help students find research? Want to get started with web development? Read the Getting Started below to learn more!

Testing branch deployed at https://yura-rdb-staging.herokuapp.com/

Prerequisites:

• You've installed npm
• You've installed postgres

1. Fork the repo on github
2. Do a git clone to get it onto your local computer
3. cd YURAResearchDatabase (change to the directory)
4. npm install

You won't see anything yet, but it's working. You just need to run the Postgres server as well:

In this repo, we've shipped a yurardb.dump file, which contains all the data.

In order to transform this file into a Hydrated, Fire-Breathing, Alive+Kicking database that LIves on a Server, we'll need to cast a full pg_restore spell.

1. Create a new database (since pg_restore doesn't do this for you)
   • createdb -T template0 yurardb_testing
2. Run the restore
   • pg_restore -d yurardb_testing yurardb.dump
3. Test it out
   • psql

Great! Now the last step is to configure the app to connect to your local postgres database. To do this, go to bin/localcn.js, and fill out the localcn.postgres object like this:

localcn.postgres = {
    host: 'localhost',
    port: 5432,
    database: 'yurardb_testing',
    user: '{your user}',
    password: '{your password}'
};

Now, you should be able to connect to your local postgres database!

To run your local instance of RDB, just do npm start and go to localhost:3000. We are working on a way to directly connect to the Heroku Postgres database.

More info to come - Stay tuned!

Hello friends.