Skip to content

Backend for my Photoarc (Instagram clone) App created in node.js, Postgres SQL, express, and cloudinary storage.

Notifications You must be signed in to change notification settings

Ansh-Rathod/Photoarc-app-backend-nodejs

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

53 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PHOTOARC APP BACKEND

Requirements

  • postgresql installed.
  • Cloudinary account.
  • node js version 12.0x +

This is the Backend of the Photoarc app. You need to follow some steps to work on this API.


  • Clone this repository to your local machine.
  • Remove "engines": { "node": "17.x" } line in package.json file.
  • create a new .env file in root of your folder.
  • Go to Cloudinary and choose first sign up for free or whatever you want. Basically, Cloudinary is a platform where we are going to store our posts and profile images.
    • follow this step to complete cloudinary setup.
    • fill the sign-up form and you will receive an email. complete further steps.
    • now go to the dashboard and copy your Cloud Name, API Key, and API Secret.
    • and paste into your .env file.
DATABASE_URL=<Postgres SQL connection string>,
CLOUD_NAME=<Cloud Name>,
API_KEY=<API Key>,
API_SECRET=<API Secret>

Now open up a terminal and install some node packages with the below command.

npm install

connect your psql(postgres sql terminal) to your database and run following query

  • frist create an appusers table by running this query to your psql.
     CREATE TABLE appusers (
      id varchar(255) NOT NULL UNIQUE PRIMARY KEY,
      username varchar(255) NOT NULL,
      name varchar(255) NOT NULL,
      bio TEXT,
      avatar_url varchar(255),
      url varchar(255),
      followers_count INTEGER NOT NULL,
      following_count INTEGER NOT NULL,
      posts_count INTEGER NOT NULL,
      created_at TIMESTAMP NOT NULL
    );
  • run this one to create an sql function to get user feed posts.

    create or replace function get_feed(
      _tbl regclass
    )
       returns table (
           new_post_id varchar,
           new_post_image_url text,
           new_caption text,
           new_user_id varchar,
           new_posted_at timestamp,
           new_likes text[],
           new_username varchar,
           new_name varchar,
           new_avatar_url varchar,
           new_width int,
           new_height int
       ) as $$
     declare
     var_r record;
    
    begin
      for var_r in
         execute 'SELECT * FROM '|| _tbl
      loop return query execute 'select post_id,post_image_url,caption,user_id,posted_at,likes,username,name,avatar_url,width,height from ' || quote_ident(var_r.following_id)||'posts
          left join appusers ON '|| quote_ident(var_r.following_id) ||'posts.user_id = appusers.id order by posted_at desc limit 5;';
    
       end loop;
    
    end;
    $$ language plpgsql;
  • run another query to get trending posts

    create or replace function get_search_posts()
       returns table (
           new_post_id varchar,
           new_post_image_url text,
           new_caption text,
           new_user_id varchar,
           new_posted_at timestamp,
           new_likes text[],
           new_username varchar,
           new_name varchar,
           new_avatar_url varchar,
           new_width integer,
           new_height integer
       )
    
     as $$
     declare
     var_r record;
    
    begin
      for var_r in
         execute 'SELECT * FROM appusers order by created_at desc limit 100;'
      loop return query execute 'select post_id,post_image_url,caption,user_id,posted_at,likes,username,name,avatar_url,width,height from ' || quote_ident(var_r.id)||'posts
          left join appusers ON '|| quote_ident(var_r.id) ||'posts.user_id = appusers.id order by posted_at desc limit 5;';
    
       end loop;
    
     end;
    $$ language plpgsql;

Now you can test this API on your localhost:300/api/v1/ by running following command.

npm run dev

Documentation link Photoarc Backend API (getpostman.com)

About

Backend for my Photoarc (Instagram clone) App created in node.js, Postgres SQL, express, and cloudinary storage.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published