If I upgrade to 2.16.3 will I get the bug fixes? On Wed, Sep 28, 2016 at 3:06 PM, Tyler Veinot <[email protected]> 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 <[email protected]> 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 <[email protected]> >> 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 <[email protected]> >> 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 >> >> [email protected] >> >> >> >> >> >> >> >> > On Sep 27, 2016, at 8:09 AM, Tyler Veinot <[email protected]> >> >> > 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 >> >> > [email protected] >> >> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user >> >> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user >> >> >> > >> > >> > _______________________________________________ >> > Qgis-user mailing list >> > [email protected] >> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user >> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user >> > >
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
