Nice Alessandro! Just tested and work flawlessly on Postgres and Gpkg (others I did not test yet...). (one issue, see below)
As the DB Manager plugin has issues with me, I am wondering what the 'future' is of that part of QGIS? (in certain combi's of sip/qt it kills QGIS [0]) In another DB Manager related thread this month [1], Sandro mentioned he used it in a plugin, and Paolo said he used it in trainings. So I'm wondering what others think we should do with it... Which functionalities are still missing/wanted/needed? Most important one is the sql window? And you can delete and create triggers and indexes? Maybe the 'load data' button? Although I really like the sql window for quick demo's :-), I'm ok with 'whatever', AS it is a plugin I will just disable it for now. ISSUE: One (potential) issue I found in using the context menu in the 'DataSource Manager -- Browser' dialog: - if you select 'Layer Properties' in the Browser dialog for a db, those Layer Properties (with me) popup *behind* the modal 'DataSource Manager -- Browser' window. So then you cannot use/close it, only AFTER you close the DataSource Manager. I created an issue [2] Regards & Thanks for this work! Richard Duivenvoorde [0] https://github.com/qgis/QGIS/issues/38393 [1] https://lists.osgeo.org/pipermail/qgis-developer/2020-September/062261.html [2] https://github.com/qgis/QGIS/issues/39094 On 9/29/20 9:14 AM, Alessandro Pasotti wrote: > Hi, > > this is the final report about the implementation of the QEP > https://github.com/qgis/QGIS-Enhancement-Proposals/issues/171 > > The QGIS browser now exposes a new "Fields" item for vector layers > that can be expanded to show the underlying fields, an icon identifies > the base field type. > > A context menu is available at the fields root level and allows you to > create a new field. > A context menu is available at the individual fields level and allows > you to delete the selected field. > > At the connection level a new context menu item is available and > allows you to create a new table for all DB connections that support > the Connections API: > - PG > - Spatialite > - GPKG > - MSSQL > > All the new functions are implemented using the new connections API > and exposed to Python for plugins/scripts. > > There have been many other small improvements in the API and in the > browser as part of this work such as homogenization of the > error/warning/success reporting (now using the message bar if > available and falling back to a dialog if it is not available) and new > context menu entries. > > The following functions are now available in the browser tree using a > common abstraction API: > > - create a new schema > - delete a schema > - rename a schema > - create a new table/layer > - rename table/layer > - delete a table/layer > - truncate a table/layer > - refresh a materialized view > - list fields for a table/view > - add a new field > - delete a field > > Thank you to the QGIS project and to all QGIS sponsors and donors that > made this possible, a special thank goes to Nyall Dawson who helped in > the design of the API and reviewed the code. > > Kind regards. > _______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
