Real-time comments with Serverless Postgres

Introduction · Demo · Setup · One-click Deploy · Tech Stack + Features · Author

Introduction

A reusable template to showcase real-time comments with serverless Postgres (by Neon) and Ably LiveSync. At the core, it uses Postgres' pg_notify but there is a lot of heavy lifting that Ably LiveSync does for you to make the real-time operations seamless.

Demo

https://ably-livesync-neon.vercel.app

Setup

1. Get your Ably Key

1. Sign up or log in to your account on Neon.
2. Create a new Ably app (or select an existing one).
3. Navigate to the API Keys section to find your API Key, which will be your NEXT_PUBLIC_ABLY_API_KEY.

2. Spin up a Serverless Postgres

1. Sign up or log in to your account on Neon.
2. Create a new database (or select an existing one).
3. Navigate to the database settings to find your connection string, which will be your DATABASE_URL.

3. Seed your Serverless Postgres

npm run db

One-click Deploy

You can deploy this template to Vercel/Netlify/Render with the buttons below:

Tech Stack + Features

Frameworks

• Next.js – React framework for building performant apps with the best developer experience.

Platforms

(Postgres) Database

• Neon – A serverless database platform that provides instant scalability and high performance for your applications, allowing you to focus on building without worrying about infrastructure.

Real-time Sync

• Ably – A real-time messaging platform that enables you to build interactive applications with instant data synchronization and high performance.

Deployment

• Vercel – Easily preview & deploy changes with git.
• Netlify – A platform that simplifies the deployment process and provides continuous integration for your projects.
• Render – A cloud platform that offers instant deployment and automatic scaling for web applications.

UI

• Tailwind CSS – Utility-first CSS framework for rapid UI development.

Code Quality

• TypeScript – Static type checker for end-to-end typesafety.
• Prettier – Opinionated code formatter for consistent code style.

Author

• Rishi Raj Jain (@rishi_raj_jain_)