Re: [QGIS-Developer] [Qgis-user] Bug with GeoPackage and Expressions?

2021-07-28 Thread Nyall Dawson
On Thu, 29 Jul 2021 at 15:31, Matthias Kuhn wrote: > > Can you fill a bug for this? The expression compiler in QGIS should not > forward it to ogr/gpkg/sqlite in this case. My interpretation is that Calvin is setting a layer filter, so QGIS expressions aren't involved (i.e. no bug). Nyall > >

Re: [QGIS-Developer] [Qgis-user] Bug with GeoPackage and Expressions?

2021-07-28 Thread Matthias Kuhn
Can you fill a bug for this? The expression compiler in QGIS should not forward it to ogr/gpkg/sqlite in this case. Matthias On Wed, Jul 28, 2021 at 10:08 PM C Hamilton wrote: > Thanks everyone for that explanation. This does complicate the ability to > set an expression filter in a plugin

Re: [QGIS-Developer] [Qgis-user] Bug with GeoPackage and Expressions?

2021-07-28 Thread C Hamilton
Thanks everyone for that explanation. This does complicate the ability to set an expression filter in a plugin when it depends on the data source type. I'm not sure what to do about that. Regards, Calvin On Wed, Jul 28, 2021 at 8:00 PM Anita Graser wrote: > Hi Calvin, > > 28 Jul 2021 21:43:40

Re: [QGIS-Developer] Bug with GeoPackage and Expressions?

2021-07-28 Thread Even Rouault
SQLite, which is the underneath database engine for GeoPackage, doesn't support ILIKE. The SQLite LIKE operator is actually case insensitive for ASCII characters. See paragraph 5 "The LIKE, GLOB, REGEXP, and MATCH operators" of https://www.sqlite.org/lang_expr.html Le 28/07/2021 à 21:43, C

[QGIS-Developer] Bug with GeoPackage and Expressions?

2021-07-28 Thread C Hamilton
I think I found a bug and was wondering if someone could verify this. I am on Windows 10 and tried this with both QGIS 3.16.9 and 3.20.1. I tried the following filter expression on the Natural Earth data set ne_10m_populated_places (

Re: [QGIS-Developer] Monitor QGIS (Server) memory consumption per project

2021-07-28 Thread kimaidou
Hey, I updated my "audit qgis projects" processing algorithm with a quick-and-dirty method to calculate the memory usage, before and after each project reading https://gist.github.com/mdouchin/cd89a259d3560635d4bb8708ad430caa#file-lizmapauditqgisprojects-py-L150 It is not very reliable and

[QGIS-Developer] Monitor QGIS (Server) memory consumption per project

2021-07-28 Thread kimaidou
Hi all, We (@3liz.com) use QGIS Server since a long time to provide hosting services for our clients, with Lizmap Web Client (LWC) as the web map builder. Having hundred LWC instances, we pay obviously attention to metrics, and monitor the CPU, memory, requests response time, etc. We sometimes

Re: [QGIS-Developer] [Qgis-psc] Grant report: Rework handling of multi-layer, mixed-format datasets

2021-07-28 Thread kimaidou
Thanks a lot ! Regards, Michaël Le mer. 28 juil. 2021 à 09:00, Tim Sutton a écrit : > Wow great work Nyall! > > Regards > > Tim > > Sent from my iPhone > > On 28 Jul 2021, at 07:43, Paolo Cavallini wrote: > > Thanks a lot Nyall, I'm sure you did more and better work than it was > expected.

Re: [QGIS-Developer] [Qgis-psc] Grant report: Rework handling of multi-layer, mixed-format datasets

2021-07-28 Thread Tim Sutton
Wow great work Nyall! Regards Tim Sent from my iPhone > On 28 Jul 2021, at 07:43, Paolo Cavallini wrote: > > Thanks a lot Nyall, I'm sure you did more and better work than it was > expected. Our donors can be happy. > Cheers. > > Il 28 luglio 2021 07:02:30 EEST, Nyall Dawson ha >

Re: [QGIS-Developer] Grant report: Rework handling of multi-layer, mixed-format datasets

2021-07-28 Thread Paolo Cavallini
Thanks a lot Nyall, I'm sure you did more and better work than it was expected. Our donors can be happy. Cheers. Il 28 luglio 2021 07:02:30 EEST, Nyall Dawson ha scritto: >Hi lists, > >Just reporting in the conclusion of the grant work: "Rework handling >of multi-layer, mixed-format datasets".