Backend & Data
Databases, APIs, server-side frameworks, and data management tools.
58 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 Documentation Tools: Postman, Stoplight, ReadMe, Apidog, Mintlify, Bruno, Insomnia, Hoppscotch
If you're building a SaaS in 2026 with a public API, this is the consolidated comparison for API documentation + developer-experience tooling. API docs are t...
API Gateway Providers: Kong, Tyk, AWS API Gateway, Cloudflare, Zuplo, KrakenD, Apigee, Gravitee
If you're building a SaaS in 2026 and trying to pick an API gateway, this is the consolidated comparison. API gateways are the line item founders skip until ...
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...
Background Jobs and Queues: Inngest, Trigger.dev, Vercel Queues, Vercel Workflow, Upstash QStash, BullMQ, Temporal, Hatchet
If you're building a SaaS in 2026 and need to run code that doesn't fit in a single HTTP request — async webhooks, scheduled jobs, long-running AI generation...
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 Observability Platforms: Monte Carlo, Bigeye, Anomalo, Soda, Datafold, Acceldata, Lightup, Metaplane
If you're a B2B SaaS at $20M+ ARR with a real data team (analysts + data engineers + a warehouse), data quality issues become expensive — wrong dashboards in...
Data Pipeline & ETL Platforms: Fivetran, Airbyte, Stitch, Estuary, Meltano, Matillion, dlt, Portable
If you're building a data stack in 2026 and need to move data from operational systems (Postgres, MongoDB, Salesforce, HubSpot, Stripe, Shopify, etc.) into a...
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 ...
Data Warehouse & Lakehouse Providers: Snowflake, BigQuery, Redshift, Databricks, DuckDB, ClickHouse, Motherduck, Tinybird
If you're building a SaaS in 2026 and your analytics queries are starting to slow down the production database, this is the consolidated comparison. Data war...
Database GUI Tools: TablePlus, Postico, DataGrip, DBeaver, pgAdmin, Beekeeper Studio, Arctype
If you're building a B2B SaaS in 2026, you'll spend hours in a database GUI — querying production read-replicas, debugging issues, exploring data, running ad...
Database Migration Tools: Drizzle Kit, Prisma Migrate, Atlas, Sqitch, Flyway, Liquibase, Knex, golang-migrate
If you're building a SaaS in 2026 and your schema needs to evolve safely, this is the consolidated comparison. Migrations are the line item founders skip unt...
Database Providers: Supabase, Neon, PlanetScale, Turso, Convex, Crunchy Bridge, Cloudflare D1
If you're building a SaaS in 2026 and trying to pick where your data lives, this is the consolidated decision guide. The OLTP database is a 5–10 year commitm...
Database Setup (Supabase/Postgres)
Have this link open and ready to copy/paste in: `0-learn/supabase-database-patterns.md`
Document Parsing & OCR Services: AWS Textract, Google Document AI, Azure Form Recognizer, Unstructured, Mathpix, Reducto, LlamaParse
If you're building a B2B SaaS in 2026 that handles PDFs, scanned documents, invoices, contracts, receipts, or general unstructured content — for RAG, documen...
Drizzle vs Prisma
Compare Drizzle ORM and Prisma for TypeScript apps. Bundle size, edge runtime support, query syntax, migrations, and when each ORM wins.
Email Providers for SaaS
Picking an email provider for a SaaS in 2026 means picking across three distinct shapes of product: **transactional senders** (Resend, Postmark, SES) for hig...
Inbound Email Parsing & Routing APIs: Mailgun Routes, SendGrid Inbound Parse, Postmark Inbound, CloudMailin, AWS SES Inbound, Mailpit
If your SaaS needs to **receive emails** programmatically — turning incoming emails into structured webhook calls your app can process — you need an inbound ...
Inventory & Order Management Systems: NetSuite, Brightpearl, Cin7, Finale Inventory, Linnworks, Zoho Inventory, Veeqo, ShipBob OMS
If you're a B2B SaaS that sells physical goods or supports e-commerce customers — direct-to-consumer, B2B wholesale, multi-channel retail, manufacturing — yo...
IP Geolocation Providers: MaxMind, ipinfo, IPGeolocation, ipapi, AbstractAPI, ipdata, IP2Location, ipify
If you're shipping a SaaS in 2026, you'll eventually need to know where users are coming from — for fraud detection (login from new country), regional pricin...
Machine Translation APIs: DeepL, Google Translate, AWS Translate, Azure Translator, OpenAI / Claude, Lilt, ModernMT
If you're building a B2B SaaS in 2026 that needs real-time text translation — translating user-generated content, AI chat responses, in-product strings on de...
Maps & Geocoding APIs: Google Maps, Mapbox, HERE, Radar, MapTiler, TomTom, OpenStreetMap
If you're building a SaaS that touches addresses, locations, routing, or maps, you need a maps + geocoding API. The naive approach: copy/paste a Google Maps ...
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...
Notification Providers: Knock, Courier, Twilio, OneSignal, Novu, Resend, Plivo, MessageBird
If you're building a SaaS in 2026 and you need to send notifications to your users — email, SMS, push, in-app, Slack/Teams — this is the consolidated compari...
OpenAPI
The OpenAPI Specification (formerly known as Swagger) is a standardized format for describing, producing, consuming, and visualizing RESTful APIs. In VibeRef...
PDF & Document Generation Tools: Puppeteer, Playwright, react-pdf, DocRaptor, Documenso, PDFMonkey, Carbone, Gotenberg
If you're building a SaaS in 2026 and need to generate PDFs (invoices, contracts, reports, certificates, exports), this is the consolidated comparison. PDF g...
PostgreSQL
PostgreSQL (often called "Postgres") is an advanced, enterprise-class database system with over 30 years of active development. Key features include:
Realtime & WebSocket Platforms: Pusher, Ably, PubNub, Liveblocks, PartyKit, Supabase Realtime, Soketi, Hocuspocus
If you're building any product feature that needs sub-second update propagation in 2026 — live notifications, collaborative cursors, presence indicators, cha...
Resend
Resend provides a modern, developer-friendly platform for sending emails, offering:
Reverse ETL Providers: Hightouch, Census, Polytomic, Grouparoo, RudderStack, Workato
If you're shipping a SaaS in 2026 with a data warehouse (Snowflake / BigQuery / Databricks / Redshift) and you need that data in operational tools (Salesforc...
Scheduling & Booking APIs: Calendly, Cal.com, Acuity, Nylas, SavvyCal, GReminders, Microsoft Bookings
If you're building a SaaS that needs to coordinate appointments — sales demo bookings, customer calls, support sessions, in-product scheduling — you have two...
Search Providers: Algolia, Typesense, Meilisearch, Elasticsearch, OpenSearch, Postgres FTS, Pinecone-for-Search
If you're building a SaaS in 2026 and your product needs search — full-text search across docs, search across customer-uploaded data, in-app search across us...
Shipping & Fulfillment APIs: ShipEngine, EasyPost, Shippo, Shipwell, Sendle, Stamps.com, ShipStation
If you're building any e-commerce, marketplace, returns management, or physical-product B2B SaaS in 2026, you'll need to integrate with carriers (USPS / UPS ...
SMS & Voice APIs: Twilio, Plivo, Vonage, MessageBird, Sinch, Telnyx, Bandwidth
If your B2B SaaS in 2026 needs to send SMS (verification codes, alerts, reminders) or make/receive phone calls (IVR, click-to-call, contact center), you need...
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...
Synthetic Data Generation Platforms: Tonic, Mostly AI, Gretel, Hazy, Snaplet, Synthesized, K2View, MDClone
If you need realistic-but-fake data — for testing, demos, ML training, dev environments, regulatory compliance, or sharing data without exposing PII — synthe...
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.
Time-Series Database Providers: InfluxDB, TimescaleDB, ClickHouse, QuestDB, Prometheus, Druid, Timestream, ScyllaDB
If you're storing metrics, IoT data, financial ticks, log aggregations, observability data, or any append-heavy time-stamped data in 2026, you need a time-se...
Unified API & Embedded Integration Providers: Merge.dev, Finch, Nango, Apideck, Paragon, Workato Embedded
If your SaaS needs to read or write data from your customers' SaaS tools (their CRM, their HRIS, their accounting system, their ATS), you face a choice in 20...
Vector Database Providers
Picking a vector database for a production AI app in 2026 is a different decision than it was in 2023. The "use Pinecone because it exists" default has been ...
Vector Databases
A vector database stores, indexes, and queries high-dimensional vectors — numerical representations of text, images, audio, or any unstructured data. They po...
Video & Voice Conferencing APIs: Daily, LiveKit, Twilio Video, Zoom SDK, Agora, 100ms, Stream, Vonage
If you're building telehealth, online tutoring, customer support video, virtual events, or any in-product real-time video / voice feature in 2026, you need a...
Webhook Delivery Services: Hookdeck, Svix, Inngest, ngrok, Webhook.site, Convoy, EventBridge
If you're building a SaaS in 2026 and either sending webhooks to customers or receiving webhooks from third parties, this is the consolidated comparison for ...
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: