CRUD application

Question

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

Answer 1

You can use
- php with mysql
- or Node.js with Mongodb
- or python with sqlite
My recommendation the easiest way php with mysql

Answer 2

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

Answer 3

Andrew Choi flask is very bad option for this project

Answer 4

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.

Answer 5

thatstupidcoder yes this available in macOS, i don't have YouTube tutorial but feel free to contact me and i will help u

Answer 6

Thank you so much! You are a great help.

Answer 7

Thanks really helped me to decide

Answer 8

Do I need to install XAMPP to use php?

Answer 9

And is it possible that I do not have to use Javascript if I am going to use PHP and MySQL?

Answer 10

thatstupidcoder yes xampp or wamp

Answer 11

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 ?

Answer 12

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 ?

Answer 13

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

Answer 14

John would you care to explain? for microprojects or small applications and for beginners, flask is a pretty good option.

Answer 15

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.

Answer 16

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.

Answer 17

i also found the youtube link below to be helpful.

https://youtube.com/playlist?list=PL-osiE80TeTs4UjLw5MM6OjgkjFeUxCYH

Answer 18

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.

Answer 19

Use what you are familiar with