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