These tools will set the fundamentals for developing create database driven webpages and apps.
In order to make any great data driven application, a lot of work must be put into to the infrastructure. This type of work does not directly influence the visual but has a large role in the efficiency and optimization of your webpage or app. Here are the five tools we use for behind the scenes development. All are open source and supported within the software community, therefore are FREE, well documented and a lot of support.
Apache, along with Nginx, is an common open source web server. If you application has any dynamic site (i.e. PHP, Python, or Perl scripts) Apache is the way to go, more specifically their LAMP, which stands for Linux, Apache, MySQL, and PHP. These four are all open source and form the base for any dynamic website or application.
MySQL Workbench is a database visualization tool for SQL database development, administration, design, and maintenance. Supported by both Mac and Windows with secure connection through SSL to protect your data.
Postman is an awesome API development environment. This tool is a must when developing a REST API. It has an intuitive design where you can send variables, user authentication, send GET/POST/UPDATE/DELETE request, create different workflows, and save requests for future reference. Additionally, you can set up automated testing to run through all your user scenarios and log the results for documentation.
Bootstrap is a useful tool to set up a responsive vanilla web application quickly, then pass it to a front-end developer to do what they do best. It includes HTML and CSS based templates to set up tables, search bars, buttons, and many other features that you may need for your application.
Any app you build is only useful if people can actually use it. What slate offers is a clean and responsive API documentation. The template is simple to use and looks great. All you documentation is in a single page format, sample code is visible on the right as the user reads through the documentation. For the coding snippets, it handles around 100 different syntax make it super simple to document the different components of your API.
These five tools are a great start to developing great infrastructure for your application. Share your work and explore your imagination.