Backend & Data
Databases, APIs, server-side frameworks, and data management tools.
28 topics
What this section covers
Backend work used to be the boring half. With AI apps, it's where the interesting problems live: persisting conversations, retrieving embeddings, orchestrating webhooks, and making sure your agent can remember what happened yesterday. This section covers the data and server layer that sits behind a modern vibe-coded app. You'll find detailed references on Supabase and Convex as full-stack backends, Postgres and SQL as the durable foundation, vector databases for retrieval, plus webhook patterns, API design, and n8n for workflow automation. There are also dedicated pages on AI memory systems — both the comparison landscape and a Convex-specific tutorial — because long-lived agent memory is quickly becoming a first-class backend concern. This section is aimed at developers who need something sturdier than a local JSON file and want to pick a backend that will survive their first 1,000 users without a rewrite.
API Development
Application Programming Interfaces (APIs) are a crucial component of modern web applications, allowing different software systems to communicate with each ot...
API Integration
API integration is the process of connecting different software systems through their application programming interfaces (APIs) to enable data exchange and f...
AWS SES (Simple Email Service)
Amazon Simple Email Service (SES) is a cloud-based email sending service designed to help digital marketers and application developers send marketing, notifi...
Build AI Memory with Convex — No New Vendors
A step-by-step tutorial for adding persistent AI memory to your Convex app using vector search, Actions, and OpenAI embeddings — no Mem0, Zep, or extra infrastructure required.
Convex
Convex gives you a backend where:
Convex Diagnostics System Documentation
The Convex Diagnostics System is a comprehensive health check and monitoring solution for the SarahsRecipes.ai application's Convex database integration. It ...
Convex Setup Workflow: Bridging v0 and Local Development
This document explains the workflow for setting up Convex in a v0 project, which requires a hybrid approach between v0's web-based development environment an...
Cost Optimization: Batch Processing and Prompt Caching with Claude
Running Claude at scale gets expensive fast if you're not deliberate about how you use the API. The good news: Anthropic provides two built-in mechanisms — t...
Data Processing and Analysis with Claude
Claude handles data transformation, cleaning, analysis, and insight generation through natural language instructions. Instead of writing one-off scripts for ...
Database Setup (Supabase/Postgres)
Have this link open and ready to copy/paste in: `0-learn/supabase-database-patterns.md`
Drizzle vs Prisma
Compare Drizzle ORM and Prisma for TypeScript apps. Bundle size, edge runtime support, query syntax, migrations, and when each ORM wins.
Middleware
Middleware in Next.js is a powerful feature that allows you to run code before a request is completed, enabling request manipulation, authentication checks, ...
n8n
n8n (pronounced "n-eight-n") is an extendable workflow automation platform that allows you to connect different services and systems, enabling them to commun...
Next.js API Routes
Next.js API routes let you build backend API endpoints within your Next.js application. They run server-side and are ideal for handling form submissions, dat...
OpenAPI
The OpenAPI Specification (formerly known as Swagger) is a standardized format for describing, producing, consuming, and visualizing RESTful APIs. In VibeRef...
PostgreSQL
PostgreSQL (often called "Postgres") is an advanced, enterprise-class database system with over 30 years of active development. Key features include:
Resend
Resend provides a modern, developer-friendly platform for sending emails, offering:
SQL (Structured Query Language)
SQL is the standard language for interacting with relational databases like PostgreSQL, which forms the backbone of your Supabase implementation in VibeRefer...
SQL Migration
SQL migrations are a way to manage and version control changes to your database schema over time. They provide a structured approach to evolve your database ...
Supabase
Supabase combines several powerful open-source tools into a developer-friendly platform:
Supabase Database Migrations Guide
This guide walks you through setting up and managing database migrations for your Supabase project using the Supabase CLI.
Supabase Database Patterns
This document outlines the recommended database patterns and best practices for implementing Supabase in your Next.js application, organized by migration phase.
Supabase vs Convex
Supabase and Convex are both backend platforms that solo founders use to ship SaaS products fast, but they make fundamentally different bets. Supabase wraps ...
Swagger in VibeReference
Swagger (now known as the OpenAPI Specification) is a powerful set of tools for documenting and consuming RESTful APIs. It provides a standardized way to des...
The Best AI Memory Systems for Solo Founders (2026 Comparison)
A hands-on comparison of the top AI memory systems — Mem0, Zep, Cloudflare Agent Memory, LangGraph, and Letta — with pricing, integration complexity, and recommendations by app type.
Vector Databases
A vector database stores, indexes, and queries high-dimensional vectors — numerical representations of text, images, audio, or any unstructured data. They po...
Webhooks
Webhooks are user-defined HTTP callbacks that are triggered by specific events in a source system and sent to a destination URL. In VibeReference application...
Xano
Xano provides a complete backend stack without writing backend code: