[Qgis-user] Database options
Tyler Veinot
tylerkveinot at gmail.com
Thu Sep 29 03:47:37 PDT 2016
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/74dce838/attachment.html>
More information about the Qgis-user
mailing list