If you don't know what the MTK7628n chipset Wi-Fi transmitter ap module is, don't worry, here I'll explain a little about this concept in a simple way.
A database is a set of related data that organize in an extremely improve way so that it is fast to search and in a compact way.
In a very simplistic way, we can compare the storage of a database to several tables of Excel, wherein Excel is what we call a spreadsheet, in a database we call tables (a database easy to compose of several tables). What we call columns in excel, in the database we call a field. And what we call in Excel a row, in the database we call a record.
MTK7628n chipset Wi-Fi transmitter ap module unlike Excel, the main advantage of a database lies in the system that manages these data, which uses its query language, where through it we can include data, query data and manage the entire database. I strongly recommend that you do some research if you benefit.
There are several types of databases, in which the query language can change, and the database itself can be store in several different places: either a local machine, or on a local network, or even on a machine on the internet that is several kilometers away. This last option is the most interesting for us.
Several companies provide this database cloud service, and for this post, we chose Clever Cloud, which has several interesting tools for developers and data analysts, and which is free for up to 10MB of use.
MTK7628n chipset Wi-Fi transmitter ap module: There are other projects on the internet that use db4free.net, which is good, but in my experience, I found it a very unstable tool, but it has the advantage of being able to be common up to 200MB.
The data query language we are going to choose is MySQL, as it is simple, has a large community, and has a good Arduino library.
Given all these concepts learn, we will develop a system that, through Arduino Uno, reads several temperature sensors, and sends this data to an ESP-01, so that it sends the measurement to the online database, and later we can analyze.
This project very useful for different types of applications where it is necessary to register data in clouds and present it through the Web.
For this project, we chose an Arduino Uno + ESP-01 because we know that most of you have an MTK7628n chipset Wi-Fi transmitter ap module Uno. And that way we will be able to make the project with the materials you already have.
It is possible to easily adapt the project to a NodeMCU board. And it is up to you to choose the best way.
Recording programs on ESP-01 with the USB Adapter
The USB to ESP-01 adapter is a device that connects the ESP-01 with the computer, making the USB-Serial connection very simple and easy, without needing to use an FTDI and using complicating connections. Everything is quite simple, just plug it into the board and plug it into the USB.
If you are new to ESP-01, click here and read a little about this component.
The project of the USB adapter was thought to make the connection of the module with the computer so that through a program that makes a serial communication RS232. The Termite is an example of software that makes this connection.
From the factory, your MTK7628n chipset wifi transmitter ap module program to work in AT command mode (Click here to see the command list. And through this adapter, we can give commands for the ESP-01 to make various configurations. But you can see that in this mode there is a problem that your module depends on another processor to do the tasks, functioning as a module of that other microcontroller.
There is a mode, which is more interesting to use. ESP-01 in Standalone makes it operate like an Arduino, with the advantage of being much smaller, with higher processing power.
The downside is the small number of pins, but that might be enough for some projects.
Without modifications to the USB adapter, it is not possible to make the programs be sent to the MTK7628n chipset wifi transmitter ap module, it is not possible to make it work in Standalone mode. Luckily, making these changes is simple and easy to do.
For the ESP-01 to enter the UART program recording mode (serial), it needs that the GPIO0 pin is at a low level at its initialization.
Therefore, the adapter cannot record programs.
To make this adaptation, we will have to somehow make GPIO0 be at a LOW level when the module starts up. For that, we can make a physical connection from GPIO0 directly to GND.
Thus, to control when the adapter must be in recording mode. We can place a seesaw switch connecting the GPIO0 pin. And the GND pin so that in one position of the switch it is for recording programs. And in the other position the mode for monitoring and sending commands via RX/TX.
Resolution 1 – Directly soldering a wire to the adapter pins, where the soldering whole carefully so as not to damage the module.
Resolution 2 - Or the other way to do it is to put a thin wire with a copper tip directly inside the female connector, like this:
It is important that the wire is quite thin. And that the fitting is done delicately, so as not to damage any of the components. Solder the see-saw wrench on the end of these cables.
To record the programs, but the seesaw switch in the ON position, and connect the module to the computer.
If your Arduino IDE is not ready to MTK7628n chipset Wi-Fi transmitter ap module cards, open this tutorial and go to the “Procedures for installing NodeMCU in Arduino IDE” part, where it will teach you how to install MTK7628N cards in your Arduino IDE.
With this post, we can see how to make a procedure so that the ESP-01 USB adapter can be common to send programs through Arduino IDE.
With this, you can make programs to control the pins embedding in the ESP-01 board, considering its pinout. Also, you can record programs to control GPIO 0, 1, 2, and 3, and taking advantage of the MTK7628n chipset wifi transmitter ap module connection present in a simple way on the board.
Free A Quote