IRC Web Chat

irc.freenode.net #hackontest

News

September 26, 2008 - Congratulations to all the winners! More about the Hackontest event will follow...

Pre-Hacking dinner of OpenLieroX

Working inside the box

Bruce Peren's evaluation

Harald Welte's review

phpMyAdmin

Created by Marc Delisle, modified November 15, 2008 at 09:11:46 CET | This project has a total of 13 feature requests with 12 comments rated at 340 points | 13 unique implementers | Readiness: 12 features with at least three implementers rated at 319 points

phpMyAdmin is a popular web interface for MySQL. This open source project has gained the trust of host providers worldwide; it is currently available in 54 languages.phpMyAdmin has recently won the SourceForge.net 2008 Community Choice Awards for "Best Tool or Utility for SysAdmins" and "Most Likely to Be the Next $1B Acquisition".

List of Implementers

Sort feature requests by

62	Comparing/Syncing/Merging of Server/Databases/Tables Add the possibility to compare and merge changes between two tables. * One or more tables * from same or different database * from same or different server Further information	Feature promoted at 62 points Implementers: Michal Čihař Marc Delisle Sebastian Mendel Sepp bendekken Carlos mauro Tushar Feature created 2008-04-08 by Sebastian Mendel
	Add comment.
53	Statistical Graphs This feature would add graphs for the 'Runtime Information' tab. It could possibly show the MySQL traffic in a line or bar graph. Another bar graph would show what the top queries are for that hour, day, month, or year. Preferences for those options would be stored in the pmadb database. All graphs would be drawn using GD2 and use information from the MySQL server.	Feature promoted at 53 points Implementers: Marc Delisle Owen Kuemerle Sebastian Mendel Barry Carlyon Roger Lindmark Carlos mauro Feature created 2008-04-05 by Owen Kuemerle
	Add comment. 2008-07-26 20:03 Visvo It would be realy nice to get some good statisticals. Maybe this could be also useful to find performance leaks. 2008-05-28 00:01 Barry Carlyon I like the sound of this one, the vast range of data to play with should make it fun to play with, But like you say Marc, Historical data would be interesting as, on the day, we could be short of sample data to work with. 2008-04-08 09:42 Sebastian Mendel a (pie-)chart for query types is posible, or traffic (on, out, sum), these are the only things where i see a chart useful without historical data, query stats could be obtained from log in I_S (http://wiki.cihar.com/pma/Charts_in_server_status_page) 2008-04-08 00:48 Owen Kuemerle As well, another option for this problem would be to use the mysql database to draw the graphs. The problem with this though, is that not all users have access to their server's mysql database and if they do, logging might not always be enabled. Just another thought. 2008-04-08 00:44 Owen Kuemerle If historical data were to be obtained and stored, it would have to use a cron job, or otheriwse hook a cron job when anyone logs in. All past and current data would be stored in the pmadb along with the server, so that other users could not see other user's data. Now that you mention this little kink, its probably less likely for new users to set up a cron job. 2008-04-07 18:41 Marc Delisle Hello Owen, do you have in mind a graph for just the current stats or also historical data? And if historical data, how would the automated collection be done?
45	User preferences module Complement phpMyAdmin's central configuration file with a module that permits each user to store (in MySQL) his/her preferences. This would be useful for users of a shared copy of phpMyAdmin. The "pmadb" infrastructure would be modified to store such preferences, which are mostly related to interface behavior, for example the number of rows shown on Browse, menu hiding, number of tables/databases shown, personal color for themes, etc. There is currently no link for further info, please comment here about this feature.	Feature promoted at 45 points Implementers: Michal Čihař Marc Delisle Owen Kuemerle Sebastian Mendel Barry Carlyon Carlos mauro Feature created 2008-04-04 by Marc Delisle
	Add comment. 2008-07-21 08:42 Pat Roll Anything which offers each user a set of user-definable default values is fine by me. 2008-07-05 19:44 grikdog How about automatic "add user" to virgin mysql dbs? Seems like a perfect enabler for phpmyadmin user prefs!
40	Warning for incomplete backups When during huge backups with phpMyAdmin timeout creates incomplete backups this is only written inside the sql-file. It would be better to get a clear warning message about this, because it is serious to have an incomplete backup.	Feature promoted at 40 points Implementers: Marc Delisle Sebastian Mendel Roger Lindmark Carlos mauro Feature created 2008-07-05 by Roger Lindmark
	Add comment.
37	UI for cross-database relations The pmadb schema already allows relations to be defined between two databases, and this works well. However such relations have to be added manually into the pmadb table, and only internal relations (within the same database) can be entered using the phpMyAdmin user interface.	Feature promoted at 37 points Implementers: Michal Čihař Marc Delisle Sebastian Mendel Carlos mauro Feature created 2008-04-21 by Fonant
	Add comment. 2008-04-24 22:03 Marc Delisle What do you have in mind, using "Relation view" or the "Designer" feature for this?
34	Manage stored procedures and functions Introduce a module in phpmyadmin that allows to create stored procedures and manage them : - view the the list of procedures. - delete - alter (modify). And finally add the possibility to export them in the export page. Further information	Feature promoted at 34 points Implementers: Michal Čihař Marc Delisle Sebastian Mendel Schalk Neethling wasik Bill Feature created 2008-04-20 by Neutrino
	Add comment. 2008-07-29 21:41 Neutrino It is true that this feature is implemented in 2.11, but we must use requests and type SQL code to do it. The idea here is to provide a good GUI, to handle existing procedure like tables. To be able to view them to add to new one in an eay way. Why not allow procedure code to be debugged, it the team is motivated and skilled. It is really an important feature. As a developer, I need this kind of feature for Phpmyadmin. 2008-07-12 20:12 Marc Delisle The GUI could better support the creation of a stored procedure by helping with the syntax. 2008-04-24 22:01 Marc Delisle Hmm, version 2.11 already permits to manage stored procedures: list, delete, modify, export. And creation is possible via the SQL query box and its delimiter option. Just have a look on the Structure page for a database, in the Routines section (which appears if there is a procedure or function created).
17	Support automatic backup Support a secure mechanism so that a cron job on host could call phpMyAdmin to perform a backup, save on the host of course. Further information	Feature promoted at 17 points Implementers: Michal Čihař Marc Delisle Sebastian Mendel Carlos mauro Feature created 2008-07-15 by Marc Delisle
	Add comment.
11	installable through a PEAR channel make phpMyAdmin installable with PEAR from an own channel.	Feature promoted at 11 points Implementers: Michal Čihař Marc Delisle Sebastian Mendel Feature created 2008-07-15 by Sebastian Mendel
	Add comment.
10	Audit log Create an audit log of all SQL statements performed via PMA, possibly per category of statements (DDL, DML) or even per statement (if someone does not want to audit SELECT for example. Further information	Feature promoted at 10 points Implementers: Michal Čihař Marc Delisle Sebastian Mendel Feature created 2008-07-12 by Marc Delisle
	Add comment.
10	AJAX-based graphical query builder phpMyAdmin already has a multi-table query builder (in database view, Query) but it's not mouse-driven. Further information	Feature promoted at 10 points Implementers: Michal Čihař Marc Delisle Sebastian Mendel Carlos mauro Feature created 2008-07-19 by Marc Delisle
	Add comment.
9	Privileges for non superuser Currently, phpMyAdmin's privileges interface is oriented towards a superuser that has global privileges, but even a non-superuser could benefit from this interface because he might have GRANT privilege. Further information	Feature promoted at 9 points Implementers: Michal Čihař Marc Delisle Sebastian Mendel Carlos mauro Feature created 2008-07-19 by Marc Delisle
	Add comment.
9	Configurable menus I have seen in some occasions that a group of users needs a more simple interface. Instead of predefining what is a Basic mode, we should be able to configure which menus are displayed. Further information	Feature promoted at 9 points Implementers: Michal Čihař Marc Delisle Sebastian Mendel Feature created 2008-07-19 by Marc Delisle
	Add comment.
3	Drag and Drop for make the select With protoype implement drag an drop for make a select into tables or same to ACL progrm Further information	Feature promoted at 3 points Implementers: Carlos mauro Feature created 2008-07-30 by Carlos mauro
	Add comment.