yes, backported to latest 2.14 and 2.16 Luigi Pirelli ************************************************************************************************** * Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com * LinkedIn: https://www.linkedin.com/in/luigipirelli * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli * GitHub: https://github.com/luipir * Mastering QGIS: https://www.packtpub.com/application-development/mastering-qgis **************************************************************************************************
On 29 September 2016 at 12:47, Tyler Veinot <tylerkvei...@gmail.com> wrote: > If I upgrade to 2.16.3 will I get the bug fixes? > > On Wed, Sep 28, 2016 at 3:06 PM, Tyler Veinot <tylerkvei...@gmail.com> > wrote: >> >> Luigi; >> Thanks, I will give it a try. Also tried using using MS Access to connect >> to the SQLite database following steps I found online using an ODBC >> connection. Got no useable sqlite3.dll found. It doesn't tell me where it is >> looking or anything; the ODBC driver install did put an sqlite3.dll in the >> system32 folder so I am not sure what the issue is, if the file is not what >> access is looking for or if it is looking in the wrong spot for it; Libre >> seems to be able to find it no problem. >> Tyler >> >> On Wed, Sep 28, 2016 at 1:22 PM, Luigi Pirelli <lui...@gmail.com> wrote: >>> >>> Tyler may you try with latest backported bugfixes on sqlite ogr >>> provider? Probably related with your problem ("unable to commit >>> changes to the database"). Check if it is similar following these >>> steps: https://hub.qgis.org/issues/15351 >>> >>> regards >>> Luigi Pirelli >>> >>> >>> ************************************************************************************************** >>> * Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com >>> * LinkedIn: https://www.linkedin.com/in/luigipirelli >>> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli >>> * GitHub: https://github.com/luipir >>> * Mastering QGIS: >>> https://www.packtpub.com/application-development/mastering-qgis >>> >>> ************************************************************************************************** >>> >>> >>> On 28 September 2016 at 17:54, Tyler Veinot <tylerkvei...@gmail.com> >>> wrote: >>> > I would prefer to go with postgre but I think that is going to have to >>> > be a >>> > future project; right now we use a file geodatabase because it can be >>> > copied >>> > and distributed. Some of our PC's are disconnected from a network >>> > and/or >>> > have very limited network access. To my knowledge I cannot just copy a >>> > Postgres, MySQL, Maria, or other like databases to a PC or tablet and >>> > run >>> > them. I have run Postgre as a local service doing some testing and >>> > playing >>> > but I have no place to put it for everyone to access, thats why I am >>> > looking >>> > for a SQLite/File geodatabase type solution. >>> > SQLite's only issue is that the qgsEditRelationWidget and >>> > qgsRelationWidget >>> > don't seem to respond well to it. I have tried a number of different >>> > ways to >>> > make those features work and it always ends in either a crash with >>> > minidump >>> > or "unable to commit changes to the database". LibreBase does not >>> > acknowledge SQLite's capabilities as a database; tried it with both >>> > JDBC and >>> > ODBC drivers. I can build but cannot edit tables, will not support >>> > relations >>> > or SQL Queries containing inner, outer, or full joins. >>> > What about a GUI for SQLite? Something like Access for SQLite >>> > databases? If >>> > there was such a thing I could move the data entry to that; looks like >>> > I >>> > have some googling to do. >>> > Tyler >>> > >>> > On Wed, Sep 28, 2016 at 12:01 PM, John Harrop <jchar...@gmail.com> >>> > wrote: >>> >> >>> >> You could run it as a local server and it is available on all major >>> >> platforms. If you need a server with wider access you could look at >>> >> AWS >>> >> (even the free tier will give you some RDB service). The Postgresql >>> >> supported there has the PostGIS extension ready to load so for us it >>> >> was a >>> >> logical choice for hosting spatial data. >>> >> >>> >> John Harrop >>> >> jchar...@gmail.com >>> >> >>> >> >>> >> >>> >> > On Sep 27, 2016, at 8:09 AM, Tyler Veinot <tylerkvei...@gmail.com> >>> >> > wrote: >>> >> > >>> >> > Hello; >>> >> > I need some database options; I tried PostgreSQL, HSQL, >>> >> > SQLite/Spatialitem, Access (mdb/accdb) and what I get is either it >>> >> > works >>> >> > well with QGIS and doesn't work well at all with LibreBase or vice >>> >> > versa, >>> >> > with the exception of PostgeSQL which works well with both but I >>> >> > don't have >>> >> > a server to run it on. Are there any other databases that you can >>> >> > suggest? >>> >> > With no server at the moment I would like something that exists in a >>> >> > file in >>> >> > the same way; SQLite, Access, or file geodatabases do, but also >>> >> > compatible >>> >> > with QGIS and LibreBase. >>> >> > Thanks; >>> >> > Tyler >>> >> > _______________________________________________ >>> >> > Qgis-user mailing list >>> >> > Qgis-user@lists.osgeo.org >>> >> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user >>> >> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user >>> >> >>> > >>> > >>> > _______________________________________________ >>> > Qgis-user mailing list >>> > Qgis-user@lists.osgeo.org >>> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user >>> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user >> >> > _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user