[QGIS-Developer] Time for db manager to become an "opt-in" plugin?

[Carlo A. Bertelli (Charta s.r.l.)]

This decision makes sense to me, but I still miss an SQL interface – I mean
an SQL-oriented interface for data as GDAL does even for unnecessary cases.
QGIS has a python-first approach but I don't think this should be the only
or the mandatory way to approach GIS data.

Alexandre Neto says:

> I am big QGIS/PostGIS user and DB manager in QGIS allows me to do
> something that you can't do elsewhere, run long spatial analysis using SQL.

while Richard Duivenvoorde replies:

> My de facto client is DBeaver, a cross platform FOSS general Database
> client (written in Java).
> It even has a simple spatial viewer (as: show geometries on OSM, both for
> Postgis and Geopackages) in the data tabs.


 DBeaver is a great tool if you have to move data from one DBMS to another
and has even a simple geometry viewer, but what I think QGIS should provide
is a data-oriented interface, something that could mix procedural tools
that work on the client with dbms resident functions. In reality, if you
deal with data and resort to views based on native Postgis functions, it's
much better to have a good SQL interface in QGIS than simply visualising
geometries in DBeaver. Let alone, as Paolo Cavallini says, using topology.
Nothing against the idea of a better integration that implies an optional
role of the plug-in, but the outcome is an implicit choice for a
traditional client-server approach vs a well-balanced orientation we
enjoyed. I would appreciate a move in the opposite direction, but it's only
a personal preference.

On Thu, Sep 8, 2022 at 4:33 PM Alexandre Neto via QGIS-Developer <
qgis-developer at lists.osgeo.org> wrote:

> Yes, ti seems to. thanks!
>
> Nyall Dawson <nyall.dawson at gmail.com> escreveu no dia quinta, 8/09/2022
> à(s) 10:16:
>
>> On Thu, 8 Sept 2022 at 19:08, Alexandre Neto via QGIS-Developer
>> <qgis-developer at lists.osgeo.org> wrote:
>> >
>> > Hi,
>> >
>> > In the end, Richard ended up closing the project. But I was able to
>> create a new one. Can someone with QGIS organization owner privileges
>> please make it public?
>>
>> Done, I think ...
>>
>> Nyall
>>
>> >
>> > https://github.com/orgs/qgis/projects/3/settings
>> >
>> > Thanks
>> >
>> > Alexandre Neto
>> >
>> >
>> > Richard Duivenvoorde via QGIS-Developer <qgis-developer at lists.osgeo.org>
>> escreveu no dia quarta, 7/09/2022 à(s) 16:02:
>> >>
>> >> On 9/7/22 14:52, Alexandre Neto via QGIS-Developer wrote:
>> >> > Hi
>> >> >
>> >> > Can anyone please create a github project for dbmanager migration? I
>> don't have enough permissions for it.
>> >>
>> >> I had never heard of 'projects'... but Alexandre helpt me to create:
>> >>
>> >> https://github.com/orgs/qgis/projects/1
>> >>
>> >> Please let me know if it works...
>> >>
>> >> Regards,
>> >>
>> >> Richard Duivenvoorde
>> >>
>> >> _______________________________________________
>> >> QGIS-Developer mailing list
>> >> QGIS-Developer at lists.osgeo.org
>> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> >
>> > _______________________________________________
>> > QGIS-Developer mailing list
>> > QGIS-Developer at lists.osgeo.org
>> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20220908/23fec9f6/attachment.htm>