I've taken a break from software development for a while and want to build a simple CRUD app. This app will support different user roles—some users will have full CRUD permissions while others will only have read or read-update access. The app aims to manage a small fleet of vehicles, handling things like maintenance schedules and notes for drivers and mechanics. The last application I worked on was built many years ago using PHP and MySQL, and I'm unsure what stack to use now.
5 Answers
There's no one-size-fits-all answer; different people might suggest different stacks. You could consider options like Single Page Apps using React or Next.js, or server-side solutions like Django.
The backend part of CRUD is usually straightforward with many patterns available, but the front end can get tricky. Try out popular frameworks like React/Next.js or Svelte/SvelteKit. Find what feels intuitive for you. I lean toward Svelte for its simplicity, but Next with Zustand has its strengths too!
Good news! PHP and MySQL are still solid choices. Make sure to use PDO with prepared statements for security. If your app grows, consider using a front-end framework like Vue.js. But honestly, PHP with vanilla JS can still work well, especially with the help of AI tools today.
You could also explore using Go with Postgres. It's a modern stack that can be pretty efficient!
Using PHP and MySQL is still a great option! It's simple and reliable for building CRUD apps. If you go this route, make sure to check out some resources about modern PHP practices to avoid old pitfalls.
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically