This documentation will walk you through the steps to run Openspace Express application with Postgres and PostGIS.
Before getting started, make sure you have the following installed on your system:
- Node.js (https://nodejs.org/en/download)
- PostgreSQL (https://www.postgresql.org/download/)
- DBeaver (https://dbeaver.io/download/)
Clone the repository:
git clone https://github.com/OpenSpace/Backend-WebRTC.gitNavigate to the project directory and install the required dependencies using npm.
cd Backend-WebRTC
npm installCreate a new PostgreSQL database Follow this medium article to setup postgres and dbeaver in windows: https://medium.com/@zum.hatice/how-to-create-a-postgresql-db-and-connect-in-windows-b26eaa48c7fb
-
Add the postgres bin path to your env variables
C:\Program Files\PostgreSQL\17\bin -
Open CMD and run
psql -U postgres, enter the password you set during postgres installation -
Make sure you have performed below command while setting up postgres and dbeaver.
createdb -U <username> <dbname>
createdb -U postgres openspace
it will ask for the password, enter the password you set during postgres Open the .env file in the project directory and update the database connection details as required.
DB_HOST=localhost
DB_PORT=5432
DB_NAME='openspace'
DB_USER='postgres'
DB_PASSWORD='password'node seed.jsStart the Express application using the following command:
npm startOpen the postman (or any API management tool) and access APIs at http://localhost:5000, where 5000 is the default port specified in the backend express application.
For more help, reach out to our developers Abhay Garg, Sonia Castelo, Gene Payne on Slack.
user analytics, server analytics