Apex DB

Overview

The Apex DB connector provides type-safe read/write access to structured records across schemas. It is designed for high-throughput batch reads — API key auth with no OAuth2 dance, 200 req/sec rate ceiling, and cursor-based pagination handled transparently by the SDK.

Supported Resources

• Row data (by table / view)
• Schema metadata
• Query results (parameterized)
• Bulk record sets
• Change events (CDC stream)
• Aggregations
• Schema version history

Authentication

This connector uses API Key authentication. Pass the key via the X-Apex-Key header. Configure once at client creation:

import { dlx } from 'devloom';

const client = dlx.client({
  connector: 'apex-db',
  auth: dlx.auth.apiKey({
    header: 'X-Apex-Key',
    value: process.env.APEX_DB_API_KEY
  })
});

Querying Records

// Fetch all active records with auto-pagination
const records = await client
  .query('tables')
  .filter({ status: 'active' })
  .autopage()
  .all();

console.log(`Fetched ${records.length} records`);

Webhook Events

const sub = client
  .stream('tables.updated')
  .on('event', (e) => {
    console.log('Changed:', e.record.id);
  });

// Cleanup
sub.close();

Pagination

This connector uses Cursor-based pagination. The SDK handles it transparently — use .autopage() to fetch all pages or .limit(n) + .page(n) for manual control.