Add support for editing Indexes #19

Closed
petersirka opened this Issue Jun 24, 2015 · 26 comments

Comments

Projects
None yet
@petersirka

I have suggestion for adding the index settings.
Thanks.

@neverov

This comment has been minimized.

Show comment
Hide comment
@neverov

neverov Jul 3, 2015

I lack index support too, it would be great to manipulate indexes as well.
Thanks for the great work on the app!

neverov commented Jul 3, 2015

I lack index support too, it would be great to manipulate indexes as well.
Thanks for the great work on the app!

@Otann

This comment has been minimized.

Show comment
Hide comment
@Otann

Otann Jul 6, 2015

I also vote for adding indexes.
Thanks for your amazing product.

Otann commented Jul 6, 2015

I also vote for adding indexes.
Thanks for your amazing product.

@danillos

This comment has been minimized.

Show comment
Hide comment

danillos commented Jul 8, 2015

+1 vote

@iamanders

This comment has been minimized.

Show comment
Hide comment

+1

@regabi

This comment has been minimized.

Show comment
Hide comment

regabi commented Aug 21, 2015

+1

@jakob jakob changed the title from Missing index settings to Add support for editing Indexes Sep 21, 2015

@tonyduan

This comment has been minimized.

Show comment
Hide comment
@tonyduan

tonyduan Oct 2, 2015

+1 -- thanks for working on this, @jakob!

tonyduan commented Oct 2, 2015

+1 -- thanks for working on this, @jakob!

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Nov 2, 2015

Owner

I've just added some support for indexes. Postico now displays a list of indexes in the table structure view underneath the columns.

  • you can edit the index name and add a comment
  • you can delete indexes
  • there is no GUI for creating new indexes yet
  • there is no pretty graphical display of indexes yet, at the moment Postico just displays the index definition (SQL)

Despite the current limitations, I'm pretty sure that this feature will be very useful to many people.

You can download a prerelease here:
https://eggerapps-downloads.s3.amazonaws.com/postico-1240.zip

Let me know what you think.

Owner

jakob commented Nov 2, 2015

I've just added some support for indexes. Postico now displays a list of indexes in the table structure view underneath the columns.

  • you can edit the index name and add a comment
  • you can delete indexes
  • there is no GUI for creating new indexes yet
  • there is no pretty graphical display of indexes yet, at the moment Postico just displays the index definition (SQL)

Despite the current limitations, I'm pretty sure that this feature will be very useful to many people.

You can download a prerelease here:
https://eggerapps-downloads.s3.amazonaws.com/postico-1240.zip

Let me know what you think.

@tonyduan

This comment has been minimized.

Show comment
Hide comment
@tonyduan

tonyduan Nov 2, 2015

This sounds great -- thanks for all your hard work, Jacob.

Jakob Egger wrote:

I've just added some support for indexes. Postico now displays a list
of indexes in the table structure view underneath the columns.

  • you can edit the index name and add a comment
  • you can delete indexes
  • there is no GUI for creating new indexes yet
  • there is no pretty graphical display of indexes yet, at the moment
    Postico just displays the index definition (SQL)

Despite the current limitations, I'm pretty sure that this feature
will be very useful to many people.

You can download a prerelease here:
https://eggerapps-downloads.s3.amazonaws.com/postico-1240.zip

Let me know what you think.


Reply to this email directly or view it on GitHub
#19 (comment).

tonyduan commented Nov 2, 2015

This sounds great -- thanks for all your hard work, Jacob.

Jakob Egger wrote:

I've just added some support for indexes. Postico now displays a list
of indexes in the table structure view underneath the columns.

  • you can edit the index name and add a comment
  • you can delete indexes
  • there is no GUI for creating new indexes yet
  • there is no pretty graphical display of indexes yet, at the moment
    Postico just displays the index definition (SQL)

Despite the current limitations, I'm pretty sure that this feature
will be very useful to many people.

You can download a prerelease here:
https://eggerapps-downloads.s3.amazonaws.com/postico-1240.zip

Let me know what you think.


Reply to this email directly or view it on GitHub
#19 (comment).

@regabi

This comment has been minimized.

Show comment
Hide comment
@regabi

regabi Nov 2, 2015

This is great Jakob, big upgrade!

regabi commented Nov 2, 2015

This is great Jakob, big upgrade!

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Nov 4, 2015

Owner

I've just released version 1.0, which includes the features I've described above:
https://eggerapps.at/postico/changelist.html

I'm leaving this issue open to remind me to continue working on improved GUI tools for indexes (esp. creating new indexes)

Owner

jakob commented Nov 4, 2015

I've just released version 1.0, which includes the features I've described above:
https://eggerapps.at/postico/changelist.html

I'm leaving this issue open to remind me to continue working on improved GUI tools for indexes (esp. creating new indexes)

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Nov 5, 2015

Owner

Also, to give credit where credit is due: The new index feature was mostly programmed by my friend @wurmrobert. Robert is a bright software engineering student who started helping me with development recently. He'll probably work on the index creation GUI next.

Owner

jakob commented Nov 5, 2015

Also, to give credit where credit is due: The new index feature was mostly programmed by my friend @wurmrobert. Robert is a bright software engineering student who started helping me with development recently. He'll probably work on the index creation GUI next.

@regabi

This comment has been minimized.

Show comment
Hide comment
@regabi

regabi Nov 5, 2015

Nicely done @wurmrobert!
Jakob, as promised, I'm buying the app now!

On Thu, Nov 5, 2015 at 3:17 AM Jakob Egger notifications@github.com wrote:

Also, to give credit where credit is due: The new index feature was mostly
programmed by my friend @wurmrobert https://github.com/wurmrobert.
Robert is a bright software engineering student who started helping me with
development recently. He'll probably work on the index creation GUI next.


