I’ve been following the progress of QStudio – a SQL IDE that runs on Windows, macOS, and Linux. It’s great for running SQL queries against a database. I haven’t used its Pulse features to create real-time graphs of live data, though.
I chose QStudio because it works with the PRQL compiler that implements a modern query language that compiles to SQL statements. The QStudio IDE allows me to write straightforward PRQL queries and immediately execute them against my SQL database.
Quick Start: My friends want to pick through some of the SQL data we’ve collected for a project. I wrote a series of tutorials that show how to get started using QStudio with PRQL. They are at https://github.com/richb-hanover/qStudio-PRQL_Quick_Start
Installation: There’s a pretty good QStudio installer for Windows on the Downloads page. And the .jar file seems to work fine on Linux. But it’s a bit of a pain to run the .jar file on macOS. So I created a macOS application bundle for the combination of QStudio and PRQL. You can download the macOS file from: https://randomneuronsfiring.com/wp-content/uploads/QStudio.zip Check the Quick Start #2 for details on approving it to run on macOS.
Update: 26Dec2025 – TimeSeries has changed their product name to “QStudio” (no camel-case). The current download incorporates the name change and contains QStudio 5.01 and prqlc 0.13.10.