<div dir="ltr">Thanks;<div>Just updated to 2.16.3, hopefully get a chance to check soon.</div><div>Tyler</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Sep 29, 2016 at 9:52 AM, Luigi Pirelli <span dir="ltr"><<a href="mailto:luipir@gmail.com" target="_blank">luipir@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">yes, backported to latest 2.14 and 2.16<br>
<span class="im HOEnZb">Luigi Pirelli<br>
<br>
******************************<wbr>******************************<wbr>******************************<wbr>********<br>
* Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com<br>
* LinkedIn: <a href="https://www.linkedin.com/in/luigipirelli" rel="noreferrer" target="_blank">https://www.linkedin.com/in/<wbr>luigipirelli</a><br>
* Stackexchange: <a href="http://gis.stackexchange.com/users/19667/luigi-pirelli" rel="noreferrer" target="_blank">http://gis.stackexchange.com/<wbr>users/19667/luigi-pirelli</a><br>
* GitHub: <a href="https://github.com/luipir" rel="noreferrer" target="_blank">https://github.com/luipir</a><br>
* Mastering QGIS:<br>
<a href="https://www.packtpub.com/application-development/mastering-qgis" rel="noreferrer" target="_blank">https://www.packtpub.com/<wbr>application-development/<wbr>mastering-qgis</a><br>
******************************<wbr>******************************<wbr>******************************<wbr>********<br>
<br>
<br>
</span><div class="HOEnZb"><div class="h5">On 29 September 2016 at 12:47, Tyler Veinot <<a href="mailto:tylerkveinot@gmail.com">tylerkveinot@gmail.com</a>> wrote:<br>
> If I upgrade to 2.16.3 will I get the bug fixes?<br>
><br>
> On Wed, Sep 28, 2016 at 3:06 PM, Tyler Veinot <<a href="mailto:tylerkveinot@gmail.com">tylerkveinot@gmail.com</a>><br>
> wrote:<br>
>><br>
>> Luigi;<br>
>> Thanks, I will give it a try. Also tried using using MS Access to connect<br>
>> to the SQLite database following steps I found online using an ODBC<br>
>> connection. Got no useable sqlite3.dll found. It doesn't tell me where it is<br>
>> looking or anything; the ODBC driver install did put an sqlite3.dll in the<br>
>> system32 folder so I am not sure what the issue is, if the file is not what<br>
>> access is looking for or if it is looking in the wrong spot for it; Libre<br>
>> seems to be able to find it no problem.<br>
>> Tyler<br>
>><br>
>> On Wed, Sep 28, 2016 at 1:22 PM, Luigi Pirelli <<a href="mailto:luipir@gmail.com">luipir@gmail.com</a>> wrote:<br>
>>><br>
>>> Tyler may you try with latest backported bugfixes on sqlite ogr<br>
>>> provider? Probably related with your problem ("unable to commit<br>
>>> changes to the database"). Check if it is similar following these<br>
>>> steps: <a href="https://hub.qgis.org/issues/15351" rel="noreferrer" target="_blank">https://hub.qgis.org/issues/<wbr>15351</a><br>
>>><br>
>>> regards<br>
>>> Luigi Pirelli<br>
>>><br>
>>><br>
>>> ******************************<wbr>******************************<wbr>******************************<wbr>********<br>
>>> * Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com<br>
>>> * LinkedIn: <a href="https://www.linkedin.com/in/luigipirelli" rel="noreferrer" target="_blank">https://www.linkedin.com/in/<wbr>luigipirelli</a><br>
>>> * Stackexchange: <a href="http://gis.stackexchange.com/users/19667/luigi-pirelli" rel="noreferrer" target="_blank">http://gis.stackexchange.com/<wbr>users/19667/luigi-pirelli</a><br>
>>> * GitHub: <a href="https://github.com/luipir" rel="noreferrer" target="_blank">https://github.com/luipir</a><br>
>>> * Mastering QGIS:<br>
>>> <a href="https://www.packtpub.com/application-development/mastering-qgis" rel="noreferrer" target="_blank">https://www.packtpub.com/<wbr>application-development/<wbr>mastering-qgis</a><br>
>>><br>
>>> ******************************<wbr>******************************<wbr>******************************<wbr>********<br>
>>><br>
>>><br>
>>> On 28 September 2016 at 17:54, Tyler Veinot <<a href="mailto:tylerkveinot@gmail.com">tylerkveinot@gmail.com</a>><br>
>>> wrote:<br>
>>> > I would prefer to go with postgre but I think that is going to have to<br>
>>> > be a<br>
>>> > future project; right now we use a file geodatabase because it can be<br>
>>> > copied<br>
>>> > and distributed. Some of our PC's are disconnected from a network<br>
>>> > and/or<br>
>>> > have very limited network access. To my knowledge I cannot just copy a<br>
>>> > Postgres, MySQL, Maria, or other like databases to a PC or tablet and<br>
>>> > run<br>
>>> > them. I have run Postgre as a local service doing some testing and<br>
>>> > playing<br>
>>> > but I have no place to put it for everyone to access, thats why I am<br>
>>> > looking<br>
>>> > for a SQLite/File geodatabase type solution.<br>
>>> > SQLite's only issue is that the qgsEditRelationWidget and<br>
>>> > qgsRelationWidget<br>
>>> > don't seem to respond well to it. I have tried a number of different<br>
>>> > ways to<br>
>>> > make those features work and it always ends in either a crash with<br>
>>> > minidump<br>
>>> > or "unable to commit changes to the database". LibreBase does not<br>
>>> > acknowledge SQLite's capabilities as a database; tried it with both<br>
>>> > JDBC and<br>
>>> > ODBC drivers. I can build but cannot edit tables, will not support<br>
>>> > relations<br>
>>> > or SQL Queries containing inner, outer, or full joins.<br>
>>> > What about a GUI for SQLite? Something like Access for SQLite<br>
>>> > databases? If<br>
>>> > there was such a thing I could move the data entry to that; looks like<br>
>>> > I<br>
>>> > have some googling to do.<br>
>>> > Tyler<br>
>>> ><br>
>>> > On Wed, Sep 28, 2016 at 12:01 PM, John Harrop <<a href="mailto:jcharrop@gmail.com">jcharrop@gmail.com</a>><br>
>>> > wrote:<br>
>>> >><br>
>>> >> You could run it as a local server and it is available on all major<br>
>>> >> platforms. If you need a server with wider access you could look at<br>
>>> >> AWS<br>
>>> >> (even the free tier will give you some RDB service). The Postgresql<br>
>>> >> supported there has the PostGIS extension ready to load so for us it<br>
>>> >> was a<br>
>>> >> logical choice for hosting spatial data.<br>
>>> >><br>
>>> >> John Harrop<br>
>>> >> <a href="mailto:jcharrop@gmail.com">jcharrop@gmail.com</a><br>
>>> >><br>
>>> >><br>
>>> >><br>
>>> >> > On Sep 27, 2016, at 8:09 AM, Tyler Veinot <<a href="mailto:tylerkveinot@gmail.com">tylerkveinot@gmail.com</a>><br>
>>> >> > wrote:<br>
>>> >> ><br>
>>> >> > Hello;<br>
>>> >> > I need some database options; I tried PostgreSQL, HSQL,<br>
>>> >> > SQLite/Spatialitem, Access (mdb/accdb) and what I get is either it<br>
>>> >> > works<br>
>>> >> > well with QGIS and doesn't work well at all with LibreBase or vice<br>
>>> >> > versa,<br>
>>> >> > with the exception of PostgeSQL which works well with both but I<br>
>>> >> > don't have<br>
>>> >> > a server to run it on. Are there any other databases that you can<br>
>>> >> > suggest?<br>
>>> >> > With no server at the moment I would like something that exists in a<br>
>>> >> > file in<br>
>>> >> > the same way; SQLite, Access, or file geodatabases do, but also<br>
>>> >> > compatible<br>
>>> >> > with QGIS and LibreBase.<br>
>>> >> > Thanks;<br>
>>> >> > Tyler<br>
>>> >> > ______________________________<wbr>_________________<br>
>>> >> > Qgis-user mailing list<br>
>>> >> > <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
>>> >> > List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/qgis-user</a><br>
>>> >> > Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/qgis-user</a><br>
>>> >><br>
>>> ><br>
>>> ><br>
>>> > ______________________________<wbr>_________________<br>
>>> > Qgis-user mailing list<br>
>>> > <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
>>> > List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/qgis-user</a><br>
>>> > Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/qgis-user</a><br>
>><br>
>><br>
><br>
</div></div></blockquote></div><br></div>