Philosophy
The principles that shape Conduit
Why Conduit Exists
Building APIs over relational data has historically required a large amount of repetitive setup: models, controllers, serializers, routing rules, validation layers, pagination helpers, and error wrappers — all before exposing a single table.
Conduit removes this entire layer. Point it at a database, start the server, and your tables become fully‑typed REST endpoints instantly. No scaffolding. No code generation. No framework lock‑in.
Core Ideas
Conduit focuses on one job: exposing relational data as a predictable, multi‑format HTTP API. Everything else — business logic, workflows, decisions — belongs in your application.
Schema as Truth
The database schema drives routing, validation, column ordering, and serialization.
Zero Boilerplate
No models, controllers, routers, or serializers. Conduit generates CRUD endpoints automatically.
Predictable Behavior
Every table behaves consistently. Every format follows stable rules. Errors use a unified envelope.
Format Flexibility
JSON, XML, YAML, TOML, NDJSON, CSV, and CBOR are all first‑class citizens.
Database Agnostic
Works with SQLite, PostgreSQL, MySQL/MariaDB, SQL Server, and custom drivers.
Minimal Configuration
Conduit is configured through a simple file — no migrations or code generation.
Design Principles
Conduit’s internal architecture — decoder, router, service layer, encoder, and driver system — follows a set of guiding principles that ensure consistency and clarity.
- Minimal Surface Area: Conduit exposes only CRUD, schema, and multi‑format I/O.
- Deterministic Output: Column ordering and format rules are stable and predictable.
- Runtime Adaptation: Schema changes are reflected immediately without regeneration.
- Format‑Aware Serialization: XML trees, YAML mappings, TOML tables, NDJSON streams, CSV rows, and JSON objects follow format‑specific rules.
- Safe Fallbacks: When a payload cannot be represented as a row, Conduit falls back to raw JSON.
- Pluggable Authorization: Static config, environment tokens, and database‑backed auth.
- Driver Independence: Behavior stays consistent across all supported databases.
What Conduit Focuses On
Conduit is built for teams who want a clean, predictable API surface without the overhead of a full backend framework. It shines in:
- Internal tools and dashboards
- Rapid prototyping and MVPs
- Data pipelines and integrations
- Legacy system interoperability
- Multi‑format ingestion and export