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.

My use of qStudio is driven because it includes the PRQL compiler that takes a modern query language and compiles it 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.