Haven't used AWS. Just a VPS, with Laravel and AlpineJS + TailwindCSS with Vite on the frontend. Database is MariaDB, the DB is just on the server.
Tailwind is for styling.
Alpinejs is for sprinkling interactivity on the site.
Vite is probably the bundler for all the frontend stuff to minify, vendor etc