From OpenSCADAWiki
Jump to: navigation, search
Line 5: Line 5:
 
|-
 
|-
 
<section begin=info />
 
<section begin=info />
| [[Special:MyLanguage/Modules/ODBC|ODBC]] || DB by ODBC || 0.2 || GPL2 || bd_ODBC.so || en,uk,ru,de || x86,x86_64,ARM
+
| [[Special:MyLanguage/Modules/ODBC|ODBC]] || DB by ODBC
 +
* '''[[Special:MyLanguage/Documents/Program_manual#DBFeat|Features]]:''' SQL, LIST
 +
| 0.2 || GPL2 || bd_ODBC.so || en,uk,ru,de || x86,x86_64,ARM
 
<section end=info />
 
<section end=info />
 
| DB || Roman Savochenko
 
| DB || Roman Savochenko
Line 12: Line 14:
 
|-
 
|-
 
| 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 11:15, 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.
  • To Do:
+ 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.