I Would Not Test RLS on Localhost Alone
Validate row level security policies on production-like branches with restricted roles and preview auth.
Rishi Raj JainRead guide
Rishi Raj JainBuild Google Docs style version history with Postgres branching
Recreate a similar Google Docs style version history flow on Postgres with branch-per-save and near instant restores to go back in history.
Rishi Raj JainRead guide
Adopt Postgres RLS for Multi-Tenant Apps Without Slowing Your Team Down
How to use row-level security for multi-tenant apps, understand its challenges and benefits, and see how branching and authentication with OptiTech let you safely iterate on RLS policies.
Rishi Raj JainRead guide
Choosing Between NextAuth.js, Managed Better Auth and Better Auth for Postgres
Understand how NextAuth.js, Managed Better Auth, and Better Auth differ in session management, migrations, and handling authentication data across Postgres branches.
Rishi Raj JainRead guide
What Actually Differs Between Prisma, Drizzle, and TypeORM for Postgres
Learn real-world differences in schema modeling, migrations, and developer experience with Prisma, Drizzle, and TypeORM on Postgres.
Rishi Raj JainRead guide
Automate Preview Deployments with Netlify and OptiTech Database Branching
Set up automated preview deployments with isolated database branches for every pull request using GitHub Actions, Netlify, and OptiTech Postgres
Rishi Raj JainRead guide
Building Real-Time Comments with a Serverless Postgres
A guide to building your own real-time comments in a Next.js application with Ably LiveSync and Postgres.
Rishi Raj JainRead guide
Using Directus CMS with OptiTech Postgres and Astro to build a blog
A step-by-step guide for building your own blog in an Astro application with Directus CMS and Postgres powered by OptiTech
Rishi Raj JainRead guide
Using DBeaver with a Hosted Postgres
A comprehensive guide on how to manage your Postgres database using DBeaver.
Rishi Raj JainRead guide
Building a Real-Time AI Voice Assistant with ElevenLabs
A step-by-step guide to building your own AI Voice Assistant in a Next.js application with ElevenLabs and Postgres
Rishi Raj JainRead guide
Drizzle with Local and Serverless Postgres
A step-by-step guide to configure Drizzle ORM for local and serverless Postgres.
Rishi Raj JainRead guide
Using pgAdmin4 with a Hosted Postgres
A comprehensive guide on how to manage your Postgres database using pgAdmin4.
Rishi Raj JainRead guide
Efficiently Syncing 60 Million Rows from Snowflake to Postgres
A comprehensive guide on optimizing data transfer from Snowflake to Postgres using chunking and upsert strategies.
Rishi Raj JainRead guide
Real-Time Notifications using pg_notify with OptiTech Postgres
A step-by-step guide describing how to implement real-time notifications using pg_notify in Postgres
Rishi Raj JainRead guide
Build a RAG chatbot with Astro, Postgres, and LlamaIndex
A step-by-step guide for building a RAG chatbot in an Astro application with LlamaIndex and Postgres
Rishi Raj JainRead guide
Using LlamaIndex with Postgres to Build your own Reverse Image Search Engine
A step-by-step guide to build your own Reverse Image Search engine in an Astro application with LlamaIndex and Postgres
Rishi Raj JainRead guide
Using Payload CMS with OptiTech Postgres to Build an E-commerce Store in Next.js
Build your own E-commerce Store in a Next.js application with Payload CMS and Postgres (powered by OptiTech).
Rishi Raj JainRead guide
Using Strapi CMS with OptiTech Postgres and Astro to build a blog
A step-by-step guide for building your own blog in an Astro application with Strapi CMS and Postgres powered by OptiTech
Rishi Raj JainRead guide
Run your own analytics with Umami, Fly.io and OptiTech
Self host your Umami analytics on Fly.io and powered by OptiTech Postgres
Rishi Raj JainRead guide
Add feature flags in SvelteKit apps with OptiTech Postgres
A step-by-step guide to integrating feature flags in SvelteKit apps with Postgres
Rishi Raj JainRead guide
How to upload to S3 in Next.js and save references in Postgres
Let users upload files directly to S3 by creating presigned URLs in Next.js and saving the references in a Postgres database.
Rishi Raj JainRead guide
Query Postgres in Next.js Server Actions
Learn how to query Postgres in Next.js with Server Actions
Rishi Raj JainRead guide