[Qgis-user] Database options

Thu Sep 29 06:22:42 PDT 2016

Thanks;
Just updated to 2.16.3, hopefully get a chance to check soon.
Tyler

On Thu, Sep 29, 2016 at 9:52 AM, Luigi Pirelli <luipir at gmail.com> wrote:

> 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 <tylerkveinot at 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 <tylerkveinot at 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 <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/20160929/bc905938/attachment.html>