[Phpmyadmin-devel] Get some details about Refactoring: Designer/schema integration project idea

[Shamika Dharmasiri]

On Fri, Apr 19, 2013 at 12:55 PM, <
phpmyadmin-devel-request at lists.sourceforge.net> wrote:

> Send Phpmyadmin-devel mailing list submissions to
>         phpmyadmin-devel at lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> or, via email, send a message with subject or body 'help' to
>         phpmyadmin-devel-request at lists.sourceforge.net
>
> You can reach the person managing the list at
>         phpmyadmin-devel-owner at lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Phpmyadmin-devel digest..."
>
>
> Today's Topics:
>
>    1. Re: Get some details about Refactoring: Designer/schema
>       integration project idea (Michal ?iha?)
>    2. CSV using LOAD DATA - format specific options (Kasun Chathuranga)
>    3. Re: CSV using LOAD DATA - format specific options (Marc Delisle)
>    4. Re: CSV using LOAD DATA - format specific options
>       (Kasun Chathuranga)
>    5. Re: CSV using LOAD DATA - format specific options
>       (Kasun Chathuranga)
>    6. Re: GSoC Project - AJAX Error Reporting (Abhishek Kandoi)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 18 Apr 2013 10:44:57 +0200
> From: Michal ?iha? <michal at cihar.com>
> Subject: Re: [Phpmyadmin-devel] Get some details about Refactoring:
>         Designer/schema integration project idea
> To: Shamika Dharmasiri <shamikadineshdha at gmail.com>,
>         phpmyadmin-devel at lists.sourceforge.net
> Message-ID: <20130418104457.6c806770 at nutt.cihar.com>
> Content-Type: text/plain; charset="iso-8859-2"
>
> Hi
>
> Dne Thu, 18 Apr 2013 13:43:40 +0530
> Shamika Dharmasiri <shamikadineshdha at gmail.com> napsal(a):
>
> > Hi Michal,
> > The demo server is with (Version information: 4.1-dev, latest stable
> > version: 3.5.8)
> > But my local PMA is with (Version information: 4.0.0-dev, latest stable
> > version: 3.5.8)
> > I have used this designer feature with previouse PMA versions.
> > I don't find this  designer feature in my local copy.What may be the
> > problem?
>
> You need to enable configuration storage, see:
>
>
> http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage
>
> --
>         Michal ?iha? | http://cihar.com | http://phpmyadmin.net
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: signature.asc
> Type: application/pgp-signature
> Size: 836 bytes
> Desc: not available
>
> ------------------------------
>
> Message: 2
> Date: Thu, 18 Apr 2013 22:01:59 +0530
> From: Kasun Chathuranga <chathuranga.jayaneththi at gmail.com>
> Subject: [Phpmyadmin-devel] CSV using LOAD DATA - format specific
>         options
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID:
>         <
> CA+AgCPC-mQfrtgY9k-TL56Stmi7V5qYJe17sYKhsn7R-NNi_fQ at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi all,
>
> As indicated in the tracker I am working on fixing the bug #3879 [1] and
> have submitted a pull request [2]
>
> I noticed that in the latest version the interface does not allow changing
> format specific options such as 'Columns separated with', 'Columns enclosed
> with' etc in the import tab. However in the earlier versions these values
> could be specified using the interface.
>
> Is this change intentional or is it a regression?
>
> --
> Regards
> Kasun Chathuranga
>
> [1] https://sourceforge.net/p/phpmyadmin/bugs/3879/
> [2] https://github.com/phpmyadmin/phpmyadmin/pull/267
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 3
> Date: Thu, 18 Apr 2013 12:39:51 -0400
> From: Marc Delisle <marc at infomarc.info>
> Subject: Re: [Phpmyadmin-devel] CSV using LOAD DATA - format specific
>         options
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID: <517021D7.7070706 at infomarc.info>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Kasun Chathuranga a ?crit :
> > Hi all,
> >
> > As indicated in the tracker I am working on fixing the bug #3879 [1] and
> > have submitted a pull request [2]
> >
> > I noticed that in the latest version the interface does not allow
> changing
> > format specific options such as 'Columns separated with', 'Columns
> enclosed
> > with' etc in the import tab. However in the earlier versions these values
> > could be specified using the interface.
> >
> > Is this change intentional or is it a regression?
>
> A regression: see [3].
>
> [3] https://sourceforge.net/p/phpmyadmin/bugs/3883/
>
>
> --
> Marc Delisle
> http://infomarc.info
>
>
>
> ------------------------------
>
> Message: 4
> Date: Thu, 18 Apr 2013 22:21:27 +0530
> From: Kasun Chathuranga <chathuranga.jayaneththi at gmail.com>
> Subject: Re: [Phpmyadmin-devel] CSV using LOAD DATA - format specific
>         options
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID:
>         <CA+AgCPAsAVQu+-k=
> uv8rVJjkguGyf90RFL84nHwtvhTyOyGn7Q at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On Thu, Apr 18, 2013 at 10:09 PM, Marc Delisle <marc at infomarc.info> wrote:
>
> > Kasun Chathuranga a ?crit :
> > > Hi all,
> > >
> > > As indicated in the tracker I am working on fixing the bug #3879 [1]
> and
> > > have submitted a pull request [2]
> > >
> > > I noticed that in the latest version the interface does not allow
> > changing
> > > format specific options such as 'Columns separated with', 'Columns
> > enclosed
> > > with' etc in the import tab. However in the earlier versions these
> values
> > > could be specified using the interface.
> > >
> > > Is this change intentional or is it a regression?
> >
> > A regression: see [3].
> >
> > [3] https://sourceforge.net/p/phpmyadmin/bugs/3883/
> >
> >
> > Thanks for the clarification. I will work on a fix.
>
> --
> Regards
> Kasun Chathuranga
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 5
> Date: Thu, 18 Apr 2013 22:54:04 +0530
> From: Kasun Chathuranga <chathuranga.jayaneththi at gmail.com>
> Subject: Re: [Phpmyadmin-devel] CSV using LOAD DATA - format specific
>         options
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID:
>         <CA+AgCPC_67kkwP4kxHME2VPb=p=
> 1uWCVduAY08rypDHerSAOYg at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On Thu, Apr 18, 2013 at 10:21 PM, Kasun Chathuranga <
> chathuranga.jayaneththi at gmail.com> wrote:
>
> >
> >
> >
> >
> > On Thu, Apr 18, 2013 at 10:09 PM, Marc Delisle <marc at infomarc.info>
> wrote:
> >
> >> Kasun Chathuranga a ?crit :
> >> > Hi all,
> >> >
> >> > As indicated in the tracker I am working on fixing the bug #3879 [1]
> and
> >> > have submitted a pull request [2]
> >> >
> >> > I noticed that in the latest version the interface does not allow
> >> changing
> >> > format specific options such as 'Columns separated with', 'Columns
> >> enclosed
> >> > with' etc in the import tab. However in the earlier versions these
> >> values
> >> > could be specified using the interface.
> >> >
> >> > Is this change intentional or is it a regression?
> >>
> >> A regression: see [3].
> >>
> >> [3] https://sourceforge.net/p/phpmyadmin/bugs/3883/
> >>
> >>
> >> Thanks for the clarification. I will work on a fix.
> >
> > Hi,
>
> I have fixed the regression and updated my pull request [2].
>
> Most of the format specific options are common to both CSV and CSV with
> LOAD DATA. Hence, I have pulled the common code for generating these common
> options to an abstract super class to avoid code duplication.
>
> It would be great if you could review it.
>
> --
> Regards
> Kasun Chathuranga
>
> [2] https://github.com/phpmyadmin/phpmyadmin/pull/267
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 6
> Date: Fri, 19 Apr 2013 12:55:09 +0530
> From: Abhishek Kandoi <abhikandoi2000 at gmail.com>
> Subject: Re: [Phpmyadmin-devel] GSoC Project - AJAX Error Reporting
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID:
>         <CABtPNt37CVwVdUs73K4=rpqO6=
> KuOdLvDsUSiTXhJhoVu05h0A at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I was wondering if you can tell me about some of the shortcomings that you
> found in my webapp.
> I can teach me a lesson and I can learn something new from it and improve
> in my future projects.
>
>
> On Wed, Apr 17, 2013 at 3:07 AM, Abhishek Kandoi
> <abhikandoi2000 at gmail.com>wrote:
>
> > On 4/16/13, Rouslan Placella <rouslan at placella.com> wrote:
> > > On 04/15/2013 07:16 PM, Abhishek Kandoi wrote:
> > >> Hi Rouslan,
> > >>
> > >> Thanks for replying. I was unable to reply properly using my
> SourceForge
> > >> account.
> > >   I have worked with a few mailing lists like Google Groups, but this
> > > one seemed different to me.
> > >   I didn't even get emails when you people replied on this thread
> > > because I had my Digest Mode On,
> > >   thus I didn't have an option to Reply to All.
> > >>
> > >> I will be formatting manually for this time only, as I have no email
> to
> > >> reply to.
> > >   (Didn't wanna spoil the reply format)
> > >>
> > >> Rouslan Placella wrote:
> > >>
> > >>> Hi Abhishek,
> > >>>
> > >>> have you got a live demo of this application that I could try?
> > >>
> > >> Yes, you can try it online at
> http://faceinbook.co.nr/flowork/home.html
> > .
> > >
> > > Out of curiosity, was the app a college project?
> > >
> >
> > No. I made it as an assignment given to me at SDSLabs(a group of like
> > minded students developing open source) after a Lecture on basic PHP.
> > I had to attend it although I knew everything that was taught. I have
> > been using PHP for the past few years and I really enjoy it.
> >
> > > Also, I would like to hear from you about what you think are the
> > > shortcomings of your implementation. Would you do anything differently
> > > if you had to do it again from scratch?
> > >
> >
> > According to me there are a few shortcomings in my implementation.
> > If I had to develop it again from scratch, I would like to work on the
> > following features:
> >
> > 1) Security implementation(escaping html) to prevent XSS attacks.
> > 2) Adding Modularity to the code both on client-side and on server-side.
> > 3) Limiting the number of unsuccessful  login attempts to prevent easy
> > brute-force based account cracking.
> > 4) Use of Enter button for Login In and Sign Up forms to enhance user
> > experience(the current one lacks this UX feature).
> > 5) Basic animations on deletion of a to-do.
> > 6) Drag and drop functionality for deleting a to-do.
> > 7) Responsive Design for the to-do list (the current one has too small
> > images on a smartphone).
> > 8) Using bcrypt instead of sha1 for password encryption.
> > 9) Ability to nest to-do descriptions and summaries.
> >
> > I have these ideas in my mind for now. Will let you know more, if you
> > are interested.
> >
> > >>> From your email, I'm getting the feeling that you didn't fully
> > >>> understand where the different components of the system will
> reside...
> > >>
> > >> Yeah, I got it a bit wrong on the first go. But on reading the idea
> > again
> > >> I understood
> > >   what exactly it is about.
> > >>
> > >>
> > >>> The server-side component of this system will not be for the users of
> > >>> phpMyAdmin or administrators of individual phpMyAdmin installations,
> it
> > >>> will, instead, be used by the members of the phpMyAdmin development
> > >>> team[0] to globally diagnose issues.
> > >>
> > >> I thought a client-side component for handling errors as well as one
> for
> > > diagnosing issues was suggested. But actually the suggestion was for a
> > > client-side
> > > component for sending errors to a server-side component with the data
> > > containing
> > > nothing that concerns the user about his/her privacy. Thus there is no
> > > need of encryption
> > > as you said, because the data contains no sensitive information.
> > >>
> > >>
> > >> And also as you wrote that there is no means to check if a request is
> > >> valid,
> > > and hence no need for checking for authentication.
> > >>
> > >>
> > >> I would be happy to implement what you suggested about restricting the
> > >> number
> > > of requests per IP to prevent the defacing of the server-system. Also I
> > > will be
> > > more than pleased to work on the server-side part to allow the
> > > phpMyAdmin developers
> > > to analyze and diagnose the errors.
> > >>
> > >>
> > >> Also to prevent the back-end from attacks such as DoS you suggested a
> > >> global limit
> > > on the number of requests. It seems easy to implement but will play an
> > > important role
> > > against DoS attacks.
> > >>
> > >>
> > >> I will reply back after I work out a plan for the server-side
> interface
> > > and functioning for comments from you all.
> > >>
> > >>
> > >> Rouslan Placella wrote:
> > >>
> > >>> The wiki is pretty comprehensive on the matter. Do you have a more
> > >>> specific question?
> > >>
> > >> Yes, is there a place where I can upload a draft of my application
> > > for my mentor to review it? If not, is posting it to the mailing list
> > fine?
> > >
> > > Not that I know of. You can post to the mailing list, but your draft
> > > will be visible to other gsoc candidates.
> >
> > Ok. Thanks for the information.
> >
> > >
> > > Bye,
> > > Rouslan
> > >
> > >
> >
>
>
>
> --
> Abhishek Kandoi
> First Year, Computer Science and Engineering
> Indian Institute of Technology Roorkee
> About Me : about.me/kandoiabhi
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
>
> ------------------------------
>
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
>
> End of Phpmyadmin-devel Digest, Vol 81, Issue 25
> ************************************************
>


Thank you Michal.I manage to enable those features in phpmyadmin.I have a
quick look at these files which participate with the designer and GUI
editor.[

pmd_display_field.php,
pmd_general.php,
pmd_pdf.php,
pmd_relation_new.php,
pmd_relation_upd.php,
pmd_save_pos.php

schema_edit.php
schema_export.php
libraries/schema classes
].
There are many HTML tags mix with php tags and sql queries inside these
files which reduces the understandability of the code which is really need
some refactoring.



Shamika Dharmasiri
Faculty of Engineering
University Of Peradeniya
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20130419/18631eb7/attachment.html>