Reply to this email directly or view it on GitHub
#19 (comment).

regabi commented Nov 5, 2015

Nicely done @wurmrobert!
Jakob, as promised, I'm buying the app now!

On Thu, Nov 5, 2015 at 3:17 AM Jakob Egger notifications@github.com wrote:

Also, to give credit where credit is due: The new index feature was mostly
programmed by my friend @wurmrobert https://github.com/wurmrobert.
Robert is a bright software engineering student who started helping me with
development recently. He'll probably work on the index creation GUI next.


Reply to this email directly or view it on GitHub
#19 (comment).

@seymores

This comment has been minimized.

Show comment
Hide comment
@seymores

seymores Feb 23, 2016

Creating new index is quite important.

Creating new index is quite important.

@bezludny

This comment has been minimized.

Show comment
Hide comment
@bezludny

bezludny Feb 29, 2016

Creating new index is quite important.

Same here.

Creating new index is quite important.

Same here.

@swrobel

This comment has been minimized.

Show comment
Hide comment
@swrobel

swrobel Mar 8, 2016

👍 for adding/editing indexes

swrobel commented Mar 8, 2016

👍 for adding/editing indexes

@johnmap

This comment has been minimized.

Show comment
Hide comment
@johnmap

johnmap Apr 17, 2016

+1 for creating indexes

johnmap commented Apr 17, 2016

+1 for creating indexes

@helloguille

This comment has been minimized.

Show comment
Hide comment

+1

@willtrking

This comment has been minimized.

Show comment
Hide comment

+1

@raspasov

This comment has been minimized.

Show comment
Hide comment
@raspasov

raspasov Jun 11, 2016

+1, please - btw your app is amazing, keep up the great work! : )

+1, please - btw your app is amazing, keep up the great work! : )

@CreepGin

This comment has been minimized.

Show comment
Hide comment
@CreepGin

CreepGin Jul 7, 2016

While GUI is important, creating an index manually is quite straightforward:

Go to the SQL Query view and execute something like:

CREATE INDEX user_createdat_index ON "User" USING btree ("createdAt")

CreepGin commented Jul 7, 2016

While GUI is important, creating an index manually is quite straightforward:

Go to the SQL Query view and execute something like:

CREATE INDEX user_createdat_index ON "User" USING btree ("createdAt")
@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Jan 12, 2017

Owner

It's been some time, but I've now finally finished the work that @wurmrobert started with the index editor: The graphical index editor is now ready for testing!

Please download the latest prerelease build here:
https://eggerapps-downloads.s3-eu-west-1.amazonaws.com/postico-1560.zip

I'm pretty happy about the way it turned out: It looks trivially simple, but yet it supports almost all types of indexes. The only thing that it doesn't support are custom storage parameters.

What do you think about it? Does it do what you need? Does it make sense? Is it confusing?

(Also, the structure editor is now a bit more colorful. Primary keys are yellow, unique keys are blue, foreign keys are green.)

Owner

jakob commented Jan 12, 2017

It's been some time, but I've now finally finished the work that @wurmrobert started with the index editor: The graphical index editor is now ready for testing!

Please download the latest prerelease build here:
https://eggerapps-downloads.s3-eu-west-1.amazonaws.com/postico-1560.zip

I'm pretty happy about the way it turned out: It looks trivially simple, but yet it supports almost all types of indexes. The only thing that it doesn't support are custom storage parameters.

What do you think about it? Does it do what you need? Does it make sense? Is it confusing?

(Also, the structure editor is now a bit more colorful. Primary keys are yellow, unique keys are blue, foreign keys are green.)

@swrobel

This comment has been minimized.

Show comment
Hide comment
@swrobel

swrobel Jan 12, 2017

Just spent some time playing with it and I think it's fantastic. It's exactly what I was hoping for (and have come to expect from Postico) - simple yet powerful.

swrobel commented Jan 12, 2017

Just spent some time playing with it and I think it's fantastic. It's exactly what I was hoping for (and have come to expect from Postico) - simple yet powerful.

@neverov

This comment has been minimized.

Show comment
Hide comment

neverov commented Jan 12, 2017

Awesome!

@jakob jakob added done and removed started labels Jan 14, 2017

@jakob jakob closed this Jan 27, 2017

@gangstead

This comment has been minimized.

Show comment
Hide comment
@gangstead

gangstead Jan 27, 2017

Just downloaded 1.1 and this feature looks nice. Is there a way to get the sql for an existing index (what was shown before)?

Just downloaded 1.1 and this feature looks nice. Is there a way to get the sql for an existing index (what was shown before)?

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Feb 2, 2017

Owner

@gangstead There is no way to view the SQL of an index at the moment. I just didn't find a good space to put it.

I'm considering adding a third section to the bottom switcher (Contents / Structure / SQL) that displays SQL of the table, indexes etc., but that is a separate issue.

Owner

jakob commented Feb 2, 2017

@gangstead There is no way to view the SQL of an index at the moment. I just didn't find a good space to put it.

I'm considering adding a third section to the bottom switcher (Contents / Structure / SQL) that displays SQL of the table, indexes etc., but that is a separate issue.

@frozenfung

This comment has been minimized.

Show comment
Hide comment
@frozenfung

frozenfung Jan 8, 2018

In the first hand I search around in my Postico app but can not found any index suddenly I realize that I use an out-of-fashion version. After I re-install the newest one I discover the treasure! Thanks for developing & maintaining this awesome app!

In the first hand I search around in my Postico app but can not found any index suddenly I realize that I use an out-of-fashion version. After I re-install the newest one I discover the treasure! Thanks for developing & maintaining this awesome app!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment