On May 30, 2014 8:41:05 PM GMT+05:30, Edward Cheng <c4150221(a)gmail.com> wrote:
2014-05-30 22:45 GMT+08:00 Atul Pratap singh
<atulpratapsingh05(a)gmail.com>om>:
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?
--
Atul Pratap Singh