CRUD Operation on WordPress Database Using C# SQL Client

Abstract

Purpose: Sometimes, the researcher stores sensor data inside the cloud to access the data globally. The widespread cloud infrastructures are AWS, Azure, Google, IBM, etc. This type of Cloud server is not free. We need to pay through subscription. Here, we demonstrate how to manage our sensor data using our existing WordPress Website database. The primary example of CRUD operation on the WordPress Database is provided here. The database class is portable. The researcher can easily integrate more functionality. Using the C# language, we created the “WordPressDB.cs” library with the help of an inbuilt SQL client module. On top of that, we developed a graphical user interface for easy operation. We use Flywheel to install WordPress websites locally for safe operation. Once the development is over, we can deploy online without any issues. The completed project code is available to download for quick integration.   

Design/Methodology/Approach: To keep our research work free, we installed Flywheel Local software suitable for local WordPress Website installation. We installed a WordPress Website using the Flywheel. Once the Website is fully installed, we run the site from the Flywheel local interface. Now, we open our C# projects. We need to provide the Database credentials to connect with the WordPress Database. Once the connection is successful, we can create a table read, update, and delete the record.

Findings/Result: We demonstrated how to keep our sensor data using our existing WordPress database. We tested the provided approach, a good and efficient way to control and manage the sensor data. Our communication stack is as tiny as possible, so it is fast. We can keep our real-time data inside this Database with minimum delay.

Originality/Value: Several procedures are available to keep the sensor's data. Using this procedure, we can maintain the data at the least cost possible. We are paying for our website to run. We are getting online cloud storage to keep our sensor data without extra cost. The Website runs around the clock, so our research data is available anytime and anywhere. This approach differs slightly from the traditional approach, like purchasing subscription cloud hosting infrastructure. We can also run the IoT activities using this approach. To exchange the dynamic data between two nodes is also effective without buying a static IP.

Paper Type: Experimental-based Research.