[Qgis-user] Database options

[Luigi Pirelli]

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