Question about putting up your website with a Database
Hello, I been using GitHub and Netlify to deploy my sites. They are using HTML, CSS, and Javascript. Now that I have learn PHP and MySql I want to use MySql however I have no idea how to deploy a website with MySql. So, I was wondering if anyone know if there is a way to deploy my website online using GitHub or Netlify or another way to deploy it free? If unable to for free then whats the cheapest and best option?
I'm very new to this, so I'm up to learn ๐
2 Replies
There are a few options, like having a managed SQL database instance from a 3rd-pty service like ElephantSQL. You can also use something like Supabase, which is exclusively Postgres but should be similar enough for the simpler things. And there's also the option to rent a VPS and host the entire thing yourself. If you are curious about that you can start here:
https://www.youtube.com/watch?v=SBC_fU14_9o
Jim's Garage
YouTube
Beginner's Guide to Deploying Web Servers (WordPress, Phpmyadmin, N...
Did you know there are static and dynamic web servers, do you know what they are? In this beginner's video I introduce 3 of the most popular web servers, outline possible use cases for each, and show you how to deploy your first website.
Web Server Docker Files:
https://github.com/JamesTurland/JimsGarage/tree/main/Web-Servers
Recommended Hardw...
use pdo with sqlite. the syntax is 90% the same.
you dont need to deploy anything: its just a .sqlite3 file somewhere
its good enough for a website with up to 100k visitors a day, according to their documentation
if you used pdo, then the switch should be simple and quick
if you use prepared statements (you should) then you also dont need to change the syntax