SlotSpher – Modern Scheduling Platform

SlotSpher Screenshot

Overview

SlotSpher is a modern scheduling and appointment booking platform inspired by Calendly.
It allows users to create event types, manage weekly availability, and share booking links for seamless scheduling—all built using a modern full-stack architecture.

Objectives

Simplify appointment scheduling and availability management
Provide a clean and intuitive booking experience
Enable secure authentication and user management
Offer real-time updates and booking insights

Key Features

✅ Secure authentication with Clerk
✅ Custom event types with flexible durations
✅ Weekly availability & time preference management
✅ Public booking pages for easy sharing
✅ Real-time booking updates
✅ Responsive UI for all devices
✅ Booking analytics and page view tracking

Tech Stack

Frontend: Next.js, React, Tailwind CSS, Shadcn UI
Backend: Next.js API Routes
Database: PostgreSQL (Neon)
ORM: Prisma
Authentication: Clerk
Deployment: Vercel

Getting Started

Prerequisites

Node.js 16+
npm or yarn
Neon PostgreSQL database
Clerk account

Installation

Clone the repository:

git clone https://github.com/omprakash2929/slotspher.git

Navigate to the project directory:
```
cd slotspher
```
Install dependencies:
```
npm install
```

Environment Variables

Create a .env file and add:

DATABASE_URL=your_neon_postgresql_connection_string

NEXT_PUBLIC_CLERK_PUBLISHABLE_KEY=your_clerk_publishable_key
CLERK_SECRET_KEY=your_clerk_secret_key

NEXT_PUBLIC_CLERK_SIGN_IN_URL=/sign-in
NEXT_PUBLIC_CLERK_SIGN_UP_URL=/sign-up

Database Setup

npx prisma migrate dev

Run the Application

npm run start

Database Schema

SlotSpher uses a relational schema with the following core models:

User – User profile and authentication data
Event – Event types created by users
Availability – Overall availability settings
DayAvailability – Day-wise time slots
Booking – Scheduled appointments

Use Cases

Personal scheduling and time management
Client and consultation bookings
Team availability sharing
SaaS-style scheduling platforms

SlotSpher