Proper foreign key support in the UI #192
Comments
|
Sounds like a really good idea. Please make it so. 😁 |
|
Is there any update on this issue? The ability to add foreign keys would be really helpful. |
|
@karai17 Adding foreign keys already is possible 😃 You have to scroll to the right side end of the grid view in the Edit/Create Table dialog but then you'll find the field you need: |
|
....... I am an idiot. Thank you. .____.; |
…cell Add a tooltip to the database browser when you hover a cell with a foreign key set in order to show the referenced table and column. When clicking on such a cell while holding the Ctrl and Shift key (only one of them won't work because they are for multiselection and Alt doesn't do the trick on my system because it's just for grabbing and moving the window) try to jump to the table and row which is referenced in the clicked cell. See issue #192.
|
@karai17 No worries, you're probably not 😃 And I have to admit, too, that the field for foreign keys isn't placed very well... As for the original issue described here: With commit 39a49e3 I try to add exactly that feature. There's a tooltip now appearing for cells with a foreign key set which tells you the name of the referenced table and when you hold Ctrl+Shift and click on the cell it jumps to the referenced row. Anyone willing to test this? 😄 |
|
It would be great if the UI itself also had a dropdown of some of the rows when entering foreign key data. phpMyAdmin and MS Access are two examples (with the latter being awful) of GUI tools that do this, but I don't think there's a single SQLite example! Example |
|
@MKleusberg With the latest commits, is this now fixed? |
|
No, not yet. The last commits only fixed some bug I've introduced during my code refactoring. This means we're in a much better position now to start working on this but it's not yet implemented. |
|
No worries. 😄 |
|
#614 seems related to this too. |
OMG .. how did u get it !! .. thanks man .. |
|
Should it be any icon that shows that an attribute is a foreign key, like the one shown for primary key? Thank you. |
Fields having a foreign-key constraint are shown with a distinctive icon. New icon based on page_green.png and bullet_key.png from the Silk icon set. See comment in issue #192
|
@xpidelaserra Good idea. I've added the new icon (similar to the primary key icon but with a mirrored silver key). You can try it in the next nightly build. |
|
Closing this issue because
|
|
Here on my Xubuntu system this does not work, as expected. |
|
@csanyipal - this is a closed bug. Not best practice to "bump" in this manner. |
We could parse the foreign key constraints in a table definition to understand which column links to which column of a different table and then use that information in the Browse Data tab: When hovering over a cell with a foreign key constraint and some data in it, we could show a tooltip telling the user to what table is linked here. And when holding Ctrl and then clicking the cell (or some similar combination) we could jump there directly.
The text was updated successfully, but these errors were encountered: