Database adapters

Map public column IDs to database fields and explicitly enable search, filtering, sorting, facets, and aggregation. Never accept table or field identifiers from a request.

Use native PostgreSQL, MySQL, or SQLite adapters for SQL control; Knex for query-builder portability; or Prisma for an injected model.

Provide a primary key and secret for signed keyset cursors. Editor-option loaders and multipart upload handlers reuse the same authorization boundary.

This recipe focuses on the integration pattern. Replace application-specific values and callbacks with your own data and services.

const database = createDataTablePostgreSqlAdapter({
  client: pgPool,
  table: 'people',
  primaryKey: 'id',
  cursorSecret: process.env.CURSOR_SECRET,
  columns: [
    { id: 'name', field: 'name', facet: true },
    { id: 'score', field: 'score', type: 'number' }
  ]
});