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

[Alexandre Neto]

It's probably out of the scope of this migration, but following your idea,
I wonder if the python console/editor and underlying code could be used
also to run SQL?

A quinta, 8/09/2022, 22:13, Carlo A. Bertelli (Charta s.r.l.) <
carlo.bertelli at gmail.com> escreveu:

> 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/637f978f/attachment.htm>