Developers

developers@phpmyadmin.net

2 participants
7003 discussions

[Phpmyadmin-devel] [GSOC 2011 Draft Proposal] Specialized Syntax for Query Building
by Dhruv Baldawa 04 Apr '11

04 Apr '11

*Personal Details* *Name:*Dhruv Baldawa *Email:*dhruvbaldawa@gmail.com *Skype ID or GTalk:*dhruvbaldawa@gmail.com *IRC nick:*dhruvbaldawa *Phone number:* +(91)-9323321233 *School Name:* Thakur College of Engineering and Technology, University of Mumbai *Years completed:*Third Year Computer Engineering *Python Experience Level:*Intermediate *Project Description* *Describe your idea in detail:*SQL is a generic language and is the most common language used for database querying. But, the problem with SQL is, when a new user fires a SQL query, he needs to know 2 things : 1. He needs to all the relations in the schema, and how are they related, and how are they linked using which attributes. 2. When a user needs to fire similar queries (similar means queries with almost same entities), in such a case all the JOIN statements or linking conditions have to be rewritten. So, here I propose a tool, which comprises of a metadata and syntax generator, algorithm and query helper, which can help user create a specialized syntax for querying the database in a simple and efficient manner, ignoring all the linking between the various tables. *What have been done so far with this idea : *I have been developing a Paper Conference Management System for an International Paper Conference which is conducted in our college, and there are various queries and reports which are to be generated, but considering the modularity of the software architecture and the normalized databases, the SQL queries tend to become bigger and bigger and making it difficult for the user who doesn't know the database schema to generate reports. So, I have done a partial implementation of this concept, in that project.The current code can be found at : http://conms.svn.sourceforge.net/viewvc/conms/conms/compiler.php?revision=5… It is not complete, and may contain errors. *Vision:* To develop a robust system, which makes generation of SQL queries simpler for the end-user, thus, empowering the user to generate database queries/reports without any prior knowledge regarding the database schema. The system can be condensed to form a tool, which automatically generates the metadata, with the database schema provided along with an algorithm to generate queries and a query helper tool. *Advantages:* - Uses Finite State Model, hence, is fast. - If the database schema changes, only the new metadata files have to be changed. - The user need not type the monotonous JOIN statements or linking the attributes. - Supports augmented attributes, for example, “name” can be replaced by “first_name” and “last_name”. - Supports null transitions. - Supports linking of various tables. *Anticipated challenges:* - If the system, goes to a state multiple times, it would have same conditions added multiple times. Solution : This has been taken care of by developing a query builder class, which ignores duplicate conditions and attributes. - Ambiguity between same named attributes of various relations. Solution : In the SQL query, the attributes are replaced by their relations_name.attribute_name. - Using aggregate functions. - Using with tables which are designed as key/value pairs. - Generating queries using “having” or “group by” clause. *Schedule of Deliverables* *Milestones and deliverables schedule:* - *April 25 - May 23 (28 days):* Get acquainted with the development cycle, version control systems. Read various books on Django development. Study the current schema. Discuss with mentors the current design and check for potential pitfalls and try to modify the design the system in order to cover them. Develop a initial standard for the metadata files. - *May 23 - May 13 (14 days):* Design the basic algorithm (including Lexical Analysis and Syntax Checker), which takes the metadata files and the query, to generate the SQL query. This also includes manual creation of metadata files and synthesis of complex queries. - *June 13 - June 27 (14 days): *Develop the query helper tool, which helps user to build query. The tool shows the valid inputs when user is present at a particular stage. - *June 27 - July 11 (14 days):*Correct any discrepancies in the system and prepare test cases and documentation. Generate test reports and make sure the system is running perfectly fine. - *July 15 –August 1 (17 days):*Develop the metadata generator tool, which helps user customize the syntax and also edit the entities interacting in the system. - *August 1 - August 8 (7 days):*The entire system, integrated and checked. Revise the standard of the metadata files. Correct the bugs which occur after the integration of the system. Generate the test cases. Convert the module into various independent libraries. - *August 8 - August 22 (14 days) :*Start preparing the final documentation and perform the rigorous testing on the system. *Other commitments:*None *Open Source Development Experience* 1. Developed website for All India Stainless Steel Industries Association (http://www.aissia.org) 2. Developed Mass Mailing application 3. Developed Facebook Application (http://apps.facebook.com/invertendo) 4. Developed website for College Technical Festival 5. Developed eBooks Repository Management application 6. Mobile UI for Home Automation System 7. Developing a PHP Script Obfuscator *Other Open Source/Free Software Experience :* 1. Building a open-source Paper Conference Management System : http://sourceforge.net/projects/conms/ *Work Experience* *Work Experience:* - Developed Mass Mailing Software for a Company - Developed website for All India Stainless Steel Industries Association (www.aissia.org) - Developed Mobile UI for Home Automation System for a Telecom firm *Academic Experience* *Academic Institution:*Thakur College of Engineering and Technology, University of Mumbai, Mumbai, Maharashtra, India *Current Program:*Bachelor of Engineering in Computer Engineering. Currently in 3rdyear (6th Semester). *Anticipated Graduation:*December 2012 *Academic Performance:* I am amongst the first 4 students in my department. My aggregate from previous 2 semesters is 76.82 % The courses completed in college are : - C++ Programming Language - Java Programming Language - Analysis of Algorithms and Design - Data Structures and Files - Computer Organization and Architecture - Computer Graphics - Operating Systems - Computer Networks - Theory of Computer Science - Database Management Systems - Advanced Database Management Systems - Microprocessors - Web Engineering - Advanced Computer Networks - Advanced Microprocessors - Systems Programming and Compiler Construction - Data Warehousing and Mining - Object Oriented Software Engineering

2 1

[Phpmyadmin-devel] Interface support for stored routines, triggers and events
by Samiran Raj Boro 04 Apr '11

04 Apr '11

I have submitted my proposal to gsoc site. Please provide feedbacks about my proposal. Should I make it publicly visible? Samiran

2 2

[Phpmyadmin-devel] Interested in AJAXify Interface project idea
by lgtkaushalya＠gmail.com 03 Apr '11

03 Apr '11

Hi Marc, > Please checkout "master" instead. > > I have then re checkout the "master" and checked for the functionality of the search option. > > One area that needs improvement is Database search: > - collapse/expand the "Search in database" fieldset > - separate popup when clicking on Browse in the search results, to avoid > losing the search results; the same for Delete (especially when a Delete > attempt fails) > > When I tried to search using PMA it gives unexpected UI panel repeating within the result window. I check it with the version 3.3.7 and in that it works fine. Here is the link which I have showed the screen shots of the results which I get. Here the "Tab navigation bar [1]" and the "Search in database[2]" panels showed twice. https://docs.google.com/document/d/1eEEgOemO8uhkzAw_aFYOSwHDKYZeiLRPuVDjAHx… I'm Using Ubuntu 10.10 as the os, apache-2.2.16 as the server and using a symlink to the phpmyadmin folder and Google chrome as the browser for testing this. Can you clarify whether this is a bug. > > Are you familiar with jQuery? > > Last few days I went through some jQuery tutorial and now having some basic knowledge on it. So I'm willing to start working on the improvements you have mentioned. Are there any standards which should I follow in PMA UI designing. I will start working on the task of -collapse/expand the "Search in database" fieldset. But in the -separate popup when clicking on Browse in the search results, task needs a better structure. So may I draw a wire-frame for that UI, so you can correct me if it needs any modification. Regards, Thilanka. -- http://coders-view.blogspot.com/ http://thilankagekawuluwa.blogspot.com/ http://twitter.com/thilanka_k

3 40

[Phpmyadmin-devel] GSoC 2011: Browse-mode Improvements ++
by Aris Feryanto 03 Apr '11

03 Apr '11

