|
From: Alexandre P. <Ale...@ei...> - 2013-05-23 15:00:15
|
On Thu, May 23, 2013 at 2:51 AM, Ben Stover wrote: > 1.) Assume I established a connection to a MySQL database and entered some (a lot) of SQL commands in the SQL editor pane/tab. > > Now I close the session resp. exit whole Squirrel. > > After a later restart all the previously entered SQL commands in the SQL pane/tab are vanished. > > Is there a way to tell SQuirrel to remember all current SQL commands and automatically re-show them in the SQL editor pane/tab just as if I would never had exit Squirrel? > > No, I don't want to save them explicitely/manually. The save should take place automatically! Ben, SQuirreL saves all queries/SQL commands in the History as they are executed. Don't blame the screwdriver that it is a bad hammer! > 2.) Similarly I adjusted the column widths in the "Result" tab of a previously executed SQL command. > After a close session resp exit and restart all the columns widths are initially much too wide. > All my customized column widths are forgotten. > Can I somehow tell Squirrel to automatically rememeber the column widths and re-adjust the columns in each result tab accordingly? So how should SQuirreL know what columns settings to use? By SQL? You are, supposedly, data analyst; can you imagine a data structure that can be used for that? I routinely use SQL commands that run into several pages of the text - how unwieldy are you willing to make the settings to satisfy your wish? And what if you changed something in the command, e.g., added or changed WHERE clause or ORDER BY clause? Do you expect SQuirreL to analyze your SQL commands to distinguish between this changes and changes in the structure of the result? Be careful what you wish for - you may end up with Microsoft Windows ;-) -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore Albert Einstein College of Medicine 1300 Morris Park Ave, Bronx, NY 10461 (718) 430-2440 (Mo, Tu, Th, Fr) (718) 920-4885 (We) Thank you Ben ------------------------------------------------------------------------------ Try New Relic Now & We'll Send You this Cool Shirt New Relic is the only SaaS-based application performance monitoring service that delivers powerful full stack analytics. Optimize and monitor your browser, app, & servers with just a few lines of code. Try New Relic and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
