From OpenSCADAWiki
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
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
+
* '''[[Special:MyLanguage/Works/To_do|To Do]]:'''
* '''To Do:'''
+
 
<section begin=ToDo />
 
<section begin=ToDo />
:+ 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), ... ;
 
:- 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 function fieldStruct() implementation for generic SQL dialects and DBMS specific;

Latest revision as of 21:16, 26 February 2025

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.
- 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.