Hi,
I have had a dialog with Michal Čihař regarding work on a new documentation
for the phpMyAdmin project.
The reason I am sending out this mail on this mailing list is to ask for
input on the format of the documentation.
Texinfo is my preferred way of writing documentation, and at the moment the
only format I am used to write in.
I would like to create a discussion around what format in which the
documentation should be written in.
Best regards,
Cato Auestad
Hi,
I am an undergraduate student studying in India and have found the
idea of user interface cleanup quite interesting and something which I feel
am capable of. I have 2+ years of web development in php (which involved use
of phpmyadmin too). I have worked on the php frontend part of our college's
flagship project Codecracker (http://lug.nitdgp.ac.in/codecracker) and have
been working to improve my skills at web designing.
Some aspects of the interface that I would like to improve upon are:
i) The basic framework of the UI needs to be templatized so as to make way
for clean codeand this will obviously help to ease addition of utilities to
the same.
ii) A better looking and more intuitive approach to the SQL editor as it is
often used by people who are learning SQL.
iii) Also I would like to work on an editor which helps in quick browsing of
all source codes in the webroot of the server, so that changes can be made
then and there itself and executed.
iv) I would like to cut off the no. of pop ups that are displayed as quite a
lot of people find them irritating by embedding the login screen in page
itself.
Also I would like to hear suggestions on more improvements.
Regards,
Tushar I. Ghosh,
Third year, B.Tech
NIT Durgapur
India
Hello everyone,
I'm a student from Munich, Germany and stumbled across the GSoC Idea
of collecting the data that is shown on the server status page and
rendering them as graphs over time. I will apply in the next days,
here is what I thought of implementing when I'm accepted:
Data collection: In the past, I used rrdtool to collect stats on a
server. Its datastore has a limited size - over time old entries get
merged together and the data gets thinner, but is never completely
deleted. Unfortunately, it is not very portable. Therefor, I would
implement a similarily behaving datastore ontop of a mysql table. I
think of storing each set of measures as a row and limit the number of
total rows, making room for new entries by combining one pair of
neighbouring old entries together.
Plotting: On the ideas page GD is suggeted, but I would prefer to use
processing.js, which is a javascript library that draws on a canvas
element with a similar usage.
To connect to the datastore I would build a json interface for the
collected data.
Let me know, what you think of it!
Best regards,
Philip
Hi,
For the last few hours, I've been trying to use jQuery to implement
pagination via AJAX in phpMyAdmin. The page I've selected for
experimenting is the sql.php page, where one can view a table from a
database. I've right now created a javascript file, included it in
the DOM via the $GLOBALS['js_include'] array, and bound an AJAX call
on the navigation buttons.
When I execute the call for a particular table, sql.php replies with
the results for the next 30 rows, but it also outputs a lot of other
html. As a way around this, I plan to use a variable 'ajax_request',
which is set to true when an AJAX call is being made, and accordingly,
wrote the jQuery script. If ajax_request is set to true in $_POST, I
will modify the output of sql.php and print only the table containing
the data from the table, the profiling data, (and any other necessary
part) and prevent the printing of the header, footer and other tabs.
However, due to the sanitization of $_GET, $_POST and $_REQUEST, I am
unable to access the variable.
I tried adding the variable name to variables_whitelist and the
array_list arrays in libraries/common.inc.php, but I guess those are
the wrong places. Could someone please tell me where I'm going wrong,
or which is the right php file/function to check?
Ninad S. Pundalik
http://twitter.com/ni_nadhttp://ninadpundalik.co.cc/blog
GPG Key Fingerprint: 2DF7 B856 C75E C9F9 0504 C0EF D456 1946 7C45 2C69
Hi,
Im from University of Moratuwa, Sri Lanka and I'm really exited on getting a
chance to contribute with phpMyAdmin since it's a really popular software.
Im interested in developing the idea : *Export relations scheme to other
formats. *
*It will be very useful if the relations schemes can be exported to other
formats such as dia files, which are much more suitable for inclusion in
documents.*
*I have experience in working with PHP and MySQL. i have been using these
languages for my University projects.*
*Please provide me further info on this project, I appreciate all the
assistance I can get because I want to participate in GSoC 2010 with a
project for this community.*
Thanks
--
Kishanthan.T
Hi everyone
I'm highly interested in the GSoC project "User interface cleanup".
A little bit about me: My name is Silvan Troxler. I'm studying
computer science at the university of Zurich (Switzerland) and working
as a freelance web developer in my spare time. I also worked for an
internet agency for 18 months before I started studying. My task there
was to build websites and test them in different browsers. In general
I'm experienced in (X)HTML, CSS, JavaScript, AJAX, SQL and PHP (even
some other things). Plus I'm a long time phpMyAdmin user (at least
five years) and a long time phpMyAdmin theme hater ;-) I'm more a
programmer than an excellent designer. But I have an eye for
aesthetics and appreciate sleek, minimal and self-explaining designs
(as phpMyAdmin should have one). I also would love to express myself
in such a well-known project as phpMyAdmin and learn even more about
graphics, usability and accessability. I started working with web
sites back in 2002.
Back to the project: I plan to implement a template engine into
phpMyAdmin as a starting point. This will simiplify the further
development of the GUI and make it much easier to work with AJAX. For
example with the template engine Smarty I made good experience and use
it almost everytime. Especially as of version 3 Smarty is very easy to
use and implement. Do you have other proposals for another template
engine as well? As a further point I would love to get rid of the
frames in PMA. With a template engine, this would be not that hard.
And of course the UI will be cleaned up but I don't yet have any
mockups.
If you are interested in my coding style you may have a look at a
project I was developing the last six weeks for an university project.
It is some kind of bug tracking system which can be integrated in
existing websites and collects all PHP errors which occur. With this
you can for example collect all E_STRICT errors which where hidden on
the web server. It also features a overview page for all errors which
occurred with an easy search interface (similar to the one of trac).
Consider this application as a veeeery alpha one which needs much of
cleaning before beeing usable. This project uses JQuery and Smarty.
http://silvantroxler.ch/gsoc/mdudu-0.0.1a.zip (about 360KB)
Thanks for your replies and your work on PMA
Cheers
Silvan Troxler
ps: I have to do some kind of internship for the university and GSoC
counts as one, so it would be great if I could be a part of this years
extending/improving of PMA :)
Hi everyone,
I'm Yian, currently an undergrad at UC Berkeley. I am interested in
participating in phpMyAdmin's GSoC this year as I've used phpMyAdmin for
many years (on a number of web applications) and would like to finally make
some contributions.
I've looked through the list of project ideas and the source code, and I
find that I'm most interested in working on exporting the relations schema
to other formats. I'll start going through the source code a bit more and
perhaps think about how to export schemas to dia or svg.
Out of curiosity, would exporting the schema to dia involve only exporting
the structure whereas exporting to svg might have the data (organized in
some user-specified way, like maybe by summing certain fields together for
everything with the same X)?
Best,
Yian Shang
