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/

Getting Started

Running a local copy of RDB

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:

Setting up the database

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!

Running the server

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!

Hi Peter