Unix Technical Forum

Re: Patch: Query favourites

This is a discussion on Re: Patch: Query favourites within the pgsql Interfaces Pgadmin Hackers forums, part of the PostgreSQL category; --> > >This patch adds a favourites menu to the query tool, where one can > >store often-used queries. > ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 05:56 PM
Magnus Hagander
 
Posts: n/a
Default Re: Patch: Query favourites

> >This patch adds a favourites menu to the query tool, where one can
> >store often-used queries.
> >
> >It brings along build dependencies on wxxml2
> >(http://wxcode.sourceforge.net/components/wxxml2/) and

> libxml2 (which
> >comes from the first).
> >

> The tradeoff between additional benefit (you can already
> store often-used queries in standard files) and increased wx
> dependencies (actually not wx but wxcode, which can make it a
> nightmare dealing with
> distributions) makes this patch really expensive. IMNSHO, too
> expensive.


Seems I cause a lot of nightmares these days.

Anyway, it could be rewritten to either not use XML at all, or to not
use wxxml (say by linking directly to libxml, which is likely to be on
the system already considering how many packages use it). It just makes
it easier when you don't have to maintain the code youself.

Using xml makes it a whole lot easier (no need to deal with escaping,
structuring, etc yourself), especially if you can foresee other places
to use it. But it's by no means a requirement.

As for the fact that you can already store them in standard files - sure
you can. It's a matter of convenience. If we don't care about
convenience, we can just use psql and get rid of most of pgadmin. (which
I don't think is a good idea, btw. Convenience is, imho, what pgadmin is
supposed to be all about)

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-17-2008, 05:56 PM
Andreas Pflug
 
Posts: n/a
Default Re: Patch: Query favourites

Magnus Hagander wrote:

>
>Anyway, it could be rewritten to either not use XML at all, or to not
>use wxxml (say by linking directly to libxml, which is likely to be on
>the system already considering how many packages use it). It just makes
>it easier when you don't have to maintain the code youself.
>
>

There must be some XML stuff in std wx, since XRC uses XML, dunno how
reusable that is.

>As for the fact that you can already store them in standard files - sure
>you can. It's a matter of convenience.
>

Still appears as a duplication of features. What's wrong with "recent
files"?
Actually, I'd like it better to have a means of adding macros/scripts or
so to pgAdmin, i.e. wxPython. This would enable pgAdmin extensions,
keeping the pgAdmin core relatively pure.

Regards,
Andreas


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:00 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com