[Phpmyadmin-devel] GSoC tracking mechanism, status report July 13th - 17th
Hi all, here is my report: KEY ACCOMPLISHMENTS LAST WEEK ============================= - I got my own SVN branch phpmyadmin/branches/gsoc/alex/phpMyAdmin (thanks to Marc for the permissions). - SVN copy from trunk/phpMyAdmin was unexpected not easy for me, because I made the mistake to use http instead of https and so I got the error message "502 BAD GATEWAY". First I thought it was a problem with my subclipse plugin but then I found the hint about the protocol and then the copy process worked fine. - Switched from Eclipse 3.2 to NetBeans IDE 6.7. PHP eclipse nerved me because it was sometimes unstable and did not open some files. NetBeans seems to be more optimized for PHP development. - Did some work on my code too :) Here is a summary of my committed changes to SVN branch: + First tracking mechanism patch applied. + Problems causing PHP notices solved. + Some useless PMA_DBI_select_db() calls removed. + Bug: after renaming a table the list of tracking versions is broken (Fixed) + Using PMA_query_as_controluser where it is possible. + New tab "Tracking" for the table view added. + A little bit PMA_Tracker code refactoring. + SQL dump of pma_tracking to scripts/create_tables.sql added. + Localization introduced, using string vars in english-utf-8.inc.php for outputs. + Short php tags and short print instruction removed how it is recommended in PEAR coding standards. (Thanks to Michal for the helpful hints). KEY TASKS THAT STALLED ====================== Parsing for additional commands like ALTER VIEW etc. First I want to read and tryout PMA SQL parse functions. It makes more sense to optimize the parser of PMA_Tracker before adding new types of SQL statements. KEY CONCERNS ============ Tracking functionality for whole databases. At current status a user has to select every single table that he wants to track. Is it possible to forward prepared SQL dump code to the export script of PMA ? When yes I could use it to deliver more export types than SQL dump and SQL execution. TASKS IN THE UPCOMING WEEK ========================== - Make me familiar with the PMA SQL parser library / functions. - Try to use PMA SQL parser library. - I think it would be a good idea to track the usernames too. I will add this attribute to the tracker log and build a filter to the tracking report. Best regards and have a nice WE Alexander
Alexander Rutkowski a écrit :
Hi all,
Is it possible to forward prepared SQL dump code to the export script of PMA ? When yes I could use it to deliver more export types than SQL dump and SQL execution.
Not sure I understand, could you rephrase? -- Marc Delisle http://infomarc.info
Is it possible to forward prepared SQL dump code to the export script of PMA ? When yes I could use it to deliver more export types than SQL dump and SQL execution.
Not sure I understand, could you rephrase?
The output of the tracking report export functionality is a SQL dump that contains CREATE TABLE, ALTER TABLE, INSERT, UPDATE ... statements. Do we have a script / function / library that can convert this dump directly to export formats listed on tbl_export.php ? Otherwise the user has to export and import the dump separately. Another way is to create a temporary database, importing the SQL dump and make a page forward to tbl_export.php. Need suggestions :)
Alexander Rutkowski a écrit :
Is it possible to forward prepared SQL dump code to the export script of PMA ? When yes I could use it to deliver more export types than SQL dump and SQL execution. Not sure I understand, could you rephrase?
The output of the tracking report export functionality is a SQL dump that contains CREATE TABLE, ALTER TABLE, INSERT, UPDATE ... statements. Do we have a script / function / library that can convert this dump directly to export formats listed on tbl_export.php ?
I don't think so.
Otherwise the user has to export and import the dump separately.
Another way is to create a temporary database, importing the SQL dump and make a page forward to tbl_export.php.
Need suggestions :)
Maybe you can get some ideas by looking at the moveCopy function in libraries/Table.class.php. -- Marc Delisle http://infomarc.info
On 17.07.2009 22:26, Alexander Rutkowski wrote:
- Switched from Eclipse 3.2 to NetBeans IDE 6.7. PHP eclipse nerved me because it was sometimes unstable and did not open some files. NetBeans seems to be more optimized for PHP development.
;-) i had the same problem, but now switched back to Eclipse it is more configurable and better fits my working style -- Sebastian Mendel
Sebastian Mendel wrote:
On 17.07.2009 22:26, Alexander Rutkowski wrote:
- Switched from Eclipse 3.2 to NetBeans IDE 6.7. PHP eclipse nerved me because it was sometimes unstable and did not open some files. NetBeans seems to be more optimized for PHP development.
;-)
i had the same problem, but now switched back to Eclipse
it is more configurable and better fits my working style
I've done attempts to get acquainted with Eclipse, but never got it working well enough to keep me away from vim. In case someone has a 'Perfect workspace setup' running on a Linux system, I'd be interested. -- Met vriendelijke groet / Regards, Herman van Rink Initfour websolutions
Well, I wrote my first PHP/MySQL web application about 5 years ago for my high school. I mainly used Notepad for everything. My final code was a mess, and I also did not understand some of the code I wrote, but it was yet a wonderful experience. Then I began using PHP Editor, and used it for a few years to come. It was very lightweight, and did not have all the features found in nifty modern-day IDEs such as debugging, and project management etc. But it was good for me as I was mainly looking for code highlighting feature. It also ran smoothly on my 128MiB RAM, and Intel Celeron powered machine. For a past few months, I was using Eclipse PDT. I have used Eclipse for Java development before, and I was really fond of debugging feature it comes with. But I don't think it is really a good tool for PHP development. To my surprise, it did not come with "word wrapping" feature, and there was not even any stable plugin to install it. And the fact that it requires all sorts of useless dependencies to run pushed me to finally quit using it. I have tried several IDEs including NetBeans, VS Express, jEdit, and PHP Designer etc, and none of them really impressed me much. Most IDEs nowadays come with so many features that I will never end up using. I mean, I need an editor to code that makes it comfortable for me to code by not giving me all the junk that I don't want. Well, for now, I am using Notepad++ on Windows. It is pretty stable, and light-weight, which is all I want. -------------------------------------------------- Best regards, Zeeshan Mughal Email: zeeshanmughal@ieee.org Web: http://www.zixan.info On Mon, Jul 20, 2009 at 7:18 AM, Herman van Rink <rink@initfour.nl> wrote:
Sebastian Mendel wrote:
On 17.07.2009 22:26, Alexander Rutkowski wrote:
- Switched from Eclipse 3.2 to NetBeans IDE 6.7. PHP eclipse nerved me because it was sometimes unstable and did not open some files. NetBeans seems to be more optimized for PHP development.
;-)
i had the same problem, but now switched back to Eclipse
it is more configurable and better fits my working style
I've done attempts to get acquainted with Eclipse, but never got it working well enough to keep me away from vim.
In case someone has a 'Perfect workspace setup' running on a Linux system, I'd be interested.
-- Met vriendelijke groet / Regards,
Herman van Rink Initfour websolutions
------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
One day, I hope I will be eligible to enter the Church of Emacs. Noting against vi, though. :-) -------------------------------------------------- Best regards, Zeeshan Mughal Email: zeeshanmughal@ieee.org Web: http://www.zixan.info On Mon, Jul 20, 2009 at 1:56 PM, Zeeshan M. <zeeshan.jp@gmail.com> wrote:
Well, I wrote my first PHP/MySQL web application about 5 years ago for my high school. I mainly used Notepad for everything. My final code was a mess, and I also did not understand some of the code I wrote, but it was yet a wonderful experience.
Then I began using PHP Editor, and used it for a few years to come. It was very lightweight, and did not have all the features found in nifty modern-day IDEs such as debugging, and project management etc. But it was good for me as I was mainly looking for code highlighting feature. It also ran smoothly on my 128MiB RAM, and Intel Celeron powered machine.
For a past few months, I was using Eclipse PDT. I have used Eclipse for Java development before, and I was really fond of debugging feature it comes with. But I don't think it is really a good tool for PHP development. To my surprise, it did not come with "word wrapping" feature, and there was not even any stable plugin to install it. And the fact that it requires all sorts of useless dependencies to run pushed me to finally quit using it.
I have tried several IDEs including NetBeans, VS Express, jEdit, and PHP Designer etc, and none of them really impressed me much. Most IDEs nowadays come with so many features that I will never end up using. I mean, I need an editor to code that makes it comfortable for me to code by not giving me all the junk that I don't want.
Well, for now, I am using Notepad++ on Windows. It is pretty stable, and light-weight, which is all I want.
-------------------------------------------------- Best regards, Zeeshan Mughal Email: zeeshanmughal@ieee.org Web: http://www.zixan.info
On Mon, Jul 20, 2009 at 7:18 AM, Herman van Rink <rink@initfour.nl> wrote:
Sebastian Mendel wrote:
On 17.07.2009 22:26, Alexander Rutkowski wrote:
- Switched from Eclipse 3.2 to NetBeans IDE 6.7. PHP eclipse nerved me because it was sometimes unstable and did not open some files. NetBeans seems to be more optimized for PHP development.
;-)
i had the same problem, but now switched back to Eclipse
it is more configurable and better fits my working style
I've done attempts to get acquainted with Eclipse, but never got it working well enough to keep me away from vim.
In case someone has a 'Perfect workspace setup' running on a Linux system, I'd be interested.
-- Met vriendelijke groet / Regards,
Herman van Rink Initfour websolutions
------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi, I'm using kate under KDE 4.2 with terminal, session management, indentation set to C lang., enabled dynamic word wrap & show line numbers. This is how it looks: http://srnka.info/PMA_DEV.png . I've been using the combination since 2005 (?) and I'm really satisfied with it. I like it even more than Zend Studio or Eclipse. Tomas Herman van Rink wrote:
Sebastian Mendel wrote:
On 17.07.2009 22:26, Alexander Rutkowski wrote:
- Switched from Eclipse 3.2 to NetBeans IDE 6.7. PHP eclipse nerved me because it was sometimes unstable and did not open some files. NetBeans seems to be more optimized for PHP development.
;-)
i had the same problem, but now switched back to Eclipse
it is more configurable and better fits my working style
I've done attempts to get acquainted with Eclipse, but never got it working well enough to keep me away from vim.
In case someone has a 'Perfect workspace setup' running on a Linux system, I'd be interested.
participants (6)
-
Alexander Rutkowski -
Herman van Rink -
Marc Delisle -
Sebastian Mendel -
Tomas Srnka -
Zeeshan M.