Add support for editing functions (stored procedures) #72
Comments
|
While it's definitely a feature I would like to have it also seems like a lot of work. |
|
Would be great |
|
Definitely! I'm having trouble editing a function right now and would love to have the ability to view and edit it easily. |
|
+1 |
|
Yes, please. You seem to have a vert nice tool, that only solves half of the problem. |
|
+1 Great tool but to use it seriously, we need stored procedures. |
|
Yes please, this is very important! |
|
Very important! I love the application, but this would be the one thing holding me back from purchasing the full version. Premium feature? |
|
Please do. Just purchased this and was surprised to find that editing functions wasn't already available. |
|
What would it mean to have editing features for functions? Once selected a function on tree, its details would be displayed with a tabbed interface similar to the one now available for tables:
What else? |
|
Honestly, that would be all I need. The interface for functions in the competing product is overkill for me and really slows down my workflow. Most of the time when editing a function, I just need minor changes which are quick and easy with a simple editor. |
|
@trapias what you've described would be plenty for my needs -- I agree with @topherlandry. I think it's more about quick access/editing/execution than anything else -- nothing fancy. |
|
I also think we could go with a minimal, efficient way to handle this. Don't know how you do it, but I normally have pgAdmin open together with Postico: I use the former to find the function I need to work on, copy its content and paste it into Postico to work on it. Just having the possibility to see functions and click on them to get them pasted in query editor would be a time-saver.
I believe these, maybe together with a "search-and-replace" capability in query editor, would be huge enhancements for who, like me, @topherlandry and @jamesdixon at least, need to work on functions/stored procedures. Well not exactly ten minutes work for @jakob, but not even days I think. Could also be a feature reserved for licensed users (I happily am one), but would love to have this. |
|
Thanks for all your input! I only occasionally use functions myself, so I have to completely rely on your input for this, and it's great to hear so many suggestions. If I understand correctly, the most important first step would be a read-only way to simply view a list of functions and their code. It should be possible to implement something like that quickly. @trapias your list of suggestions is great, I'll try doing that. Instead of mixing functions and tables in the sidebar like pgAdmin does, I'd like to try something similar to Xcode. Xcode has a sidebar, and there are icons at the top of the sidebar (see screenshot) that let you switch between viewing files, issues, etc. In Postico there could be an icon for tables and an icon for functions, so you could switch between showing tables or functions in the sidebar.
Does anybody have a good idea for an icon to represent a function? @topherlandry I'm curious, what competing product are you talking about? :) |
|
Referring to Navicat Essentials. Their interface is really heavy and cluttered for what I need, which is minimalistic. I like the idea of icons at the top. You could use the mathematical symbol for |
|
I wanted to suggest the same tab-like bar for switching between data/functions/data types/etc. . As for an icon for functions 𝑓(x) should work well (MATHEMATICAL ITALIC SMALL F U+1D453) |
|
@jakob I like the idea of icons on top of the sidebar, cool 👍 |
|
That would be great! I think that is a very good solution. I like the idea for that icon. |
|
@jakob any update on whether this might make it into the next release? Cheers. |
|
@jamesdixon I haven't started working on stored procedures yet. This feature is at least a couple of months away. |
|
I like the concept. Perhaps a simple 'edit' feature would allow you to copy the read-only Just don't reproduce the pgadmin "feature" where you get a stale copy of On Tue, Feb 2, 2016 at 6:08 AM, Jakob Egger notifications@github.com
Michael Iverson |
|
+1: Would very much like to see this feature in asap. Currently lacking it as a premium user, was expecting it to be in already because it's that vital to serious use of postgres. |
|
+1 for this. Would very much love to leave pgAdmin behind, but it still has so many important features. |
|
@jakob any update on this? Also, as a premium user, I'm curious as to the process you're using to prioritize features? For example, I saw that basic support for Cockroachdb is being added, but that seems very low priority given that it's a relatively unknown database in beta compared to a feature like this (or others) that are highly requested and fundamental to working with Postgres. |
|
@jamesdixon I try to prioritise features that lots of people want, obviously, because it is the right thing to do and also because that leads to more sales. But just as important is the amount of time required to implement a feature. Adding support for CockroachDB was a couple of hours of work, and some parts (like the client side TLS certificate stuff) is also useful for PostgreSQL users. Adding support for editing stored procedures will require some significant changes to the UI, specifically the sidebar. I've started this work, and but it will still take me time to complete. This is mostly UI work, which is the most time-consuming kind of work. While a simple logic change is often just a handful of lines that I need to add, a new view will require lots of design work and adding several new files. I rarely get it right on my first try, so I often start over or keep making changes to the UI until it works. |
|
+1 |
1 similar comment
|
+1 |
|
@jakob - A lot of my colleagues want to move to Postico but they can't do because it doesn't support this feature. Pls consider this feature as a priority. |
|
@miverson: technically it should be impossible to write a worse UI than pgadmin4. I also agree, that visibility + copy-paste-ready code would suffice for now - thats all I'm using pgadmin for, but this program makes it as hard as possible to achieve this ... and after I hit |
|
Yes, I think if you threw modly bread and sticks at a piece of flypaper you would have a better UI than PGAdmin, yet thats what I'm also forced to use |
|
I find it amazing that more than 2 years later the same people are asking for the same feature. I gave up on it ever coming -- which is a shame because I really liked Postico. |
|
Hi folks! Instead of complaining about pgAdmin here, please consider reporting feedback to their mailing list. I'm sure Dave Page and the development team would love to hear what you are struggling with (if you tone down the sarcasm a bit...). They do listen to user feedback. I'm sorry that development of Postico isn't as fast as you'd like. Fixing all the little bugs takes a lot of time, and we're a small team, so we can only do a few major features at a time. I don't really have any updates on this issue. All I can say is that I consider functions an important feature that I really want to have. I don't know how long it'll take, and if you need this feature, you'll need to use a different client. I'd love for Postico to have a feature like this, but we're just not there yet. |
|
@jakob maybe it would help to share exactly what is coming next for Postico? I believe the issue here isn't a lack of respect for the development process, but instead an issue with communication. I had previously suggested making some sort of public roadmap. Sure, maybe the features takes months to develop, but at least Postico users and prospective Postico users will have an idea of what to expect going forward. |
|
Sarcasm and crude humor aside, I just wanted to express that the lack of
this feature is a real pain point. I'm a paid user of Postico.
As a developer myself, I realize that in development, time is your most
precious commodity. But that doesn't make me feel any better when I have to
fire up another tool just to edit a function.
…On Tue, Apr 10, 2018 at 1:25 PM, James Dixon ***@***.***> wrote:
@jakob <https://github.com/jakob> maybe it would help to share exactly
what is coming next for Postico? I believe the issue here isn't a lack of
respect for the development process, but instead an issue with
communication.
I had previously suggested making some sort of public roadmap. Sure, maybe
the features takes months to develop, but at least Postico users and
prospective Postico users will have an idea of what to expect going forward.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#72 (comment)>, or mute
the thread
<https://github.com/notifications/unsubscribe-auth/AAg1Nc5LUyw9pN2HIta6Yyc9UxCfmYeqks5tnOrxgaJpZM4GA-rP>
.
--
Michael Iverson
|
|
3 years and still waiting for this. Holder of multiple licenses for business and personal use. |
|
I've move from Mac to Linux for 2 years and this function still not present... |
|
Just having a list of the functions and the ability to see the 'CREATE OR REPLACE' code would be more than enough for me. Thanks! We just bought 10 licenses. |
|
@johnthuss agreed. That's all I'm looking for as well |
|
Same here @jakob, have been using the paid version of Postico for years and the only feature I'm missing is a list of stored functions with their source code. It's an amazing app and this is literally the only missing feature. Happy to edit the functions manually in the query tab! |
|
only reason i dont pay for this app is because its missing this feature.. even my ide has this feature.. |
|
@tim-walton the app is worth paying for already. The way I look at it is that if we don’t vote with our wallet then developers tend to drift off on to other things. |
|
@senjaz while I agree with you, the developer has indicated in #608 that they are doing well with their license revenue. If that's the case, then they should be focused on features the community wants, i.e. function editing support, which has the most reactions by double of any other feature request. Instead, the developer has chosen to focus on things like dark mode and cockroach db support. It's frustrating when you've been waiting around for literally years for a feature that is so clearly valued by the community. |
|
+1 – doing work with postgraphile/postgrest and would really appreciate this feature. I might end up purchasing a license without it, but the lack of this feature is my only hesitation. |
|
Same same |
|
Yes, It's been nearly 4 years since this was requested. I'm tired of opening pgadmin4 windows. |
|
Hi everyone! Postico 2 will have support for editing stored procedures and functions. We can't say how long it'll take us to release Postico 2, but you can already download a beta version here: https://eggerapps.at/postico2/ The beta version of Postico 2 only has a read-only list of functions. I know that it's not a full editor, but it's better than not showing functions at all. (I already announced the beta earlier, but not everyone commenting here might have seen the announcement in #689, so I'm posting again. Apologies for spamming those of you who already know.) |
|
Great to hear that Postico 2 is coming. However I find the UI for functions/procedures strange: Instead of grouping functions and procedures with the tables and views in the same schema, they are grouped at the top level into a separate tab. So if I'm working on closely related tables, views and procedures those objects are all in the same schema and share a name prefix (so the table might be called |
|
I don't know if this is a good spot to comment on Postico 2 as well, but the one thing keeping me from using it is it's no longer able to do an SQL query in one click. That's mostly the whole point of why I use Postico for many production servers. Now, many clicks are involved and it just feels very clunky/clumsy to do a single query, and that it just saves every single one. I rarely am wanting to save what I'm doing. Maybe there can be a "Quick SQL" section above the one where it automatically stores it or something... |
|
@doerwalter Thanks for the feedback. I usually have separate databases for separate projects, and I assumed that's how most people use PostgreSQL. I see that the way the interface works now is annoying when you have multiple projects / customers in one database and use schemas for grouping stuff. I'll think about this, but what I really like about the current UI is that functions are somewhat hidden and don't confuse people who don't use them... @9mm This thread is already very long, so I created a new issue for your feedback (#698) |
|
BTW, I'm very pleased with the changes in Postico 2. Thank you for your
efforts.
…On Wed, Feb 26, 2020 at 2:33 AM Jakob Egger ***@***.***> wrote:
@doerwalter <https://github.com/doerwalter> Thanks for the feedback. I
usually have separate databases for separate projects, and I assumed that's
how most people use PostgreSQL. I see that the way the interface works now
is annoying when you have multiple projects / customers in one database and
use schemas for grouping stuff. I'll think about this, but what I really
like about the current UI is that functions are somewhat hidden and don't
confuse people who don't use them...
@9mm <https://github.com/9mm> This thread is already very long, so I
created a new issue for your feedback (#698
<#698>)
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#72?email_source=notifications&email_token=AAEDKNJIEKDINHTI2MTWK5DREYZQJA5CNFSM4BQD5LH2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEM7PUVY#issuecomment-591329879>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AAEDKNME3YS6HYEFIOIDHXTREYZQJANCNFSM4BQD5LHQ>
.
--
Michael Iverson
|
|
@martinjankoehler has been working on a graphical editor for stored procedures and functions, and we just merged it into the master build of Postico 2. Please download the latest build of Postico 2 here: https://releases.postico.app |
|
Looks promising! Should we already report issues or should we wait a for few builds? |
|
@qwesda Yes please report issues! (As new issues if possible, since this thread is already very long) |
and others
Multiple users have requested a way to edit stored procedures/functions in Postico.
I'm not currently working on this feature, but I do plan to add it at some point in the future.
Please click the thumbs up button if this would be useful for you!
The text was updated successfully, but these errors were encountered: