Well
I decided to tick a bucket list item off, write an ebook about The Giant API Engine and take it out to the world and then today, I started a podcast. It's called The Practical Dev Show
When I started my journey with the PHP-CRUD-API (MIT Licenced) in September of 2022, I never thought it would come to this.
Anyway, this has been a journey and now we are evolving. But why call it The Giant API Engine?
Well, it's kinda huge, with these new controllers and middleware that have been added, on top of a brilliant piece of software by Maurits.
So what have we done?
AuthController.php - Handles user/admin authentication and account flows: login, registration, password reset/confirm, token refresh, change password, email verification/change, and basic CRUD for _admins and _users. It issues/validates tokens and coordinates email sends via MailController.
SettingsController.php - Exposes settings endpoints (GET/PATCH/POST) and a test-email endpoint. Maps the UI (PocketBase-style nested config) to internal flattened keys, persists env keys to .apienv and UI values to _params.
MailController.php - Central email sending logic. Sends via PHPMailer (SMTP) or native mail() (fallback), renders templates (verification, reset, email-change), and supports template previews.
EmailTestController.php - Small helper endpoints to test/preview email templates and flows (verification, reset, email-change) by calling MailController.
SseController.php - SSE & realtime management (subscribe/unsubscribe/publish/disconnect), lifecycle control (start, stop, hardStart, hardStop, status), and a setup route that ensures SSE tables exist. Coordinates with SseService/SseServer.
CollectionsController.php - Collection and schema management (list/create/read/update/delete), import collections, truncate, and synchronize DB tables with collection metadata.
FormDataController.php - CRUD endpoints for form-based record collections and file upload handling (store file, return data URL or URLs, retrieve file list).
SecureQueryController.php
Executes parameterized SQL queries sent in the request body (SELECT/DDL/DML). Uses prepared statements and returns rows/affected count — intended for admin/secure use.
StoredProcedureController.php - List/create/read/call stored procedures; can generate common stored-procedure templates (read/list/create/update/delete) and invoke procedures safely.
More is coming...
We've done...
And a Portal for Plug-n-Play (Bring your UI for your Back-End thought process)
#SharingTheGoodness
I decided to tick a bucket list item off, write an ebook about The Giant API Engine and take it out to the world and then today, I started a podcast. It's called The Practical Dev Show
When I started my journey with the PHP-CRUD-API (MIT Licenced) in September of 2022, I never thought it would come to this.
Anyway, this has been a journey and now we are evolving. But why call it The Giant API Engine?
Well, it's kinda huge, with these new controllers and middleware that have been added, on top of a brilliant piece of software by Maurits.
So what have we done?
AuthController.php - Handles user/admin authentication and account flows: login, registration, password reset/confirm, token refresh, change password, email verification/change, and basic CRUD for _admins and _users. It issues/validates tokens and coordinates email sends via MailController.
SettingsController.php - Exposes settings endpoints (GET/PATCH/POST) and a test-email endpoint. Maps the UI (PocketBase-style nested config) to internal flattened keys, persists env keys to .apienv and UI values to _params.
MailController.php - Central email sending logic. Sends via PHPMailer (SMTP) or native mail() (fallback), renders templates (verification, reset, email-change), and supports template previews.
EmailTestController.php - Small helper endpoints to test/preview email templates and flows (verification, reset, email-change) by calling MailController.
SseController.php - SSE & realtime management (subscribe/unsubscribe/publish/disconnect), lifecycle control (start, stop, hardStart, hardStop, status), and a setup route that ensures SSE tables exist. Coordinates with SseService/SseServer.
CollectionsController.php - Collection and schema management (list/create/read/update/delete), import collections, truncate, and synchronize DB tables with collection metadata.
FormDataController.php - CRUD endpoints for form-based record collections and file upload handling (store file, return data URL or URLs, retrieve file list).
SecureQueryController.php
Executes parameterized SQL queries sent in the request body (SELECT/DDL/DML). Uses prepared statements and returns rows/affected count — intended for admin/secure use.
StoredProcedureController.php - List/create/read/call stored procedures; can generate common stored-procedure templates (read/list/create/update/delete) and invoke procedures safely.
More is coming...
We've done...
And a Portal for Plug-n-Play (Bring your UI for your Back-End thought process)
#SharingTheGoodness