Re: [Qgis-user] Database options

Alex; I was under the impression that the qgisRelationReferenceWidget and the qgisRelationEditorWidget could handle m:n relationships. From what you are saying I am not looking at building them in a Form using qt I am looking at building a complete python plugin to handle those m:n relationships;

Re: [Qgis-user] Database options

You have to implement m:n relationships yourself inside of your plugin if you need that. I recommend trying to use an ORM like sql-alchemy to make life easier. FYI there's also some cool Offline plugins that let you take Postgis tables offline in a temporary spatialite db, and then sync when back

Re: [Qgis-user] Database options

GeoPackage might have some utility - especially in being able to package up data and share it (http://www.geopackage.org/). I haven't used it at all, but have thought about it as I'm trying to make data more usable across users and platforms... (It stores data in a SQLite db, and has support via

Re: [Qgis-user] Database options

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 wrote: > yes, backported to latest 2.14 and 2.16 > Luigi Pirelli > > >

Re: [Qgis-user] Database options

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:

Re: [Qgis-user] Database options

If I upgrade to 2.16.3 will I get the bug fixes? On Wed, Sep 28, 2016 at 3:06 PM, Tyler Veinot 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.

Re: [Qgis-user] Database options

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

Re: [Qgis-user] Database options

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

Re: [Qgis-user] Database options

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

Re: [Qgis-user] Database options

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

Re: [Qgis-user] Database options

com> To: QGIS User List <qgis-user@lists.osgeo.org> Sent: Wednesday, September 28, 2016 4:09 AM Subject: [Qgis-user] Database options 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

[Qgis-user] Database options

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