Recently a friend of mine asked me to prepare a small custom desktop computer with Linux for homework, not gaming. It will be his first journey with a Linux OS (all his life was a Windows power-user), and I must choose wisely to help him to have a smooth transition to a better world.

My choice of distribution was pop-OS because it’s an awesome work from System76 and it checks all the ticks that a good OS must-have, even for games if his son wants to play sometimes…

Every time I install a gnome-based distro (for now pop-OS uses gnome)…


I bought a cheap Bluetooth dongle on Amazon without reading the characteristics carefully… and now I must tell you a little story.


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