Building a Tester Intro(195)

If you are not familiar with a tester, then buckle up. This is going to be a very interesting set of posts and videos. This series will not make you an expert in any particular technology. What I will do is get you up to speed on using particular technologies to collect, store and display data. I will show how to construct a system to collect data from multiple sensors. Together, we will make an attractive web GUI for control and a Python script to collect the data. The GUI and Python script will share a MySQL database for control, data collection, and asset management. This tester will only use free tools. I am trying to move away from Labview and use Open Source tools.

I will start by building the GUI. The technologies used will be HTML, CSS, JavaScript, and PHP. I will use PHP scripts to access and alter the MySQL database. We will use fetch calls to access the PHP. This is also referred to as promises.

The next step will show how to use Python to access various MCUs. I start with an Arduino and an ESP32, connected to the computer’s serial port. I will also try to acquire a Keysight DAQ970a. The Keysight DAQ uses a USB connection instead of a serial port. If I can show the difference between connecting to a USB port and a serial port will make a nice addition to the project.

This post may be altered as I build out this series. The alternate is to create a new post for each video. Please comment if you want to add to the video. I will do my best to answer questions or fix errors as I work through the configuration.