On May 30, 2014 8:41:05 PM GMT+05:30, Edward Cheng c4150221@gmail.com wrote:
2014-05-30 22:45 GMT+08:00 Atul Pratap singh atulpratapsingh05@gmail.com:
Ok, so you plan to display query results in the console itself. I misunderstood some details from your proposal and thought that query results will be displayed in the main panel and query logs in the
console.
My previous reply was according to that understanding. Also, please
tell me
about the following details..
- I am still unclear about warnings etc. that we display for certain
queries like DROP, will we warn the user when executing such queries
from
console? Or would it be totally like mysql console?
- Also in case user puts a USE query in console, do we change the
selected
database and update the navigation and main panel? Same will be
required
for ALTER queries etc.. Here I am pointing to the overall relation
and
synchronization between console and rest of the application.
These features can be added later, before execute there's PMA_console.execute(), after execute there's midHandler.
Ok, I will make few comments on the commit at github soon.
- And would you store the sql query logs only or the sql results
history
as well? I think as the results may change at any time, storing
queries
only should be fine.
Yeah, data may change any time, but we still can store results, users know when a query should be re executed.
Alright, I'll change my design, store queries only, with bookmarks and history.
Bookmarks are a part of sql tab I guess, why storing them here?