Hi, Previously, I have emailed some of my suggestions on User Interface Cleanup project. But after doing some research, I found that compared to User Interface Cleanup project, Browse-mode Improvement project will provide me to achieve the satisfied result and bring me higher chance of success. I have submitted a proposal on this project and also have added some ideas besides feature requests listed on the phpMyAdmin Ideas Page. The following is my suggestions for this project. Any comment and suggestion are welcome. Synopsis: This project is intended to improve the convenience of users when using phpMyAdmin, particularly when browsing tables. This can be achieved by adding the following features to phpMyAdmin: •Browse recently used tables •Remember the last way user sorted tables •Flexible table’s column width •Reorder table’s column using mouse during browsing •Show only selected columns •Integration of navigation bar •Edit only selected field •Grid view in the table edit page Project Details: •Browse recently used tables Interface As discussed in the feature tracker , we can show recent tables that have been viewed by user as a drop-down list in the navigation frame. To keep things simple, the preferences will only show a checkbox “Display recent [#] tables” with the [#] default to 10 and can be set by user. Storage Recently used tables can be stored in phpmyadmin database if it has been configured or in session variable if it is not. •Remember the last way user sorted tables Sorted column of each table can be stored (if the table is ever sorted) in phpmyadmin database or in session variable. When user browse a table, this value is read and added to sorting criteria of the SQL select query. This value must be synchronized with current database, i.e. when user drop a field, table, or database, the corresponding sorting value must be deleted. Up to three points below are inspired by: http://www.flexigrid.info/ by Paulo P. Mariñas •Flexible table’s column width & reorder table’s column using mouse during browsing We can add functionality to adjust width and reorder table’s column by using jQuery. Again, table’s column order can be saved in phpmyadmin database or in session variable. An option “Remember tables’ columns order” can be added to the preference page. •Show only selected columns Currently, users have to run a SQL SELECT query or create a VIEW to display only certain columns from a table. This is sometimes cumbersome. We can improve this by adding a drop-down list in table’s header, giving checklist options to show only certain columns. This can be done by using jQuery. •Integration of navigation bar Current interface of navigation bar (prev, next) and “Show # row(s) starting …” can be integrated with the query-result table. So it will look like a part of the table and make user more convenient to use the navigation. •Edit only selected field One way to achieve this: modify current edit page to show only selected field. When user runs a select query, select some rows, and then click edit, some variables will be passed to edit page, so it hides fields that are not shown in the query result. Alternatively, an option to show/unhide all fields can be added. •Grid view in the table edit page Sometimes, users want to be able to edit only certain selected rows, but with a browse-like view. (Think of actions: browse -> select some rows -> With selected: edit) I am thinking of improving the edit page, so user can have an option to edit table in a grid view instead of current edit view. The grid view will be simple, 2D grid, like in browse table. Each cell will be resizable text field, where user can change the value directly by typing in it. I think this will be a complement of inline edit, since we can edit TEXT type value (which cannot be edited in inline edit).

3 5

[Phpmyadmin-devel] Proposal Submitted
by 陈岳峰 03 Apr '11

03 Apr '11

Hi, I've split my first proposal into two. Hoping for some suggestions. Best, Dennis Chen

1 0

[Phpmyadmin-devel] GSoC Ideas
by Michael Bundy 02 Apr '11

02 Apr '11

Hello, I'm a second year CS and EE at Bristol University, England. I have exams until the 17th of June. I know officially students are meant to start on the 23rd of May, and I would be willing to make a start then, but since I have exams around that period, I wouldn't be able to work on it full time until the 17th. Would this be a problem? Okay, I'm thinking of putting forward 2 proposals, both from the idea's page. But before I do, I need to clarify a few things. *Zoom Search* (and more AJAX) I'm not sure if anyone has ever looked into it, but jqPlot looks like it'd be ideal for this. It already has a zoom feature, offers a bit of "shininess", and would be quite straight forward to implement, I feel. Since pma is already implementing jQuery, using a plugin of it makes sense. jqPlot also offers a simple line of best fit. Would a few more simple mathematical functions (K-means, standard deviation, Cov?) be worth it? While I don't expect anyone to want to do anything serious in a browser, it might be worth it to have a simple way of viewing trends without having to export the database to something like matlab. Even with the extra mathematical functions, I feel like it probably wouldn't take much time to implement - i.e less than 4 weeks - and adding more AJAX seems to be the idea that naturally fits. If this seems like a good idea I'll look more into the AJAXify part. (and probably try 1 or 2 for a contribution) Failing that, dealing with the "Browse-mode improvements", I feel that working full time on that, I could probably get through most of that list in about 4 weeks, especially since jQuery can be used. The main question here is would phpmyadmin save thing's like the last view table or SQL command in a flat file, use the database or have a choice? The jqPlot website has a lot of examples on it ( http://www.jqplot.com/tests/ ) I'm currently working on the concept, though its still a WIP and right now only displays random data. Still, I think it should shows that doing what is required should be quite straightforward. http://mirey.pcriot.com/zoom.php *phpMyAdmin OOP* This seems like a massive job, as it'd be rewritting the whole of PMA. Would there be any opposition to using a framework such as codeigniter? I guess the main question is, would it use none of the old code until it is finished, or would it there be a period where it would be OOP and the old procedural stuff? An argument against CI is that people would have to learn how to use CI. But I'd argue that having an arbitrary way of doing it would be more time consuming to learn, and people are likely to know how to use CI, or something similar anyway. Would it be worth splitting this down into a number of student projects, each focusing on a particular part? I'd ultimately like to do this, though before I think about it further, I'd want to know whether I could use a framework, or if it would need to be from scratch. Thank you, Mike

4 4

[Phpmyadmin-devel] About GSoC
by P Coder 01 Apr '11

01 Apr '11

Hi, I am a great enthusiast of phpMyAdmin and am willing to participate in GSoC in one of the phpMyAdmin projects. I have ample experience in and understand the working of phpMyAdmin very well. But the first requirement for submitting my proposal for any of the projects under phpMyAdmin seems to be submission of a patch. Could somebody help me on how I could submit a patch? Do I find a bug in the bug-tracker and fix it? I am hoping against all odds, to be able to submit a patch before 8th April and be able to submit my proposal. Any help would be highly appreciable. Thank you, M.Ravi

2 1

[Phpmyadmin-devel] MySQL queries
by Samiran Raj Boro 31 Mar '11

31 Mar '11

I am not so sure whether to post it here or not. As I have decided to work on Stored procedure support for GSOC project, I need these answers. 1) What are the risk of using mysql database in MySQL? Why is it always suggested to use information_schema instead 2) What is the difference between 'name' and 'specific_name' in mysql.proc? These two seems to be same than why do we need two. Samiran

3 6

[Phpmyadmin-devel] Please help Sir,
by masterxxx7＠ilive.ro 31 Mar '11

31 Mar '11

please send me the password, because I missed the sterile MySQL phpmyadmin and I can not login with old password: edcwsxqaz123 more hostname: masterxxx7.ilive.ro user: admin(a)masterxxx7.ilive.ro parola: edcwsxqaz123 please help and send my password

1 0

[Phpmyadmin-devel] Interested coding for phpmyadmin in GSoC
by Madis Rääk 31 Mar '11

31 Mar '11

Hi everyone, My name is Madis and I'm a student from Tallinn, Estonia. I'm currently studying at the Estonian Information Technology College. My major subject is Systems Development. I have been a using phpmyadmin for about two to three years now. So far your tool has been invaluable for me during the development of web applications. Unfortunately I have been using it as a basic user. And that means I don't have any specific ideas what to develop. But I want to show you guys that I am very interested in coding phpMyAdmin for the GSoC. Mostly I have knowledge in PHP, HTML, CSS and Mysql so anything with these would be nice. Going to download the latest source code from the git repository and try to work with your bugs in the bug tracker. So, give some feedback and how to get more involvede with phpMyAdmin. Take care, Madis

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers