GSoC Meetup at FACCAT

Hi folks!

Last April 8, we did an amazing meetup at Faculdades Integradas de Taquara - FACCAT (Taquara, Brasil), to talk about the Google Summer of Code (GSoC). I participated twice on GSoC, working for The PostgreSQL Global Development Group on phpPgAdmin project. You are welcome to read the last posts on this blog that talk about what I did, with help of my mentors Jehan-Guillaume de Rorthais and Andreas Scherbaum.

More than 70 students were there. We discuss what is the program, how it works, why and how to participate! I feel that a lot of students of my region are now very interested to write a proposal this year. Would be very nice more students from here coding on GSoC during the brazilian winter :-)

I would like to thank FACCAT for host the meetup. Other pictures about the meetup can be found here.

Stay tuned, the student application period opens at April 22. More details at Google Summer of Code Home Page

GSOC 2011 - Last news

Hi people,

First of all, sorry not writing much last weeks. So, let me update you about my project.

In July the Google Summer of Code Students submit the mid-term evaluation, and the mentors as well. For me the result was.... I was approved, yeah!!! \o/

Meanwhile, I have been working finishing the integration between the Browser Tree and the new plugin Example. The Example is a demonstration plugin we have been developing for phpPgAdmin, that will guide the developers to create other plugins.

So, I and my mentors discussed a lot about escaping issues, to prevent the plugins have security problems. That's a very important thing in softwares ;-)

And now, I finished some of my mentors' reviews.

That's all people, see you soon!

Plugins and trees

Hi folks,

Here I am again to talk about my current activities in Google Summer of Code program 2011.

In the last two weeks, I have been working integrating the new Plugin Archictecture, with the phpPgAdmin Browser Tree.

I had a lot of difficulties to understand how the Browser Tree works. But my mentors showed me the light of how to create a hook for this feature.

So, I have created a simple example extending the schema's page. Below is displayed an image of this example:

Browser Tree

It is not ready yet. I need to create more page levels, and maybe other examples to demonstrate this feature working.

My mentors also have done reviews in my code, and I worked fixing some issues as well.

That's all for now. I hope in the next post to write that the Browser Tree Hook is done :)

GSoC 2011 - Plugin architecture and action buttons - Part II

Hello,

During the week I have worked finishing the integration between the new phpPgAdmin plugin architecture and the action buttons. An example of this feature can be saw below:

This way, all page that have action buttons, now can have new extra operations.

By the way, in my examples I am using data from Pagila, that is a very usefull collection of sample databases.

Now I will start working integrating the Browse Tree part with the plugin architecture.

Well, that's all for while. See you soon!

GSoC 2011 - Plugin architecture and action buttons

Hi people!

This week I have worked finishing the integration between the navigation links and the new plugin architecture. I had to refactor some files in the phpPgAdmin core to this feature be possible.

Now I am developing a new feature, creating a hook for action buttons. See the image below to understand well what these buttons are:

I have created a hook for it, and a simple example to show this feature working. There are some files in the phpPgAdmin to refactor, and some of them I have already refactored. My mentors and me have been discussing about that.

Jehan and Andreas also sent me more comments and reviews about our work so far.

That's all for while. See you guys!

GSoC 2011 - Trails, navigation links and reviews

Hey guys!

It was more a week working on Google Summer of Code 2011.

These This week I have worked on the integration between the trails component and our new plugin architecture. A preview can be saw below:

My mentors sent me some reviews of the code, and we worked together, discussing to solve them. Reviews are very important during the development of software. Some time developers do not realize some mistakes and bugs. Other opinions are also important to get new points of view.

I also have been working on the integration between the navigation links and the new plugin architecture. To make it, I had to refactor some code inside the phpPgAdmin (PPA). I confess I didn't imagined this would be necessary, but, in the other hand, it was important for me know parts of PPA that were unknown to me.

Well, that's all for today. Cheers!

GSoC 2011 - Go code

Hi folks!

Last week the Google Summer of Code 2011, coding period, started. And, during this week, I worked on a feature to integrate the new plugin architecture with the phpPgAdmin (PPA) tabs. I also review the toplinks code, creating a simple page to demonstrate the plugin Example working. If you do not know what are tabs or toplinks in the phpPgAdmin, take a look at the following image:

phpPgAdmin screen shot

Right now I am working on the integration between the Trail (see above) and the new plugin architecture. The logic of this part is not that much different from the tabs.

I think the basic structure is going well, and the development is in the schedule. Anyway my mentors has been reviewing my code, and doing some constructive suggestions about it. Some of the comments have been discussed during this week among me, my mentors and other PPA developers, as Mr. Robert Treat. I thank the attention that my mentors, and other developers as well, are giving to this project, together we will achieve successfully results :D

