Re: [QGIS-Developer] Is it possible to make QGIS show the fired queries to databases in Debugging Tools?

[Alessandro Pasotti via QGIS-Developer]

On Fri, Jul 29, 2022 at 12:30 PM Bo Victor Thomsen via QGIS-Developer
 wrote:
>
> Nice to know  -
>
> What about GeoPackage ? Is it technically difficult or was is not

The first: GPKG uses GDAL which internally calls SQLite C code, and
there is no interface to retrieve the actual SQL.

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Is it possible to make QGIS show the fired queries to databases in Debugging Tools?

[Bo Victor Thomsen via QGIS-Developer]

Nice to know  -

What about GeoPackage ? Is it technically difficult or was is not 
requested ??


I'm just wondering. GeoPackage is - after all - a major data format for 
QGIS..


And both Spatialite and GeoPackage is based on the same db-technology: 
SQLite


Med venlig hilsen / Kind regards

Bo Victor Thomsen

Den 29-07-2022 kl. 11:12 skrev Alessandro Pasotti via QGIS-Developer:

It is currently implemented for PG, Oracle, MSSQL and spatialite.

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Is it possible to make QGIS show the fired queries to databases in Debugging Tools?

[Andreas Neumann via QGIS-Developer]

Hi Ale,

Thanks for the clarification - good to know!

Andreas

On 2022-07-29 11:12, Alessandro Pasotti wrote:


Hi,

It is currently implemented for PG, Oracle, MSSQL and spatialite.

On Fri, Jul 29, 2022 at 10:48 AM Andreas Neumann via QGIS-Developer
 wrote:


Hi Richard,

Yes, this happens from time to time to me as well, that I am looking 
for a new feature and it turns out that it is already implemented ;-)


As far as I know, it is only implemented for Postgis so far - other DB 
engines could be added, if someone cares about it.


Greetings,

Andreas

On 2022-07-29 10:41, Richard Duivenvoorde via QGIS-Developer wrote:

Duh...

Thanks Andreas, how can I have missed this...

Too many features syndrome I think :-)

Thanks, working great (at least for Postgis, not other db around 
here...)


Regards,

Richard

On 7/29/22 10:34, Andreas Neumann wrote:

Hi Richard,

This should already be available in the debugging tools --> Query 
Logger


It was a recent QGIS grant project and developed by elpaso.

Greetings,

Andreas

On 2022-07-29 10:25, Richard Duivenvoorde via QGIS-Developer wrote:

Doing some Postgis work with QGIS, I often asked myself what queries 
QGIS is firing to the database.
I can off course log that in the database, but I was wondering if QGIS 
had some 'signal' which could be use to pass the queries used to the 
Debugging Tools?


I skimmed QgsDataProvider, QgsVectorDataProvider and the Postgres 
provider, but I think these are not so communicative as the QGIS 
Network request, so I think it will be harder then I hoped... as 
always :-(


OR am I missing some signal which could be used?

Regards,

Richard Duivenvoorde

PS else this is just a nice feature request for the Debugging Tools 
:-)

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer 

Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer 



___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Is it possible to make QGIS show the fired queries to databases in Debugging Tools?

[Alessandro Pasotti via QGIS-Developer]

Hi,

It is currently implemented for PG, Oracle, MSSQL and spatialite.


On Fri, Jul 29, 2022 at 10:48 AM Andreas Neumann via QGIS-Developer
 wrote:
>
> Hi Richard,
>
> Yes, this happens from time to time to me as well, that I am looking for a 
> new feature and it turns out that it is already implemented ;-)
>
> As far as I know, it is only implemented for Postgis so far - other DB 
> engines could be added, if someone cares about it.
>
> Greetings,
>
> Andreas
>
> On 2022-07-29 10:41, Richard Duivenvoorde via QGIS-Developer wrote:
>
> Duh...
>
> Thanks Andreas, how can I have missed this...
>
> Too many features syndrome I think :-)
>
> Thanks, working great (at least for Postgis, not other db around here...)
>
> Regards,
>
> Richard
>
> On 7/29/22 10:34, Andreas Neumann wrote:
>
> Hi Richard,
>
> This should already be available in the debugging tools --> Query Logger
>
> It was a recent QGIS grant project and developed by elpaso.
>
> Greetings,
>
> Andreas
>
> On 2022-07-29 10:25, Richard Duivenvoorde via QGIS-Developer wrote:
>
> Doing some Postgis work with QGIS, I often asked myself what queries QGIS is 
> firing to the database.
> I can off course log that in the database, but I was wondering if QGIS had 
> some 'signal' which could be use to pass the queries used to the Debugging 
> Tools?
>
> I skimmed QgsDataProvider, QgsVectorDataProvider and the Postgres provider, 
> but I think these are not so communicative as the QGIS Network request, so I 
> think it will be harder then I hoped... as always :-(
>
> OR am I missing some signal which could be used?
>
> Regards,
>
> Richard Duivenvoorde
>
> PS else this is just a nice feature request for the Debugging Tools :-)
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org 
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer 
> 
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer 
> 
>
>
>
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Is it possible to make QGIS show the fired queries to databases in Debugging Tools?

