Vibe 🚀

Vibe is a social media web app created using Next.js 14, Neon's serverless driver, and Clerk.
Deployed at: vibe.ambe.dev.

Features

• User registration and login: users can create an account and login to the website.
• Creating, reading, updating, and deleting posts: users can create posts, read posts from other users, edit or delete their own posts, and mention others in their posts (new).
• Comments and likes: users can like and comment on posts, and add reactions (new).
• Profile page: users can see their own and others' profile page.
• Following other users: users can follow others and see their posts in the "Following" feed.
• Notifications: users get notified when someone likes their post or follows them.
• Responsive design: the website is built with a beautiful mobile first design, which also works on larger desktop monitors.

Setup Locally

1. Run the following command to copy the application's code.

   git clone https://github.com/ammarmbe/vibe/
   

2. Create a .env.local file in the root directory.

3. Create a Neon account, create a new database and add the DATABASE_URL to the .env.local file.

4. Setup Clerk, add the NEXT_PUBLIC_CLERK_PUBLISHABLE_KEY and CLERK_SECRET_KEY to the .env.local file.

5. Add the following to the .env.local file:

   NEXT_PUBLIC_CLERK_AFTER_SIGN_UP_URL=/
   NEXT_PUBLIC_CLERK_SIGN_IN_URL=/sign-in
   NEXT_PUBLIC_CLERK_SIGN_UP_URL=/sign-up
   NEXT_PUBLIC_CLERK_AFTER_SIGN_IN_URL=/
   NEXT_PUBLIC_URL=http://localhost:3000
   

6. Generate NEXT_PUBLIC_VAPID_PUBLIC_KEY and VAPID_PRIVATE_KEY, and add them to the .env.local file (for push notifications).

7. Run the queries in the Database Schema in your database.

8. Run pnpm install then pnpm dev in the root directory to start a local development server.

Tech Stack

Next.js, Neon's serverless driver (PostgreSQL), Clerk, React Query, TailwindCSS.
Shadcn/ui is used for the popover and dialog components and the CSS variables.

Deployed on Vercel and Neon.

Database Schema

CREATE TABLE follower_relation (
    follower character varying(200) NOT NULL,
    following character varying(200) NOT NULL
);

CREATE TABLE likes (
    userid character varying(200) NOT NULL,
    postid integer NOT NULL,
    type character varying(10)
);

CREATE TABLE notifications (
    id SERIAL NOT NULL,
    type character varying(200) NOT NULL,
    notifier character varying(200) NOT NULL,
    notified character varying(200) NOT NULL,
    read boolean DEFAULT false NOT NULL,
    createdat timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    postid integer
);

CREATE TABLE posts (
    id SERIAL NOT NULL,
    userid character varying(200) NOT NULL,
    parentnanoid character varying(12),
    nanoid character varying(12) NOT NULL,
    createdat timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    deleted boolean DEFAULT false NOT NULL,
    edited boolean DEFAULT false NOT NULL,
    content text NOT NULL
);

CREATE TABLE reposts (
    userid character varying(200) NOT NULL,
    postid integer NOT NULL,
    createdat timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE subscriptions (
    userid character varying(200) NOT NULL,
    subscription json NOT NULL
);

CREATE TABLE users (
    id character varying(200) NOT NULL,
    name character varying(250) NOT NULL,
    bio character varying(250),
    username character varying(32),
    email character varying(250) NOT NULL,
    image character varying(250) NOT NULL
);

License

MIT