Labplot: Free, Open Source and Cross-Platform Data Visualization and Analysis

https://invent.kde.org/education/labplot

https://docs.labplot.org/en/import_export/import_export_sql....

https://doc.qt.io/archives/qt-5.15/sql-driver.html

Are you talking about something else?

They can be useful if you have other tools (e.g. measurement software) that already produces the data you want, and you just want a GUI tool to create plots, and maybe do some simple things like least squares curve fitting etc.

If you already do a lot of data wrangling in something with a programming language and plotting libraries accessible from said language, like the ones you mention, yeah, this is not the tool for you.

* Quickly cycle visually through time series graphs (often several hundred parameters). You'd have seen most of those parameters before and would quickly catch any anomalies. You can clear so much data rapidly like this.

* Quickly analyze a graph at various zoom and pan settings. May be save some as images for inclusion in documents. Like above, the zoom and pan operations often follow each other in a matter of seconds.

* Zoom into fine details, down to single bit levels or single sample intervals. There's surprising amount information you can glean even at these levels. I have run into freak, but useful single events at these levels. And since they're freak events, it's hard to predict in advance where they'd show up. So operation speed becomes a key factor again.

* Plot multiple parameters (sometimes with different units) together to assess their correlation or unusual events. We used to even have team analysis sessions where such visualizations were prepared on demand.

* Do statistical or spectral analysis (like periodograms, log or semi-log graphs, PDFs, etc)

* Add markers or notes within the graph (usually to describe events). Change the axes or plot labels. Change grid value formatting (eg: Do you want time in seconds or HMS?).

All the operations above are possible with Julia, Matlab, R or Python. And we did use almost all of them (depending on personal preference). But none of them suit the workflow described above for one simple reason - speed. You don't have enough time to select each parameter by text or GUI. There must be a way to either quickly launch a visualization or cycle through the parameters as the investigator closes each graph. You also don't have time to set zoom, pan and labels by text. It must be done using mouse (zoom & pan) and directly on the graph (labels and markers) in a WYSIWYG manner. And you don't want to run an FFT or a filter function, save the new series and then plot it - you want it done with a single menu selection. The difference is like using a C++ compiler vs Python in JupyterLab. The application we used was very similar to Labplot.

Now, Excel might seem like a better choice. In fact, LabPlot and our application all has a spreadsheet-like interface with the ability to directly import CSV, TSV, etc. But Excel just doesn't cross the finish line for our requirement. For example, to plot a time series in excel, you have to select the values (column or cells), designate the axes, optionally define the axes and graph labels, start a plot, expand it to required levels and format the print. At that rate, you wouldn't finish the analysis in a month. Those applications would do all that on their own (the labels and other metadata were embedded in the data files by means of formatted comments). But an even bigger problem was the size of the data. Some of those files on import would slow down Excel to speed of molasses. The application had disk and memory level buffering to significantly improve the responsiveness to almost instant interactivity.

I hope this gives you an idea where the tools that you mentioned are not good enough replacements for LabPlot and similar tools.

However, those people also belong to the most-of-the-world who are still leery of "open source" or anything that doesn't come from a known brand.

This thing could be an option for someone who wants to mess around with data but isn't comfortable mentioning it to the boss until they see for themselves if it's worthwhile.

> LabPlot is licensed under GNU General Public License, version 2.0 or later, so to put it in a few sentences:

> You are free to use LabPlot, for any purpose

> You are free to distribute LabPlot

> You can study how LabPlot works and change it

> You can distribute changed versions of LabPlot

> In the last case you have the obligation to also publish the changed source code as GPL.