[Andreas Neumann via QGIS-Developer]

Hi Richard,

Yes, this happens from time to time to me as well, that I am looking for 
a new feature and it turns out that it is already implemented ;-)


As far as I know, it is only implemented for Postgis so far - other DB 
engines could be added, if someone cares about it.


Greetings,

Andreas

On 2022-07-29 10:41, Richard Duivenvoorde via QGIS-Developer wrote:


Duh...

Thanks Andreas, how can I have missed this...

Too many features syndrome I think :-)

Thanks, working great (at least for Postgis, not other db around 
here...)


Regards,

Richard

On 7/29/22 10:34, Andreas Neumann wrote: Hi Richard,

This should already be available in the debugging tools --> Query 
Logger


It was a recent QGIS grant project and developed by elpaso.

Greetings,

Andreas

On 2022-07-29 10:25, Richard Duivenvoorde via QGIS-Developer wrote:

Doing some Postgis work with QGIS, I often asked myself what queries 
QGIS is firing to the database.
I can off course log that in the database, but I was wondering if QGIS 
had some 'signal' which could be use to pass the queries used to the 
Debugging Tools?


I skimmed QgsDataProvider, QgsVectorDataProvider and the Postgres 
provider, but I think these are not so communicative as the QGIS 
Network request, so I think it will be harder then I hoped... as always 
:-(


OR am I missing some signal which could be used?

Regards,

Richard Duivenvoorde

PS else this is just a nice feature request for the Debugging Tools :-)
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer 

Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer 



___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Is it possible to make QGIS show the fired queries to databases in Debugging Tools?

[Richard Duivenvoorde via QGIS-Developer]

Duh...

Thanks Andreas, how can I have missed this...

Too many features syndrome I think :-)

Thanks, working great (at least for Postgis, not other db around here...)

Regards,

Richard

On 7/29/22 10:34, Andreas Neumann wrote:

Hi Richard,

This should already be available in the debugging tools --> Query Logger

It was a recent QGIS grant project and developed by elpaso.

Greetings,

Andreas

On 2022-07-29 10:25, Richard Duivenvoorde via QGIS-Developer wrote:


Doing some Postgis work with QGIS, I often asked myself what queries QGIS is 
firing to the database.
I can off course log that in the database, but I was wondering if QGIS had some 
'signal' which could be use to pass the queries used to the Debugging Tools?

I skimmed QgsDataProvider, QgsVectorDataProvider and the Postgres provider, but 
I think these are not so communicative as the QGIS Network request, so I think 
it will be harder then I hoped... as always :-(

OR am I missing some signal which could be used?

Regards,

Richard Duivenvoorde

PS else this is just a nice feature request for the Debugging Tools :-)
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer 

Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer 






___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Is it possible to make QGIS show the fired queries to databases in Debugging Tools?

[Andreas Neumann via QGIS-Developer]

Hi Richard,

This should already be available in the debugging tools --> Query Logger

It was a recent QGIS grant project and developed by elpaso.

Greetings,

Andreas

On 2022-07-29 10:25, Richard Duivenvoorde via QGIS-Developer wrote:

Doing some Postgis work with QGIS, I often asked myself what queries 
QGIS is firing to the database.
I can off course log that in the database, but I was wondering if QGIS 
had some 'signal' which could be use to pass the queries used to the 
Debugging Tools?


I skimmed QgsDataProvider, QgsVectorDataProvider and the Postgres 
provider, but I think these are not so communicative as the QGIS 
Network request, so I think it will be harder then I hoped... as always 
:-(


OR am I missing some signal which could be used?

Regards,

Richard Duivenvoorde

PS else this is just a nice feature request for the Debugging Tools :-)
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Is it possible to make QGIS show the fired queries to databases in Debugging Tools?

[Richard Duivenvoorde via QGIS-Developer]

Doing some Postgis work with QGIS, I often asked myself what queries QGIS is 
firing to the database.
I can off course log that in the database, but I was wondering if QGIS had some 
'signal' which could be use to pass the queries used to the Debugging Tools?

I skimmed QgsDataProvider, QgsVectorDataProvider and the Postgres provider, but 
I think these are not so communicative as the QGIS Network request, so I think 
it will be harder then I hoped... as always :-(

OR am I missing some signal which could be used?

Regards,

Richard Duivenvoorde

PS else this is just a nice feature request for the Debugging Tools :-)
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer