<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Hello,<br>
<br>
I fully support that -1<br>
<br>
I submitted a feature request some weeks ago to suggest that
Explorer SQL functionalities should work on a non modal way :<br>
<a class="moz-txt-link-freetext" href="https://github.com/qgis/QGIS/issues/49091">https://github.com/qgis/QGIS/issues/49091</a><br>
<pre class="moz-signature" cols="72">--
Christophe Damour
</pre>
<div class="moz-cite-prefix">Le 10/07/2022 à 03:02, Alexandre Neto
via QGIS-Developer a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CA+H0G_HU7DO+y3dWZHgavYPS-KDrbu9As3P_586RrLWXfbTiZg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="auto">Hello all,
<div dir="auto"><br>
</div>
<div dir="auto">-1 for me<br>
<div dir="auto"><br>
</div>
<div dir="auto">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.</div>
<div dir="auto"><br>
</div>
<div dir="auto">I understand the development reasons for
removing db manager from the official release and I really
enjoy all the effort that Alessandro put to bring most
functionality to the browser. Nevertheless, I don't think it
fully replaces db manager querying functionality, and I
really don't think it will ever do.</div>
<div dir="auto"><br>
</div>
<div dir="auto">The execute SQL dialog is great and amazingly
fast, but it doesn't replace the db manager editor. The QGIS
SQL Editor (db manager or not) needs to be an independent
window that one can keep open for as long as needed to
develop and run queries step by step, see the results, load
them in the project, re-run etc... Also, it is almost
mandatory that the user, while having the SQL script open,
can check tables details, like column names, preview their
values, etc... to help write the queries. We need an
independent window or in the limit a panel to allow that
together with the browser panel.</div>
<div dir="auto"><br>
</div>
<div dir="auto">This db manager functionality is unique, and
is (in my opinion) one of the reasons why QGIS is PostGIS de
facto client.</div>
<div dir="auto"><br>
</div>
<div dir="auto">There are other minor functionality that is
still not present, but can be added later, like being able
to create and manage constraints. Or easily create a view
from a query.</div>
<div dir="auto"><br>
</div>
<div dir="auto">I understand that for now the functionality I
miss would be available as an external plugin, but, not
being in core, soon it will just stop working, and no one
will care. QGIS was born as PostGIS query and visualiser
client, in my humble opinion, by removing db manager at
these stage we are downgrading QGIS functionality.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Thanks,</div>
<div dir="auto"><br>
</div>
<div dir="auto">Alexandre Neto</div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">A sexta, 8/07/2022, 18:12,
Paolo Cavallini via QGIS-Developer <<a
href="mailto:qgis-developer@lists.osgeo.org" target="_blank"
rel="noreferrer" moz-do-not-send="true"
class="moz-txt-link-freetext">qgis-developer@lists.osgeo.org</a>>
escreveu:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hi all,<br>
are we going to implement this? Apparently nobody objects.<br>
I'd add to the list the Topology sub plugin by strk. Probably
not widely<br>
used, but an unique feature.<br>
I confirm that in the meantime the table historicization has
been<br>
broken, one more reason for not shipping DB Manager in the
current state.<br>
Cheers.<br>
<br>
Il 22/06/22 07:55, Nyall Dawson ha scritto:<br>
<br>
> - Saving/re-running previously saved SQL queries<br>
<br>
very useful to me. also loading the result of a query as a new
layer<br>
<br>
> - Switching to the simplified "SQL builder" dialog for
creating a SQL query<br>
> - Truncating a table (this is available through a
Processing<br>
> algorithm, just not via browser)<br>
> - Attribute index creation (this is available through a
Processing<br>
> algorithm, just not via browser)<br>
<br>
handy but not crucial<br>
<br>
> - !! Support for editing an existing column (changing
name/type). This<br>
> is the biggest functionality gap -- changing existing
column types is<br>
> not available elsewhere in QGIS<br>
> - Listing database triggers<br>
<br>
I'd add storicization of a table - I couldn't find anything
easier for this.<br>
<br>
Cheers.<br>
-- <br>
Paolo Cavallini<br>
<a href="http://www.faunalia.eu" rel="noreferrer noreferrer
noreferrer" target="_blank" moz-do-not-send="true">www.faunalia.eu</a>
- QGIS.org<br>
training, support, development on QGIS, PostGIS and more<br>
_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org"
rel="noreferrer noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-developer"
rel="noreferrer noreferrer noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-developer"
rel="noreferrer noreferrer noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
</blockquote>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
QGIS-Developer mailing list
<a class="moz-txt-link-abbreviated" href="mailto:QGIS-Developer@lists.osgeo.org">QGIS-Developer@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-developer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-developer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a>
</pre>
</blockquote>
<br>
</body>
</html>