LabPlot/ImportExport/ImportFromSQLDatabases

From KDE UserBase Wiki
Revision as of 11:15, 6 February 2022 by Asemke (talk | contribs)

LabPlot can read and import data from SQL databases. The supported databases are those that are covered by Qt SQL. http://doc.qt.io/qt-5/sql-driver.html

1. Import dialog Similar to the already existing “Import dialog” for files, there is now a new dialog for importing from the databases that guides the user through the process of selection and import of the relevant data.

When opening this dialog for the first time, it's empty and the first step is to configure the connection to your database by clicking on the button "Manage connection" (red-highlighted on the screenshot above).

2. In the "Connection Manager" dialog select the proper database driver and provide the relevant settings like the host, the port number, the credentials and the actual name of the database. In case the SQLite database is used, the connection is simply the path to the database file.

3. After all the connections settings were specified, click on the "Test" button to make sure LabPlot can connect successfully to the database:

Note, once a connection is configured and saved, the user can select it in the import dialog for future imports and there is no need to go through the configuration steps again. Also, it is possible to manage multiple connections to different databases.


4. Import either complete tables or results of a SQL query

The dialog supports the user with the navigation through the available database tables and with a preview of the table data:


Furthermore, it is also possible to import the result of a custom SQL query and import its result set:

5. finale results