DATABSE
Hey people, I would like to ask for advice, I have been learning front-end and for a personal mini project, I like to create a site that will be a mini wine warehouse for my friend, but for this I have to make a database, I do have a minimum knowledge of mysql and php, but whenever I did a project was on localhost, I never worked one with an online database, do not know how to put it safer or which platform to use it, someone manages me to do a mini guide than I need to create the database correctly, it is attention only a mini project does not need to be done in the most perfect way possible.
I am very grateful to anyone who can help!
7 Replies
I would suggest looking into Supabase to handle all that for you.
Even if it's a small project, if you have no experience with databases, hosting and all that then it's probably best to rely on a service like Supabase and then slowly learn on the side for the next one (if that's something you are interested in).
For a mini-project, SQLite is a great option. Most operating systems have it installed or it’s super easy to install. No network connections, no lag, single-file DB.
@13eck @joao6246 This mini project is with the intuition of learning more about back-end, I have a few hours at msql workbench just don’t know if what I do is the right way, I usually create the database, make the link in the mouth all the pages from html to php, make it link with the database and create all the dynamics with php.
Once you learn how to write SQL and all that, you sill need to have a database somewhere online and that's the biggest hassle really. Supabase handles that but you still have to write the code yourself so you can focus on that part alone. There are also tools available to view and manage your database similar to workbench if you need to.
I could recommend a great PHP series that you can follow on YouTube: https://www.youtube.com/playlist?list=PLr3d3QYzkw2xabQRUpcZ_IBk9W50M9pe-
It's quite extensive but if you already know the basics you can skip to the last project where a database is used (starts around video 100).
YouTube
Learn PHP The Right Way - Full PHP Tutorial For Beginners & Advanced
Hello & welcome to my first course "Learn PHP The Right Way". In this course, you will learn PHP from beginners level all the way to advanced. The "right way...
Thanks a lot for help
A project I've used & enjoyed is https://hasura.io which is a GraphQL interface to Postgresql. You create your schema using the web UI & then GraphQL lets you pull out whatever data you like.
Their free version is backed by https://neon.tech which is serverless Postgresql & worth checking out on its own.