I’m planning a food delivery application using PHP and would like some advice on the backend architecture.
The application will have customers, restaurants, and delivery partners. Customers should be able to browse menus, place orders, make payments, and track their deliveries. Restaurants need to manage menus and update order statuses, while delivery partners should receive assigned orders and update delivery progress.
For a PHP-based application, what would be a good approach for designing the database and handling the order lifecycle? Would MySQL with a PHP framework be sufficient, or should I consider a different architecture for handling real-time order updates and a growing number of users?
I’d appreciate any recommendations from developers who have worked on similar multi-user applications.