vam100000's Introduction

Vam100000 Project

Local setup

Create database and populate .env file
Run npm install

npm i

Run migrations and seed data

 npx knex migrate:latest
 npx knex seed:run

To run project locally use

npm run start

Running tests

create test db and populate env
Run migrations using

npx knex migrate:latest --env test

Run tests

npm run test

Performance

Only count endpoint can become bottleneck. Tested it with 10 Lac patients data and response time is close of 65ms. To test, run seed first it will add 10 Lac patients data. Then run endpoint and count time or use below query in psql.

explain analyse
select count(*)
from patients p
where p.weight_kg / ((p.height_cm ^ 2) / 10000) >= 25
  and p.weight_kg / ((p.height_cm ^ 2) / 10000) < 30;

Deployment

Added Github workflow to deploy this app, rename file .github/workflows/deploy.yml.example to .github/workflows/deploy.yml
Add server's ssh key to Github's deploy keys
Create new pair of SSH keys and add private to Github secret with name SSH_KEY and add public key to the server's authorized keys
Add server's IP to Github secret's using name SERVER_IP
Github will automatically deploy to the server on every commit to master.

Nginx config

limit_req_zone $binary_remote_addr zone=ip:10m rate=5r/s;
server {
    server_name example.com;
    listen  80;
    gzip on;
    gzip_types      text/plain application/json;
    gzip_min_length 128;
    client_max_body_size 1M;
    
        location / {
            proxy_set_header   X-Forwarded-For $remote_addr;
            proxy_set_header   Host $http_host;
            proxy_pass         http://127.0.0.1:4000;
            limit_req zone=ip burst=12 delay=8;
        }
}

Recommend Projects