+ 3

CRUD application

I want to make a basic front end CRUD application that is connected in a mysql server that will create, read, edit, delete and display all database and tables. What programming language should I use? I have no background in making an application. Should I use python flask and MySQL? Or do you have any recommendation for a beginner

25th Apr 2021, 11:37 PM
thatstupidcoder
thatstupidcoder - avatar
19 Answers
+ 6
You can use - php with mysql - or Node.js with Mongodb - or python with sqlite My recommendation the easiest way php with mysql
25th Apr 2021, 11:45 PM
Jamal Saied
Jamal Saied - avatar
+ 3
thatstupidcoder The browser does not understand php so it need something compile php to language that browser understand so you need to install xampp to compile php, Javascript important help you to handle things with php you can know little things from Javascript
25th Apr 2021, 11:53 PM
Jamal Saied
Jamal Saied - avatar
+ 3
Andrew Choi flask is very bad option for this project
26th Apr 2021, 1:21 AM
John
John - avatar
+ 3
Andrew Choi i've ten years of experience in this field, if u use flask for this project u will write a huge amount of code and flask is very weak framework, but php will make this project easily and when you learn PHP will help u do any project easily. Finally flask very poor framework, you can use instead Django, I'm sure PHP is a great choice for this small project depending on my experience.
26th Apr 2021, 9:39 AM
John
John - avatar
+ 2
thatstupidcoder yes this available in macOS, i don't have YouTube tutorial but feel free to contact me and i will help u
26th Apr 2021, 12:14 AM
Jamal Saied
Jamal Saied - avatar
+ 2
Thank you so much! You are a great help.
26th Apr 2021, 12:18 AM
thatstupidcoder
thatstupidcoder - avatar
+ 2
Thanks really helped me to decide
4th May 2021, 6:41 AM
Mr Nothing
+ 1
Do I need to install XAMPP to use php?
25th Apr 2021, 11:48 PM
thatstupidcoder
thatstupidcoder - avatar
+ 1
And is it possible that I do not have to use Javascript if I am going to use PHP and MySQL?
25th Apr 2021, 11:48 PM
thatstupidcoder
thatstupidcoder - avatar
+ 1
thatstupidcoder yes xampp or wamp
25th Apr 2021, 11:49 PM
Jamal Saied
Jamal Saied - avatar
+ 1
What is the purpose of XAMPP ? And is it possible that I do not have to use Javascript instead I am just going to use html and css for the front end design if I am going to use PHP and MySQL ?
25th Apr 2021, 11:50 PM
thatstupidcoder
thatstupidcoder - avatar
+ 1
This is feasible in macOS right? And do you have any youtube tutorial in making crud app with javascript, html and css? and using Bootstrap is optional right ?
25th Apr 2021, 11:58 PM
thatstupidcoder
thatstupidcoder - avatar
+ 1
flask has a easyish tutorial walkthrough i found very helpful. i would recommend reading it and following along with it. i used vs code as my editor, which can work with several other languages. https://flask.palletsprojects.com/en/1.1.x/tutorial/#tutorial
26th Apr 2021, 1:08 AM
you are smart. you are brave.
you are smart. you are brave. - avatar
+ 1
John would you care to explain? for microprojects or small applications and for beginners, flask is a pretty good option.
26th Apr 2021, 2:08 AM
you are smart. you are brave.
you are smart. you are brave. - avatar
+ 1
I’ve tried using Python Flask however I kept getting an error of “TemplateNotFound” I tried to put my html file in a template folder but I still got the same error.
26th Apr 2021, 2:36 AM
thatstupidcoder
thatstupidcoder - avatar
+ 1
if you are using flaskr, the directory should be flaskr\templates. it is case sensitive, so you will want to make sure that is correct as well.
26th Apr 2021, 5:09 AM
you are smart. you are brave.
you are smart. you are brave. - avatar
+ 1
i also found the youtube link below to be helpful. https://youtube.com/playlist?list=PL-osiE80TeTs4UjLw5MM6OjgkjFeUxCYH
26th Apr 2021, 5:10 AM
you are smart. you are brave.
you are smart. you are brave. - avatar
+ 1
John flask is a micro framework and therefore i understand its limitations compared to other options, but it is still good for small projects. i dont agree that flask is a weak or poor framework and your reasoning sounds like it is more of your preference than fact. django is more robust than flask, but also has a larger learning curve and would require just as much coding if not more than flask. i also understand that php could be a good option as well. however, you have to download and install multiple applications, such as apache and xampp to complete this project. it is not a lot, but it can be difficult to get past for beginners. as with any project, we have many options when it comes to what we can use, and what we use is dependant on our preference and comfort level. you obviously have a preference for php and im sure others have their own preferences. it doesnt mean other options aren’t good.
26th Apr 2021, 1:32 PM
you are smart. you are brave.
you are smart. you are brave. - avatar
+ 1
Use what you are familiar with
26th May 2021, 1:45 PM
Abdulsalam 🇳🇬 Ishaq
Abdulsalam 🇳🇬 Ishaq - avatar