From OpenSCADAWiki
Jump to: navigation, search
Line 12: Line 12:
 
|-
 
|-
 
| colspan="9" | BD module. Provides support of different databases by the ODBC connectors and drivers to the databases.
 
| colspan="9" | BD module. Provides support of different databases by the ODBC connectors and drivers to the databases.
 +
* '''[[Special:MyLanguage/Documents/Program_manual#DBFeat|Features]]:''' SQL, LIST
 
* '''To Do:'''
 
* '''To Do:'''
 
<section begin=ToDo />
 
<section begin=ToDo />

Revision as of 10:49, 14 November 2021

Constr.png Waiting to form
Module Name Version License Source Languages Platforms Type Author
ODBC DB by ODBC 0.2 GPL2 bd_ODBC.so en,uk,ru,de x86,x86_64,ARM DB Roman Savochenko
Description
BD module. Provides support of different databases by the ODBC connectors and drivers to the databases.
+ main functions implementation for generic SQL requests, testing for: SQLite, MySQL, PostgreSQL, FireBird;
- specific DBMS properties: quotes for names and values (there are generic and standard ones), ... ;
- OpenSCADA internal DB's layer function fieldStruct() implementation for generic SQL dialects and DBMS specific;
- OpenSCADA internal DB's layer functions fieldSeek(), fieldGet(), fieldDel() implementation for generic SQL dialects and DBMS specific;
- OpenSCADA internal DB's layer functions fieldDel() implementation for generic SQL dialects and DBMS specific;
- generic tests passing for: SQLite(there are some problems in allowed connectors), MySQL, PostgreSQL, FireBird;
- testing an ODBC connector for DBMS Oracle.