Re: [Qgis-user] Database options

[Tyler Veinot]

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; Do you
know of any plugins that do this so I can look at how they were put
together? Online reference manuals/tutorials?
I have been searching this quite a bit over the last few months, founds
lots dealing with 1:m relationships but only short discussions on m:n
relationships and handling them. I do have an idea as to what I am doing; I
can get this sort of thing working in other packages. My specific troubles
are getting similar functionality working in QGIS.
Tyler

On Fri, Sep 30, 2016 at 4:06 PM, Alex M  wrote:

> 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
> online.
>
> Thanks,
> Alex
>
> On 09/30/2016 11:37 AM, Tyler Veinot wrote:
> > That was my thought for a solution, do the data entry in QGIS and use
> that
> > as the primary got to for entry and data retrieval using data entry forms
> > and widgets. Issue has been the m:n relationships. I downloaded
> postgreSQL
> > portable to try and since upgrading to 2.16.3 I have not tried my SQLite
> > forms to see if they work better as of yet; hoping to get to it this
> > weekend but I got quite a bit of work to do before I can get back to it.
> > Likely going to have to go with PostgreSQL; it is the only one that works
> > well with both platforms.
> > Tyler
> >
> > On Fri, Sep 30, 2016 at 2:27 PM, Alex M 
> wrote:
> >
> >> I looked for this unicorn many moons ago. It sadly doesn't exist. I have
> >> not found any interface quite like Access (which I have successfully
> >> used via ODBC to sqlite). Libre Base comes close but there's been many
> >> years of them saying they'd implement sqlite as a 1st class db and no
> >> movement, they always prefer Java based solutions it seems.
> >>
> >> The conclusion I reached is that you need either a web or local
> >> interface to your db. For data entry I looked into writing a custom
> >> Python application with the widgets I wanted for data entry, a node type
> >> app could work also (share code between a web interface and desktop
> >> interface). One option would be to make custom forms, or a plugin for
> >> QGIS and do all your data entry there.
> >>
> >> For writing queries there's lots of GUI tools, I usually use Spatialite
> >> GUI, QGIS QSpatialite Plugin, or Firefox SQLite Manager (non-spatial
> >> queries only). But both of these would be terrible for mass data entry.
> >>
> >> You could also, do a spreadsheet->csv->db script
> >>
> >> Thanks,
> >> Alex
> >>
> >> On 09/28/2016 11:06 AM, 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. 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 
> 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 
>  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
> >> 

Re: [Qgis-user] Database options

[Alex M]

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 online.

Thanks,
Alex

On 09/30/2016 11:37 AM, Tyler Veinot wrote:
> That was my thought for a solution, do the data entry in QGIS and use that
> as the primary got to for entry and data retrieval using data entry forms
> and widgets. Issue has been the m:n relationships. I downloaded postgreSQL
> portable to try and since upgrading to 2.16.3 I have not tried my SQLite
> forms to see if they work better as of yet; hoping to get to it this
> weekend but I got quite a bit of work to do before I can get back to it.
> Likely going to have to go with PostgreSQL; it is the only one that works
> well with both platforms.
> Tyler
> 
> On Fri, Sep 30, 2016 at 2:27 PM, Alex M  wrote:
> 
>> I looked for this unicorn many moons ago. It sadly doesn't exist. I have
>> not found any interface quite like Access (which I have successfully
>> used via ODBC to sqlite). Libre Base comes close but there's been many
>> years of them saying they'd implement sqlite as a 1st class db and no
>> movement, they always prefer Java based solutions it seems.
>>
>> The conclusion I reached is that you need either a web or local
>> interface to your db. For data entry I looked into writing a custom
>> Python application with the widgets I wanted for data entry, a node type
>> app could work also (share code between a web interface and desktop
>> interface). One option would be to make custom forms, or a plugin for
>> QGIS and do all your data entry there.
>>
>> For writing queries there's lots of GUI tools, I usually use Spatialite
>> GUI, QGIS QSpatialite Plugin, or Firefox SQLite Manager (non-spatial
>> queries only). But both of these would be terrible for mass data entry.
>>
>> You could also, do a spreadsheet->csv->db script
>>
>> Thanks,
>> Alex
>>
>> On 09/28/2016 11:06 AM, 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. 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  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 
 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
>> 

Re: [Qgis-user] Database options

[Michael Treglia]

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
GDAL/QGIS, ESRI, and many other interfaces.)

Hope that helps - I'd be curious to hear others' experiences in working
with GeoPackage dbs
Mike

