DressAPI

How It Works

1. Design Your Database

Use standard SQL with simple naming conventions. Prefix foreign keys with id_ for auto-detection. Use *_img for images, *email* for email fields, and *password* for password hashing.

2. Install DressAPI

One Composer command is all you need. Set your database credentials in config.php and point your web server to the www/ directory.

3. Your API is Ready

Full CRUD operations, JWT authentication, role-based ACL, smart caching, pagination, filtering, and sorting are all available out of the box.

Quick Example

Your SQL Table

-- Just standard SQL CREATE TABLE product ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(120) NOT NULL, price DECIMAL(10,2) NOT NULL, id_category INT UNSIGNED, product_img VARCHAR(255), description TEXT, FOREIGN KEY (id_category) REFERENCES category(id) );

Auto-Generated Endpoints

GET /product # List all GET /product/42 # Read one GET /product/full # With relations POST /product # Create PUT /product/42 # Update DELETE /product/42 # Delete GET /product/ob/price-DESC # Sort GET /product/p/1,10 # Paginate GET /product/name~shirt # Filter

Key Features

Zero-Code CRUD

Automatic REST endpoints generated from your database schema. No boilerplate code needed.

Multi-Database

Support for MySQL, PostgreSQL, Oracle, and SQL Server with a dynamic ORM that reads structure at runtime.

Smart Cache

File-based or Redis caching with automatic invalidation on data changes. Lazy DB connection avoids overhead.

Auth + ACL

JWT authentication with role-based access control and fine-grained permissions per module and role.

Multi-Frontend

CMS with Bootstrap 5, or use as API backend for Vue, React, Angular, and Ajax frontends.

Auto Relations

Automatic management of table relationships, including many-to-many (crosstable). Foreign keys are resolved with /full.

Template Engine

Twig-like syntax with binding, modifiers, and modular page frames.

Multi-Language

Built-in translation with _T() function and auto-learning mode that detects new strings automatically.

Installation

Get started in seconds with Composer:

$ composer require dressapi/core

For the CMS: composer require dressapi/cms — For APIs only: composer require dressapi/api

Requirements: PHP 8.2+, Apache or Nginx, MySQL or MariaDB.

View on GitLab Tutorials

Dress your Database and get a full REST API.