[Qgis-user] Database options

[Tyler Veinot]

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 <luipir at 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 <tylerkveinot at 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 <jcharrop at 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
> >> jcharrop at gmail.com
> >>
> >>
> >>
> >> > On Sep 27, 2016, at 8:09 AM, Tyler Veinot <tylerkveinot at 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 at 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 at lists.osgeo.org
> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160928/e874f58b/attachment.html>