[Qgis-user] Database options

[Luigi Pirelli]

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
>>
>>
>