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

Thu Sep 8 14:47:40 PDT 2022

I don't think so. I think the python console has its specific function by
now. I think an SQL interface should provide different functions and
integrations, maybe based on GDAL that seems less and less important and
may play a stronger role as Spatialite.
At the same time, I understand that having two consoles may be confusing
for some of us.
Maybe it's just a boomers' approach, I would love even getting a bash
interface, a lua and a node one because they serve different approaches...
;.)

On Thu, Sep 8, 2022 at 11:34 PM Alexandre Neto <senhor.neto at gmail.com>
wrote:

> 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/c12db724/attachment-0001.htm>