That's all for today, see you soon!

GSoC 2011 is ON

Hi folks!

The bonding period has finished. During this time, I contacted my mentors, Jehan and Andreas, to discuss more about our great project. If you don't remember, in this GSoC, we will develop a new Plugin Architecture for phpPgAdmin.

Well, I started up my development environment, with all PostgreSQL versions. I will work with:

• PostgreSQL 7.4 -> 9.1 beta
• PHP 5.3
• GNU/Linux Ubuntu 10.04
• GIT 1.7
• Apache 2
• jEdit to code

I also created a script to install all the PostgreSQL, if for any reason, I have to create a new development environment. We have just 3 months to do this job, so, we cannot have problems ;)

My mentors teach me how to use the Selenium to make tests. I thought it amazing, perhaps, I had a different point of view about Selenium stuff. With a simple action, I can make regression tests, to check what I am doing will work with all PostgreSQL versions. It's very nice, don't you agree?

More things that they teach me were about how write good logs for my commits. I confess that using Subversion I didn't make comments in my commits, but it's very important. And, day by day, I am getting more knowledge using GIT, and GitHub. By the way, my phpPgAdmin fork can be found here.

I also learned a lot about IRC abbreviations, like IIRC, AFAIK, *g*, re, etc...

Well, see you on other post guys :-)

GSoC 2011 - Bonding period

Hello people

The GSoC 2011 has begun. Until May 22 is the bonding period. In this time, the students should contact their organizations and mentors to talk about their projects.

This year I will have two mentors to help me accomplish the project, Mr. Jehan and Mr. Andreas. They are helping me a lot. Jehan teach me how use the GitHub, and integrate it with our IRC channel (irc.freenode.net #phppgadmin). Every time I push something to my phppgadmin fork, the GitHub send a message by IRC with informations about it. I liked a lot this feature.

According to my activities, the first task is to drop the current plugin architecture. It is deprecated, and the only ppa plugin has a lot of intrusive code inside phppgadmin. Jehan teach me how use branches with GIT, I have already created a branch and pushed it to my phppgadmin fork. When Jehan and Andreas validate my patch, I will merge it with my main line of work. And after, I will pull to main phppgadmin project.

Now I am working on the basic plugin structure. I hope to finish it on time, and start working on other subjects :-)

That's it for now people, see you soon...

Google Summer of Code 2011

Hi people, I have good news:

"Dear Leonardo, 

Congratulations! Your proposal "New phpPgAdmin Plugin Architecture" as submitted to "PostgreSQL Global Development Group" has been accepted for Google Summer of Code 2011."

Yeah!! Amazing news!

I thank my mentor Mr. Jehan-Guillaume de Rorthais, co-mentor Andreas
Scherbaum, the PostgreSQL Global Development Group and the Google for help and accept me as student in this important program.

In my participation in the Google Summer of Code 2011, I have the goal to refactor the current plugin architecture, creating another one.

A copy of my proposal can be found in this link.

During the next days, I will post what I am doing in the GSoC 2011.

Now, the work begins :D

Google Summer of Code - Final evaluation results

"Hi Leonardo Augusto Sapiras,

We have processed the evaluation for your project named Improve phpPgAdmin ergonomy with PostgreSQL.

Congratulations, from our data it seems that you have successfully passed the Final Evaluations. Please contact your mentor to discuss the results of your evaluation and to plan your goals and development plan for the rest of the program

Greetings,
The Google Open Source Programs Team"

  Wow!!!! I have passed \o/

  One more time I thank my mentor Jehan-Guillaume de Rorthais, and  phpPgAdmin developers for all the help, the organization PostgreSQL and Google for the opportunity that they gave to working together with they on the improve of open-source softwares.

  Cheers!

Google Summer of Code - Resultado da avaliação final

"Hi Leonardo Augusto Sapiras,

We have processed the evaluation for your project named Improve phpPgAdmin ergonomy with PostgreSQL.

Congratulations, from our data it seems that you have successfully passed the Final Evaluations. Please contact your mentor to discuss the results of your evaluation and to plan your goals and development plan for the rest of the program

Greetings,
The Google Open Source Programs Team"

 Feito!!!! Passei \o/

  Mais uma vez agradeço meu mentor Jehan-Guillaume de Rorthais, e aos desenvolvedores do phpPgAdmin por toda ajuda, as organizações PostgreSQL e Google pela oportunidade que me deram para trabalhar junto com elas na melhoria de softwares open-source.

  Abraços!

