Qt Supported Databases

悠悠 2023-06-28 08:50 29阅读 0赞

# Qt Supported Databases #

## SQL数据库驱动程序 ##

Qt SQL模块使用驱动程序插件与不同的数据库api进行通信。由于Qt的SQL模块API与数据库无关，所以所有特定于数据库的代码都包含在这些驱动程序中。Qt提供了几个驱动程序，还可以添加其他驱动程序。提供了驱动程序源代码，可以将其用作编写自己的驱动程序的模型。

## Supported Databases ##

The table below lists the drivers included with Qt:

<table> 
 <thead> 
 <tr> 
 <td style="width:128.4pt;"> Driver Name </td> 
 <td style="width:468.5pt;"> DBMS </td> 
 </tr> 
 </thead> 
 <tbody> 
 <tr> 
 <td style="text-align:inherit;width:128.4pt;"> <a href="https://doc.qt.io/qt-5/sql-driver.html#qdb2" rel="nofollow">QDB2</a> </td> 
 <td style="text-align:inherit;width:468.5pt;"> IBM DB2 (version 7.1 and above) </td> 
 </tr> 
 <tr> 
 <td style="text-align:inherit;vertical-align:top;width:128.4pt;"> <a href="https://doc.qt.io/qt-5/sql-driver.html#qibase" rel="nofollow">QIBASE</a> </td> 
 <td style="text-align:inherit;vertical-align:top;width:468.5pt;"> Borland InterBase </td> 
 </tr> 
 <tr> 
 <td style="text-align:inherit;width:128.4pt;"> <a href="https://doc.qt.io/qt-5/sql-driver.html#qmysql" rel="nofollow">QMYSQL</a> </td> 
 <td style="text-align:inherit;width:468.5pt;"> MySQL (version 5.0 and above) </td> 
 </tr> 
 <tr> 
 <td style="text-align:inherit;vertical-align:top;width:128.4pt;"> <a href="https://doc.qt.io/qt-5/sql-driver.html#qoci" rel="nofollow">QOCI</a> </td> 
 <td style="text-align:inherit;vertical-align:top;width:468.5pt;"> Oracle Call Interface Driver </td> 
 </tr> 
 <tr> 
 <td style="text-align:inherit;width:128.4pt;"> <a href="https://doc.qt.io/qt-5/sql-driver.html#qodbc" rel="nofollow">QODBC</a> </td> 
 <td style="text-align:inherit;width:468.5pt;"> Open Database Connectivity (ODBC) - Microsoft SQL Server and other ODBC-compliant databases </td> 
 </tr> 
 <tr> 
 <td style="text-align:inherit;vertical-align:top;width:128.4pt;"> <a href="https://doc.qt.io/qt-5/sql-driver.html#qpsql" rel="nofollow">QPSQL</a> </td> 
 <td style="text-align:inherit;vertical-align:top;width:468.5pt;"> PostgreSQL (versions 7.3 and above) </td> 
 </tr> 
 <tr> 
 <td style="text-align:inherit;width:128.4pt;"> <a href="https://doc.qt.io/qt-5/sql-driver.html#qsqlite2" rel="nofollow">QSQLITE2</a> </td> 
 <td style="text-align:inherit;width:468.5pt;"> <a href="https://doc.qt.io/qt-5/qtsql-attribution-sqlite.html#sqlite" rel="nofollow">SQLite</a>&nbsp;version 2 Note:&nbsp;obsolete since Qt 5.14 </td> 
 </tr> 
 <tr> 
 <td style="text-align:inherit;vertical-align:top;width:128.4pt;"> <a href="https://doc.qt.io/qt-5/sql-driver.html#qsqlite" rel="nofollow">QSQLITE</a> </td> 
 <td style="text-align:inherit;vertical-align:top;width:468.5pt;"> <a href="https://doc.qt.io/qt-5/qtsql-attribution-sqlite.html#sqlite" rel="nofollow">SQLite</a>&nbsp;version 3 </td> 
 </tr> 
 <tr> 
 <td style="text-align:inherit;width:128.4pt;"> <a href="https://doc.qt.io/qt-5/sql-driver.html#qtds" rel="nofollow">QTDS</a> </td> 
 <td style="text-align:inherit;width:468.5pt;"> Sybase Adaptive Server Note:&nbsp;obsolete since Qt 4.7 </td> 
 </tr> 
 </tbody> 
</table>

[SQLite][] is the in-process database system with the best test coverage and support on all platforms. Oracle via OCI, PostgreSQL, and MySQL through either ODBC or a native driver are well-tested on Windows and Linux. The completeness of the support for other systems depends on the availability and quality of client libraries.

Note: To build a driver plugin you need to have the appropriate client library for your Database Management System (DBMS). This provides access to the API exposed by the DBMS, and is typically shipped with it. Most installation programs also allow you to install "development libraries", and these are what you need. These libraries are responsible for the low-level communication with the DBMS. Also make sure to install the correct database libraries for your Qt architecture (32 or 64 bit).

Note: When using Qt under Open Source terms but with a proprietary database, verify the client library's license compatibility with the LGPL.

[SQLite]: https://doc.qt.io/qt-5/qtsql-attribution-sqlite.html#sqlite