[Qgis-user] Database options

[Tyler Veinot]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160928/fe4c3294/attachment.html>