This is probably several requests but:
I work in with fairly critical data and use the log files to be able to “prove” what I did and when I did it. Its logical to “cover your rear end” when you manipulate database values and or run sql scripts. Today I have to manage all of the log files very manually and if for any reason SQLYog crashes (or my PC) I lose the valuable log files.
My Request(s): Assumes you either open a file or eventually save a sql file and execute some sql…..
Location of log file: Choose a default location for the log files, make it configurable, or create a log file in the same directory as any sql file you open
Name of log File : File Name that was opened or saved + date-time of open or first save
In the log add date + time with local time identifier EST, GMT, etc
Make sure the fie is auto saved at reasonable intervals.
In my view this would add a tremendous amount of value for people who need to comply with more and more regulation and change control in their line of business.
