Postgres database

[jithendra945]

I tried to give postgres as given in the document.
But it is on my local system.

When i run it, it is giving 500 internal server error, could not connect to postgres server.

I can connect to postgres psql on my system but this project is not connecting.

Anyone know the solution ?

[sachinkbansal]

@jithendra945 we'll check and get back

[jithendra945]

ok, i will recheck with BigQuery.

Have youu checked with postgres as mentioned in https://cueobserve.cuebook.ai/installation Use Postgres as the application database.

[sachinkbansal]

I have created an issue for the postgres. External postgres works but there's an issue connecting to a local postgres server

[jithendra945]

and Sir, can you provide some detail Instructions on running the project after cloning the repo.
I want to check the Exception while running query.
I don't know Docker, so I'm not getting how to run it

[vikrantcue]

Hi @jithendra945,

We have created an issue to add the documentation for development on local machine #57.

Meanwhile to get you started with development here is a little guide you can follow:

1. Running the UI service:
Modify the api service for local development
Go to ui/src/services/api.js
And comment line number 8-9 and uncomment 4-5.
Then follow the following steps to start the react application:

cd ui
npm install 
npm start

This will start the UI service on port 3000.

2. Running the backend service

cd api

# Install virtualenv package if you don't have it installed already
pip install virtualenv 

# Create a new virtual environment
virtualenv -p python3 env

# Activate your newly created virtual environment
source env/bin/activate

# Install the dependencies for the project
pip install -r requirements.txt

# Modify .env.dev to have your local DB credentials and then source it to set all the environment variables
source .env.dev

# Migrate the database
python manage.py migrate

# Run django server
python manage.py runserver

This will start the django server on port 8000.

Now go to http://localhost:3000 and see if your UI is able to connect to the backend service on port 8000.

Let me know if you face any issues.

[jithendra945]

Thank you. Appreciate it.