Be prepared with these 5 add-ons for your developer utility belt to better overcome the intensive rollercoaster of the life of software development.

When I was a teacher in programming classes, there was a bunch of questions made every year by students. So in this article, I will focus on the most impacting and regular one:

“What tools do I use in my professional life and how do they help ?”

Of course, this is my opinion, the tools and workflows that I choose are based on my experiences over the years producing websites, desktop/mobile applications, and custom information systems…

Indexing — Guide to improve performance, image by João Pires
Indexing — Guide to improve performance, image by João Pires

In the follow up to my other article: How to Improve Microsoft SQL Server (MSSQL) Database Performance, now I will do the same but for MYSQL / MariaDB databases.

When we develop a custom web application, we must test all types of scenarios. Normally the scaling of the database is a key point for quality software. In my current job, I inherited a couple of applications that suffer in performance because the previous developer did not work well at the database level. …

Source: Pixabay
Source: Pixabay
Source: Pixabay

Sometimes there is a need in our databases or even in external databases to perform some optimization in terms of the data structure.

In my experience, there are three approaches that we can take: one more basic and quick, another more depth that involves a restructure and re-planing of the database, and finally the last one that is a mix of the previous two approaches.

In this article, I want to share the basic and quick approach for this Microsoft Database Engine. …

Filipe Pires

Dad, Senior Software Development Engineer for Enterprise Applications, Game Developer/Collector/Player, Electronic development/prototyping

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store