On Fri, Sep 30, 2016 at 2:37 PM, Tyler Veinot 
wrote:

> That was my thought for a solution, do the data entry in QGIS and use that
> as the primary got to for entry and data retrieval using data entry forms
> and widgets. Issue has been the m:n relationships. I downloaded postgreSQL
> portable to try and since upgrading to 2.16.3 I have not tried my SQLite
> forms to see if they work better as of yet; hoping to get to it this
> weekend but I got quite a bit of work to do before I can get back to it.
> Likely going to have to go with PostgreSQL; it is the only one that works
> well with both platforms.
> Tyler
>
> On Fri, Sep 30, 2016 at 2:27 PM, Alex M 
> wrote:
>
>> I looked for this unicorn many moons ago. It sadly doesn't exist. I have
>> not found any interface quite like Access (which I have successfully
>> used via ODBC to sqlite). Libre Base comes close but there's been many
>> years of them saying they'd implement sqlite as a 1st class db and no
>> movement, they always prefer Java based solutions it seems.
>>
>> The conclusion I reached is that you need either a web or local
>> interface to your db. For data entry I looked into writing a custom
>> Python application with the widgets I wanted for data entry, a node type
>> app could work also (share code between a web interface and desktop
>> interface). One option would be to make custom forms, or a plugin for
>> QGIS and do all your data entry there.
>>
>> For writing queries there's lots of GUI tools, I usually use Spatialite
>> GUI, QGIS QSpatialite Plugin, or Firefox SQLite Manager (non-spatial
>> queries only). But both of these would be terrible for mass data entry.
>>
>> You could also, do a spreadsheet->csv->db script
>>
>> Thanks,
>> Alex
>>
>> On 09/28/2016 11:06 AM, 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. 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 
>> 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/u
>> sers/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 
>> >> 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

Re: [Qgis-user] Database options

[Tyler Veinot]

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
>
> 
> **
> * 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 29 September 2016 at 12:47, Tyler Veinot 
> wrote:
> > 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. 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 
> 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 
> >>> 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 
> >>> > 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
> >>> >> jchar...@gmail.com
> >>> >>
> >>> >>
> >>> >>
> >>> >> > On Sep 27, 2016, at 8:09 AM, Tyler Veinot  >
> >>> >> > wrote:
> >>> >> >
> >>> >> > Hello;
> >>> >> > I need some database options; I tried PostgreSQL, HSQL,
> >>> >> > SQLite/Spatialitem, Access (mdb/accdb) and what I get is either it
> >>> >> > works
> >>> 

Re: [Qgis-user] Database options

[Luigi Pirelli]

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: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Mastering QGIS:
https://www.packtpub.com/application-development/mastering-qgis
**


On 29 September 2016 at 12:47, Tyler Veinot  wrote:
> 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. 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  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 
>>> 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 
>>> > 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
>>> >> jchar...@gmail.com
>>> >>
>>> >>
>>> >>
>>> >> > On Sep 27, 2016, at 8:09 AM, Tyler Veinot 
>>> >> > 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, 

Re: [Qgis-user] Database options

[Tyler Veinot]

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. 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  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 
>> 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 
>> 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
>> >> jchar...@gmail.com
>> >>
>> >>
>> >>
>> >> > On Sep 27, 2016, at 8:09 AM, Tyler Veinot 
>> >> > 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@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@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@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: 

Re: [Qgis-user] Database options

[Tyler Veinot]

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  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 
> 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 
> 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
> >> jchar...@gmail.com
> >>
> >>
> >>
> >> > On Sep 27, 2016, at 8:09 AM, Tyler Veinot 
> >> > 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@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@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@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [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  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  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
>> jchar...@gmail.com
>>
>>
>>
>> > On Sep 27, 2016, at 8:09 AM, Tyler Veinot 
>> > 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@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@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@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [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  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
> jchar...@gmail.com
>
>
>
> > On Sep 27, 2016, at 8:09 AM, Tyler Veinot 
> 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@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@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Database options

[John Harrop]

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
jchar...@gmail.com



> On Sep 27, 2016, at 8:09 AM, Tyler Veinot  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@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@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Database options

[Brent Wood]

Hi,
You can use Spatialite with both - by accessing the db via odbc in LibreOffice. 
This is describes OS X, but should work elsewhere as well. See:
https://www.andrewheiss.com/blog/2016/02/10/libreoffice-base-sqlite-odbc-osx/
Cheers
Brent Wood


  From: Tyler Veinot 
 To: QGIS User List  
 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 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@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@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user