Python / Fast API from PHP

I have a project where I am converting a PHP-based web application to a Python-based API system with FastAPI.

The old server has a MySQL database on it the new infrastructure will use Supabase. For a variety of reasons we will not be able to completely import the MYSQL database into Supabase, as a result when certain API calls to FastAPI are made we will need to query (via read-only access) the current MySQL database and copy those pieces of information to the new SupaBase database.

Most of the PHP scripts that need to be converted to Python and made callable via FastAPI involve importing CSV/txt files, extracting data, and processing it in specific ways. In some cases merging it with data from the Supabase tables (or the MySQL database if it doesn’t yet exist in the Supabase Database) then saving into a seperate supabase table based on criteria from the initial data iteself.

Example code for the FastAPI sever built on Replit has already been built, just need help getting it over the finish line. Expect this project to take 2-3 weeks at most.

Key Deliverables:
– Secure FastAPI server completed with endpoints ready to go for import, analysis, and new user functions (Supabase authentication token will need to passed).
– For all endpoints there should be two iteration, streaming and none, there are certain data analysis and import functions that take some time given the type/size of data we are processing (allowing proress bars/status updates on the user interface).
– Clear well written readme for how to add new endpoints, security structure, and the overarching FastAPI file schema.
– Step by step process to enable, in a secure way, read only access to the existing MySQL database via API call from the Replit FastAPI server. The MySQL database is located on a custom Apache server running on FreeBSD.
– Two import scripts converted to Python/Supabase from PHP/MySQL (core logic – not direct conversion)
– Five report generation scripts converted to Python/Supabase from PHP/MySQL (core logic – not direct conversion).

Please feel free to ask questions and get a better understanding of the project scope/structure.