Iot framework ServerSuperIO tutorial-19. device drivers and OPC Client Support persistence of mysql, oracle, sqlite, and sqlserver. V3.6.4 released, sqlite persistent
19. The device driver and OPC Client Support persistence of mysql, oracle, sqlite, and sqlserver.
19.1 Overview
ServerSuperIO supports writing data collected by device drivers and OPC clients to mysql, oracle, SQL Server, and sqlite databases by TAG set. It also supports writing data to real-time databases, such as edna, golden, and corert. The support for real-time databases and relational databases mainly consider the project environment and support capabilities.
In essence, the IDataPersistence interface is inherited in a unified manner, and then the Operations completed by extension are inherited. If other users need to support nosql databases, they can inherit this interface to complete the persistence of DeviceDynamic.
For detailed operation procedure, see 17. Integration of Golden real-time database, high-concurrency storage of measurement point data.
19.2 support for mysql Databases
You can automatically create databases and data tables, and set parameters, for example:
The data read by the device driver and OPC Client can also be saved, for example:
19.3 oracle Database Support
You need to create a database instance in advance. The database name is ServerSuperIO, and then configure the connection parameters to automatically create data tables, such:
The data read by the device driver and OPC Client can also be saved, for example:
19.4 SQL Server database support
You can automatically create databases and data tables, and set parameters, for example:
The data read by the device driver and OPC Client can also be saved, for example:
19.5 support for sqlite Databases
Enter the path of the database file in the parameter Server, for example:
The data read by the device driver and OPC Client can also be saved, for example:
1. [serialization] C # communication (Serial Port and network) Framework Design and Implementation
2. [Open Source] C # cross-platform Iot communication framework ServerSuperIO (SSIO) Introduction
2. Overall system construction solution using SuperIO and open-source cross-platform Iot framework ServerSuperIO
3. C # technical route of industrial IoT and integrated system solutions (data sources,, data upload and receiving, ActiveMQ, Mongodb, WebApi, and mobile App)
5. ServerSuperIO Open Source Address: https://github.com/wxzz/ServerSuperIO
Internet of Things & integrated technology (. NET) QQ group: 54256083
: Http://www.bmpj.net/thread-14-1-1.html
1. C # Introduction to cross-platform Iot communication framework ServerSuperIO (SSIO)
Serialization | Iot framework ServerSuperIO tutorial 1.4 communication modes and mechanisms.
Serialization | Iot framework ServerSuperIO tutorial 2. service instance configuration parameters
Serialization | Iot framework ServerSuperIO tutorial-3. Device Driver Introduction
Serialization | Iot framework ServerSuperIO tutorial-4. For example, you can develop a device driver that supports both serial and network communication.
Serialization | Iot framework ServerSuperIO tutorial-5. Polling communication mode development and precautions.
Serialization | Iot framework ServerSuperIO tutorial-6. concurrent communication mode development and precautions
Serialization | Iot framework ServerSuperIO tutorial-7. Self-control communication mode development and precautions
Serialization | Iot framework ServerSuperIO tutorial-8. single-instance communication mode development and precautions
Serialization | Iot framework ServerSuperIO tutorial-9. protocol filter to solve multiple packet-related, sticky packet, and redundant data
Serialization | Iot framework ServerSuperIO tutorial-10. Two Methods for continuous transmission of large data streams (such as files)
Serialization | Iot framework ServerSuperIO tutorial-11. Implement device (driver) and device (driver) interaction and cascade control.
Serialization | Iot framework ServerSuperIO tutorial-12. Service Interface Development and bidirectional interaction with the cloud
Serialization | Iot framework ServerSuperIO tutorial-13. Custom View display interface development to meet different display requirements
Serialization | Iot framework ServerSuperIO tutorial-14. Introduction to preparation tools and mounting of device drivers, view drivers, and service instances
Serialization | Iot framework ServerSuperIO tutorial-15. Use of data persistence Interfaces
Serialization | Iot framework ServerSuperIO tutorial-16.OPC Server usage steps
Serialization | Iot framework ServerSuperIO tutorial-17. Support for real-time databases and high-concurrency storage of measurement point data
Serialization | Iot framework ServerSuperIO tutorial-18. Integrated OPC Client and usage steps