Remote Storage

Remote PostgreSQL Adapter provides centralized database access through HTTP APIs, eliminating the need for each service instance to maintain its own connection pool. It's ideal for distributed environments and microservice architectures. Design for serverless environment.

Overview

The Remote Storage adapter allows you to separate your application from direct database connections by using a dedicated HTTP server as a proxy. This architecture provides better resource management, easier scaling, and simplified deployment in distributed systems.

Characteristics

• 🌐 Centralized Management - Unified database connection management
• 💾 Reduced Overhead - No connection pool maintenance on client side
• 🔄 Easy Scaling - Independent scaling of database access layer
• 🚀 Simple Deployment - Only HTTP connection required on client side
• 🐛 Debug Friendly - HTTP APIs are easy to debug and monitor

Architecture

Quick Start

1. Start Remote Server

Basic Setup

Create a server file server.ts:

Using Environment Variables

2. Configure Agent Side Connection

Method 1: Environment Variables

The system automatically recognizes:

• http:// or https:// prefix → Uses RemoteKyselyThreadsManager
• Other formats → Uses local PostgresAdapter