<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I wrote an sql plugin for gedit a while back which was based on my
experience with Microsoft's SQL client. Basically the approach I
took, and I think this would work for geany as well, was:<br>
<ol>
<li>Manage various connections to databases and allow switching
between the connections - the connection is global to geany
(Actually, I think my first plugin only allowed one connection,
and later when I tried to remake the plugin for gedit3, I
allowed multiple connections to be managed)<br>
</li>
<li>Run queries from any open document by highlighting them and
using some keyboard shortcut and/or button</li>
<li>Display the results in a scrollable gtk table in the bottom
pane. This was especially beneficial as the ASCII presentation
from the command line is hard to see when it starts wrapping.<br>
</li>
</ol>
<p>That would be a reasonable minimum. We could extend it from
there to:<br>
</p>
<ol>
<li>Show tables in the current database on the side panel,
expandable to show the columns</li>
<li>Allow editing of the cells in the table output</li>
</ol>
<p>Some further thoughts:<br>
</p>
<ol>
<li>I used SQLAlchemy for my gedit plugin (it was in python)
because it allowed connecting to various SQL databases such as
MySQL, PostgreSQL, etc</li>
<li>If there is a way to make the output in a table on a separate
thread to not lock the UI, that would be good for larger result
sets. We could at least create some optional built in limit of
how many results.<br>
</li>
<li>A way to kill the query in progress would be good<br>
</li>
</ol>
Thanks,<br>
<br>
Steve<br>
<br>
<div class="moz-cite-prefix">On 03/24/2014 06:25 AM, Federico
Reghenzani wrote:<br>
</div>
<blockquote
cite="mid:CADf4hJJO9mWYb2gdfuwo04zhMCoDS2CgUH6WGEktxnyhT8KOkw@mail.gmail.com"
type="cite">
<div dir="ltr">+1
<div><br>
</div>
<div>do you think a simple text console (as mysql cli client) or
some kind of graphics?</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, Mar 24, 2014 at 9:47 AM,
Frank Lanitz <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:frank@frank.uvena.de" target="_blank">frank@frank.uvena.de</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hi
folks,<br>
<br>
A often wished feature at our boothes at e.g. Chemnitzer
Linux Tage were<br>
to have some kind of a SQL plugin for Geany, supporting
executing<br>
queries at the database.<br>
As I'm also looking for something like this, I'm wondering
what do you<br>
think such a plugin should be able to do in some global
view. I don't<br>
think we will be able to build up another MySQLWorkbench
or PGAdmin --<br>
and this is also not my goal for a Geany plugin -- but
most likley more<br>
than an execution of queries might would be useful.<br>
<br>
Cheers,<br>
Frank<br>
_______________________________________________<br>
Devel mailing list<br>
<a moz-do-not-send="true"
href="mailto:Devel@lists.geany.org">Devel@lists.geany.org</a><br>
<a moz-do-not-send="true"
href="https://lists.geany.org/cgi-bin/mailman/listinfo/devel"
target="_blank">https://lists.geany.org/cgi-bin/mailman/listinfo/devel</a><br>
</blockquote>
</div>
<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Devel@lists.geany.org">Devel@lists.geany.org</a>
<a class="moz-txt-link-freetext" href="https://lists.geany.org/cgi-bin/mailman/listinfo/devel">https://lists.geany.org/cgi-bin/mailman/listinfo/devel</a>
</pre>
</blockquote>
<br>
</body>
</html>