I have a PostGIS database with 30 million gazetteer points, each have an X Y coordinate. I want to query this and then zoom map to location. However, I don't want to add the data to the project because it takes forever to load 30 million points.
I started looking at creating my own QGIS plugin but all tutorials I have seen, seem to add vector data directly to the map canvas first.
Click button Dialogue Box Enter PostGIS database connection fields (host, dbname, user, password) Enter gazetteer value Finds match Zooms and centers on point.
If anyone has a better idea or knows of a plugin that would be very useful