Re: [Qgis-user] File based Geopackage bugs

2021-02-04 Thread Patrick Dunford
Thanks for you comment, however I did not see a reference to the issue of data loss when changing table structure (dropping columns etc). On 3/02/21 11:36 am, Nyall Dawson wrote: On Tue, 2 Feb 2021 at 12:12, Patrick Dunford wrote: I recall going back someway we were sold this Geopackage idea

Re: [Qgis-user] File based Geopackage bugs

2021-02-03 Thread Patrick Dunford
Hi Bernd Thanks for your comments As a previous commenter wrote, Spatialite also uses a similar format to Geopackage being also based on SQLite. So far in my testing of Spatialite I have found it to have neither issue. Spatialite converted from Geopackage creates another field called

Re: [Qgis-user] File based Geopackage bugs

2021-02-02 Thread Nyall Dawson
On Tue, 2 Feb 2021 at 12:12, Patrick Dunford wrote: > > I recall going back someway we were sold this Geopackage idea being > implemented into Qgis because it was going to be so much better than > shape files that everyone has been using up to now. I bought into these > ideas by converting shape

Re: [Qgis-user] File based Geopackage bugs

2021-02-02 Thread Patrick Dunford
I filed a bug report last week for the second problem, but it surely must have been previously reported. On 3/02/21 3:06 am, Bernd Vogelgesang wrote: for 2. I found a "workaround": As far as I remember, copy/paste works, but when trying to save, you get this warning/error. In the attribute

Re: [Qgis-user] File based Geopackage bugs

2021-02-02 Thread Bernd Vogelgesang
for 2. I found a "workaround": As far as I remember, copy/paste works, but when trying to save, you get this warning/error. In the attribute table, I pick the "fid" column, enter "$id" and perform "update all". After that the layer can be saved. A novice user will never come to that solution by

Re: [Qgis-user] File based Geopackage bugs

2021-02-02 Thread Alexandre Neto
Hello Patrick, Yes, there are (were?) some glitches while working with geopackages. But a lot of fixes and improvements have been made in recent releases. I remember a thread in a mailing list about the fid annoyances, but I am not sure what was the decision. Regarding geopackage vs spatialite:

[Qgis-user] File based Geopackage bugs

2021-02-01 Thread Patrick Dunford
I recall going back someway we were sold this Geopackage idea being implemented into Qgis because it was going to be so much better than shape files that everyone has been using up to now. I bought into these ideas by converting shape files in most of my Qgis projects into Geopackage files.