Hi there,
I have a few questions about some things that I've been working on, but am not too sure about.
First, I'm fetching the parameters for routines from the mysql database, since they are not available from the information_schema database. I wonder if users on shared hosting will be able to use this? As far as I know, these users will not have even read access to the mysql db, but maybe there is some way around this, like fetching as the control user or something? So is it a bad idea and should I be instead parsing the output of SHOW CREATE statements?
Next, I've used the following queries to get and manipulate the status of the event scheduler: "SHOW GLOBAL VARIABLES LIKE 'event_scheduler'", "SET GLOBAL event_scheduler='ON'" and "SET GLOBAL event_scheduler='OFF'" While they work just fine for the root account, again I wonder what are the chances of this working on shared hosting.
Next, I need to refactor some JS code that is only common to routines, triggers and events. Can you guys think of a good filename for that? I thought about just putting that code in functions.js, but then it'll be loaded often for pages that don't need it. And also, if it is the best for that code to go into functions.js, I'd rather keep it in a different file until later, so that I don't have merge every time someone pushes their changes to functions.js.
Thoughts?
By the way, I just published a blog post[1] with my report for the first week of coding. Let me know what you make of it, like if is it a reasonable report and if I missed something that needed to be posted.
Also my repository[2] and demo server[3] are fully up to date and I would appreciate any feedback regarding the features that I've pushed.
Thanks, Rouslan
[1]: http://roccivic.blogspot.com/2011/05/first-week-of-coding-over.html [2]: http://repo.or.cz/w/phpmyadmin/roccivic.git/shortlog/refs/heads/rte [3]: http://demo.phpmyadmin.net/gsoc-rouslan/