[QGIS-Developer] Warning: auto-transaction groups is broken for recent GDAL versions

[Alessandro Pasotti]

Hi Andreas,

I spoke briefly to Even and we agreed that I could use the QGIS funds to
work on a GDAL implementation initially limited to SQLite-based drivers.


I don't have a cost estimate yet but I will have a look before the end of
the year.

Thanks for the proposal.

Il mar 17 dic 2024, 08:53 Andreas Neumann <andreas at qgis.org> ha scritto:

> Hi,
>
> If we can find a developer who could work on this then we can fund it
> directly from QGIS.ORG.
>
> We had so far quite a bit more income than expenses in 2024 and I am
> looking for meaningful ways to spend additional QGIS funds.
>
> Thanks,
> Andreas
>
> On Tue, 17 Dec 2024 at 08:40, Alessandro Pasotti via QGIS-Developer <
> qgis-developer at lists.osgeo.org> wrote:
>
>>
>> Can/should we fix it upstream in GDAL?
>>
>> On Tue, Dec 17, 2024 at 2:12 AM Even Rouault via QGIS-Developer <
>> qgis-developer at lists.osgeo.org> wrote:
>>
>>> It is *partly* broken, that is if you change the structure of tables by
>>> adding/altering/removing columns. within a transaction group. If
>>> adding/updating/deleting features only, which I suspect covers most use
>>> cases, that should be fine.
>>>
>>> Le 17/12/2024 à 00:11, Nyall Dawson via QGIS-Developer a écrit :
>>> > Hi list,
>>> >
>>> > Just want to draw attention to
>>> > https://github.com/qgis/QGIS/pull/59797#issuecomment-2544133498 . In
>>> > short, the "auto transaction group" functionality is BROKEN when used
>>> > with sqlite/geopackage files when used with newer GDAL versions.
>>> >
>>> > This IS NOT a GDAL issue, but rather just a "happy accident" that this
>>> > functionality ever worked (QGIS is misusing GDAL API for this
>>> > feature).
>>> >
>>> > There's a non-trivial amount of work to do in refactoring this feature
>>> > to get it working again. If you're interested in seeing this
>>> > functionality fixed, please read the above linked thread for all the
>>> > diagnostic work that Even and myself have already done and hints on
>>> > how it could possibly be fixed.
>>> >
>>> > Accordingly, in https://github.com/qgis/QGIS/pull/59910 I propose to
>>> > disable the corresponding test, which is currently blocking upgrading
>>> > CI infrastructure to newer Ubuntu/Fedora releases.
>>> >
>>> > Nyall
>>> > _______________________________________________
>>> > QGIS-Developer mailing list
>>> > QGIS-Developer at lists.osgeo.org
>>> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>
>>> --
>>> http://www.spatialys.com
>>> My software is free, but my time generally not.
>>> Butcher of all kinds of standards, open or closed formats. At the end,
>>> this is just about bytes.
>>>
>>> _______________________________________________
>>> QGIS-Developer mailing list
>>> QGIS-Developer at 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 at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
>
>
> --
>
> --
> Andreas Neumann
> QGIS.ORG board member (treasurer)
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20241217/7565cc8f/attachment-0001.htm>