Before science, I was a software engineer. But back in 2002-2006 I was building Java 2EE servlet driven webpages on an Apache Tomcat Webserver, communicating with a Microsoft SQL Server Manager database server.
I think, that makes me a bit of a dinosaur.
Today, I need to build a database with an online (website) driven front end. I know MySQL, but I don't want to go down the old Java 2EE route. So what software techniques do I need for:
1) The web front end (I've heard of VFront, which communicates with MySQL via PHP and Javascript)?
2) To run a website (an web/application server like Apache Tomcat)?
3) To run a database (can this just sit on the web/application server)?
It's been a very long while, so as simple an explanation as possible would be appreciated.
Thanks.
It depends on what you want to achieve, and what the purpose of the database is. There are loads of options vfront being one of them, php maker being another. It all depends on what you want to do.
You have a number of options for the front end. As for questions 2 and 3 the simple answer is yes you can go that route.
Yes for front end you can use PHP. PHP can easily fit into both "front-end" and "back-end. You can also use javascript and mysql. It all depends on your preferences.
In the end, a lot of these technologies are related. They all work together to make something work. Some developers can program for both front-end and back-end, although it does take much more time to design while programming the back-end. It all depends on the project and what technologies and skills are needed where.
It never can be stressed enough, so let me repeat it: It depends on what you want to build. If you want to build a web application, my first reaction would be to discourage you about it. There are thousands of free web applications out there, for every situation or use-case that one can imagine, so you better do some reasearch and use one of them that fits your purpose. If it doesn't fit your purpose 100%, you still have the option of modifying/customizing it, and this is still much less work than building one from scratch.
But, if your needs are very simple and you just need a simple input form and a simple database, I would suggest you to have a look at Google Forms: https://www.youtube.com/watch?v=cm3KyqbaMJA
There are several modern software techniques and frameworks you can consider:
1. Web Front-End: To build the user interface (UI) of your website, you can leverage popular web development frameworks and technologies such as:
- HTML5: The latest version of HTML provides a semantic structure for web content.
- CSS3: Cascading Style Sheets (CSS) allows you to style and layout the web pages.
- JavaScript: JavaScript is a programming language commonly used for client-side interactivity and dynamic behavior on web pages. You can use modern JavaScript frameworks like React, Angular, or Vue.js to build dynamic and interactive UIs.
2. Backend and Server-Side: For the backend and server-side components of your website, you have several options:
- PHP: PHP is a widely used scripting language for web development. It has good integration with MySQL and is often used in conjunction with Apache or Nginx web servers.
- Python: Python is a versatile and popular language for web development. You can use frameworks like Django or Flask to build the backend of your website and communicate with the MySQL database.
- Node.js: Node.js is a JavaScript runtime built on Chrome's V8 JavaScript engine. It allows you to build scalable and efficient web applications using JavaScript on both the backend and frontend. You can use frameworks like Express.js and communicate with MySQL using libraries like Sequelize or Knex.js.
3. Database: Since you are familiar with MySQL, you can continue using it as your database management system. PHP, Python, and Node.js all have good support and libraries for connecting to and interacting with MySQL databases.
Regarding the web/application server, popular choices include:
- Apache HTTP Server: Apache is a widely used web server that supports various platforms and can run PHP applications.
- Nginx: Nginx is a high-performance web server and reverse proxy server. It can also serve as a web server for static files and proxy requests to backend servers.
- Microsoft Internet Information Services (IIS): If you are more comfortable with Microsoft technologies, IIS can be used as a web server for hosting your website.
These are just some of the options available, and the choice of technologies would depend on various factors such as your familiarity, project requirements, scalability needs, and the ecosystem you want to work within
Good luck
credit AI tools.
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Graphs