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 <[email protected]> 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 > [email protected] > > > > > On Sep 27, 2016, at 8:09 AM, Tyler Veinot <[email protected]> > 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 > > [email protected] > > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user > >
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
