Shooter7119 / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

[REQ] Save query history per connection #314

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
I often work with multiple windows, each connected to a different MySQL server. 
Since query history 
is saved globally, I often lose query history in all but the last Sequel Pro 
window I close.

It would be nice if query history was saved in association with the connection 
or favorite instead of 
globally. That way, when I connect to server A, my query history shows the 
queries I recently ran on 
server A, and when I open a new window to connect to server B, all of my server 
B query history is 
listed in that window, and both windows will save future queries to their 
respective histories.

I realize that this might be addressed by some of the other "tabbed interface" 
requests, so feel free 
to combine this request as needed. Thanks.

Original issue reported on code.google.com by timmycha...@gmail.com on 26 Jun 2009 at 6:26

GoogleCodeExporter commented 9 years ago

Original comment by stuart02 on 13 Jul 2009 at 8:50

GoogleCodeExporter commented 9 years ago
Pushing the milestone back to help us focus on more important changes.

We should definitely implement this, but not in the near future.

Original comment by abhibeck...@gmail.com on 12 Oct 2009 at 11:32

GoogleCodeExporter commented 9 years ago
This is almost implemented. But right now when you uncheck globally save, it 
only saves it for that session, not permanently for that favorite.  This has 
lead to some lost queries for me.

Original comment by Seancla...@gmail.com on 21 Jun 2011 at 11:41

GoogleCodeExporter commented 9 years ago
Non-global settings are currently only saved for Sequel Pro connection files 
(.spf and .spfs).  Favorites will be migrated to .spf equivalents in the near 
future, but for the time being that means some stuff is slipping through the 
cracks :(

Original comment by rowanb@gmail.com on 22 Jun 2011 at 8:09

GoogleCodeExporter commented 9 years ago

Original comment by abhibeck...@gmail.com on 24 Mar 2012 at 1:15

GoogleCodeExporter commented 9 years ago
First of all thanks for making a great native SQL client for OSX! However, as a 
scientist using SequelPro losing my complex queries that have scientific 
meaning just because I disconnect from a database, possibly on a rubbish net 
connection at a conference makes SequelPro more and more unattractive as my SQL 
client as time goes by. Making a query history or better yet a tagged library 
of queries would be incredibly useful. Allowing for templated queries to be 
stored would be cool too (but not a necessary feature), so just have 
placeholders for the table and fields to be used.

Original comment by mattoates on 2 Nov 2012 at 10:36

GoogleCodeExporter commented 9 years ago
Sequel Pro already has templated queries/queries with variables for quite some 
time.
Just go to Query Editor, click on Query Favorites and then Edit… and you can 
create those.
A Query History also exists and is right next to Query Favorites.

Connection issues was a big problem with 0.9.9.1, but you can try an 
experimental build which should be much more stable in that regard: 
http://nightly.sequelpro.com

Original comment by schlabbe...@gmail.com on 5 Nov 2012 at 4:58