It’s been a while since I’ve had the chance to play with a new version of QGIS. The stars have aligned so I’m digging through the changelog and testing some things out.
Not that I’ve been super attentive for a while – BUT I have noticed the DB Manager has been a bit stagnant. Which makes some sense because there have been moves to take the SQL portion and push it into the browser. So if you pop open the browser and navigate to your data you can right click on it and execute SQL.
The kicker on the “old way” is you couldn’t save your SQL statements. So I generally ran some simple checks and kept a bunch of files in my project directory. You could go back to DB Manager and save SQL but like I said it’s been a bit stagnant for a bit.
With 3.44 Solothurn this changes.
You get a toolbar to save and load SQL files. Bonus – You get a history and the ability to save your SQL into your profile OR your project as opposed to a file. Double bonus – you can click on your layer in the layer panel and open this SQL menu.
Replacement for PostGIS? No. But it’s a nice way to run some checks on data or do some imples analysis if you’re one of the Database people. I wasn’t until lately.
So what will be next with digging through the changelog……
