I'm building a public transit service in South Africa, and I initially started the project on PHP and MySQL. I've managed to get far with the simple stack, with:
- Routing algorithm in PHP
- Data storage as coordinates in MySQL
- front-end in WordPress
- JS for Google Maps and a REST API for mobile apps (incomplete)
My question based on the above is: I want to move away from using PHP in the back-end, and I'd like to know what alternatives there are.
I'm fairly inexperienced, and used PHP as it's the only server-side language that I currently know. I've seen that a lot of map/routing applications use Java and Python, and am thinking of moving in that direction in future.
I'm finding myself having to do a lot of geographic calculations, and as my data grows I find myself reinventing the wheel. Would a PostGIS + PgRouting setup benefit me?