Efficient searches on Google for programming questions
Published: April 18, 2021
I got an error when I tried to develop software. What should I do now?
Software development is an amazing area to work but it has some challenges and requires steadily continuous learning. Today more and more people become software developers (the number of developers around the world was 21.6 million in 2019 and jumped to 24.6 million in 2020) and new technology and tools are released every day (Source: How Many Software Developers Are There in the World?). So, all the developers, but mainly the newcomers, need to have a skill to learn how to learn new things and how to learn things as fast as possible.
Like almost every profession today, the fastest and easiest way to solve concrete problems in software development is to simply google things. However, Google could bring many useless results among the good results. So, I would like to invite you, smart audience, to let me persuade you to use some simple but useful search string-building techniques (the term search string means the expression you write inside the Google search bar). Let's start with the classical learning challenge of all developers: you are trying to configure a MySQL database system for your web application then you get an error related to a connection. Let's see some techniques to overcome this problem.
If you do not have a clue about an error message happening to you, you can simply copy the main parts of that message, paste it on Google's search bar and dig on the results. When I speak about the main parts I mean the core of the content of the message, excluding memory addresses, your machine's username or filepath (please avoid using sensitive data on searching for your own security).
Probably there have been millions of developers that have searched about things related to that error message on forums before you. As most public forums are indexed (previously prepared for search) on Google's databases, you can easily find a good answer. Thus, copy the main parts of the error and Google it.
As we can see on the picture below, I had an error trying to configure a MySQL database system. This error has a main part 'Can t connect to local MySQL server through socket'. I removed all other words from the error and focused my search on those.
Portfolio
I selected a few projects I've worked on to show you. Some projects have contract constraints so that I won't be showing them. I played the role of Frontend and Backend developer in all of them, sometimes in time, sometimes on my own.
Lillio's Observations Project: 2024
At Lillio, I served as both the tech lead and full-stack engineer for the Observations project, developing a comprehensive feature using Ruby on Rails, ReactJS, React Native, PostgreSQL, and AWS. I managed the integration of a robust backend with a dynamic frontend to enhance functionality and mobile integration. More info here.
Lune: 2023
Payment management system for Cappta getway. This project was done in dotnet core, MSSQL SERVER and VueJS.
Ideallang English: 2022
English Course website made in WordPress and using a MySQL database (in partnership with another engineer).
Posto7: 2021
Nutrition application made with ReactJS, Firestore DB, and Firebase. My main attribution was to build an admin portal for the back office team
PSMI: 2020
(Work in maintenance) Education platform containing a bunch of curses in Brazil, written in Ruby on Rails, PostgreSQL, Express JS, Google Cloud Functions, and AWS. I was responsible for upgrading Ruby and Rails versions, as well as transitioning the cloud infrastructure from GCP to AWS.
Mangue Tecnologia: 2020
(Work in maintenance) An educational platform offering a variety of courses in Brazil, developed using Ruby on Rails, PHP, JavaScript, and MySQL. I built several eCommerce websites, enhancing user experience and functionality.
Chefstrela': 2019
Gastronomy E-commerce made in WordPress and using a MySQL database (in a partnership with another engineer and a designer)
Casa Roberto Marinho: 2018
Content management system with Ruby on Rails, MySQL, and JQuery. Cultural and educational business.
Kariri Sapuyá: 2018
Digital archive combined with a content management system for storing and : was delivering historical documents about South American Native peoples in Northeast Brazil. It is made with Ruby, Ruby on Rails, ElasticSearch, JQuery, MySQL, and MongoDB.Link to the web app: Kariri Sapuyá.
Perceive: 2017
Automated tool for extracting useful information about vulnerabilities from mailing lists. It includes a series of solutions, including Python Jupyter Notebooks, a Flask server, and a MySQL database. More info here.
Conserve Piso: 2017
A web system developed using PHP, MySQL, and jQuery, designed to streamline the management of flooring projects. This system replaces traditional methods with a digital platform that enhances efficiency and accuracy.
DPMS (Digital Management System): 2015-2017
System constructed with Ruby on Rails, MySQL, JQuery, and Telerik Kendo. It aims to manage all steps of an industrial project, replacing common spreadsheets with sophisticated, customizable, and reliable resources. See more info: See more info: Oxeanbits.
Portuguese Atlantic (Portuguese Name: Atlântico Português): 2014
Content management system made with Ruby on Rails, PostgreSQL, JQuery, and ElasticSearch. It is an application to manage and search content in a digital historical archive, which is also uploaded within the CMS. Link to the web app: Atlântico Português.
About me
Hey! I'm a senior full-stack software engineer, Vinicius L. Gesteira (aka Vini). Since 2014, I've worked with web development (mainly Ruby, Ruby on Rails, Rust, Solidity, Node JS, Docker, AWS, React, and Svelte), machine learning, web scraping, Python scripts and other related fields. If you are interested in more details, please check out my LinkedIn and GitHub.