Google Summer of Code - Last weeks

  Hi people,

  The last few weeks working on Google Summer of Code have been hard-working, intricate details to make and end of activities coming let anyone almost crazy. But last Monday I got to finish everything and send to the phpPgAdmin development team. I thank my mentor Jehan-Guillaume de Rorthais, for all the help and support he gave me and other developers of the project and organization PostgreSQL.

  For more information about my project can be found on this wiki.

  Now, wait for the final results!!!!

Google Summer of Code - Últimas semanas

Olá pessoal,

  As últimas semanas do Google Summer of Code foram trabalhosas, detalhes complicados para se fazer e o fim das atividades chegando deixam qualquer um quase maluco. Mas, segunda-feira passada consegui terminar tudo e enviar para a equipe de desenvolvimento do phpPgAdmin. Agradeço ao meu mentor Jehan-Guillaume de Rorthais, por toda a ajuda e apoio que ele me proporcionou, bem os demais desenvolvedores do projeto e a organização PostgreSQL.


  Maiores informações sobre o meu projeto podem ser encontrados na wiki dele.

  Agora, que venha o resultado final!!!!

Midterm evaluation

"Hi Leonardo Augusto Sapiras,

We have processed the evaluation for your project named Improve phpPgAdmin ergonomy with PostgreSQL.

Congratulations, from our data it seems that you have successfully passed the Midterm Evaluations. Please contact your mentor to discuss the results of your evaluation and to plan your goals and development plan for the rest of the program

Greetings,
The Google Open Source Programs Team"

Passei \o/

Browsing on foreign keys

Hey people, since June 10, I am working on a new feature inside the phpPgAdmin.

With this new functionality, the user will can obtain information from related tables that the record he is browsing has, if exists foreign keys. When the user clicks on a foreign key, the record of this FK will be show.

I am having much work to make this, but the phpPgAdmin developers, in special my mentor, are helping me a lot.

Navegando em chaves estrangeiras

Bom pessoal, desde o dia 10 de junho, eu estou trabalhando no em uma nova funcionalidade dentro do phpPgAdmin.

Com essa funcionalidade, o usuário poderá obter informações de tabelas relacionadas na qual ele está navegando, caso nela existam chaves estrangeiras. Quando o usuário clica na chave estrangeira, será exibido o registro dessa chave.

Isso está sendo trabalhoso, mas os desenvolvedores do phpPgAdmin, em especial meu orientador, estão me ajudando bastante.

Processes page ergonomy - English

During the second week of GSoC (01/06 to 08/06), I worked into the processes page of phpPgAdmin. The screen of processes now has the same functionality implemented in the locks page.

This week I also realized improvements in what has been implemented so far, following suggestions of my mentor, Jehan-Guillaume de Rorthais, and developer community. The experience and goodwill of them are helping me a lot in my activities. The phpPgAdmin community is to be congratulated :)

I was a time without putting my Google Summer of Code activities here on the blog, I hope to do this more often.

See you later :)

Melhoria de usabilidade na tela de processos - Português

Durante a segunda semana de GSoC (01/06 até 08/06), trabalhei na tela de processos do phpPgAdmin. A tela de processos agora tem as mesmas funcionalidades implantadas na tela de locks.

Nessa semana eu também realizei melhorias no que foi implementado até o momento, seguindo sugestões de meu orientador, Jehan-Guillaume de Rorthais, e da comunidade de desenvolvedores. A experiência e a boa vontade deles estão me ajudando muito em minhas atividades. A comunidade phpPgAdmin está de parabéns :)

Fiquei um tempo sem colocar minhas atividades do Google Summer of Code aqui no blog, espero poder fazer isso com mais frequência.

Até mais :)

Locks page ergonomy - English

During the first week of coding (24/05 to 31/05), I worked on improving the screen locks of phpPgAdmin.

My activities were making only the locks (locks), they were recharged, and it occurred at a given time, automatically.

Using Ajax, every X seconds, the locks are now updated automatically. The user can also interrupt the update, you just have to click on the image of 'Stop,' and then 'Start' if he wishes to continue updating the data.

The update time is defined in the phpPgAdmin configuration file.

Since this screen can contain many records, was added a link in the bottom, so, the user can be directed to the top of the page where the buttons and links operations are found.

Because this is my first patch, the other phpPgAdmin developers made suggestions for improvements, and little by little I'm becoming more familiar with the methodology and the codification of phpPgAdmin.

My mentor, Mr. Jehan-Guillaume de Rorthais, is always present, making suggestions, criticisms and contributions, thanks Jehan :)