Developers

developers@phpmyadmin.net

2 participants
7003 discussions

[Phpmyadmin-devel] GSoC Synchronization Project
by Jay Jayswal 17 Mar '15

17 Mar '15

Hello, i am GSoC Participant. i am interested in Synchronization Project. what i understood is we have to build PHP Scripts which connect to Remote Machine and Synchronize data. which means same database structure at both end and we are coping each end's new row's to another end. Right? i have started with my proposal. i wanted to ask what should be length of proposal? 7 or 8 page is okay or Do i have to make it short? Actually, i already did something like this in my past project.i can't disclose code because i signed Non-Disclosure Agreement of that company. it was two platform project. web-application(PHP) and Desktop application(C# WPF). data is stored at desktop database(SQLite) locally, so user can view, update, delete data offline. and when internet available, system will run script to synchronize data. I have faced many problems while solving the problem that i have listed below. can you send me your expected solution for those problem so that i can understand your expectations and project requirement. Problems: *Insert**:* Case 1: insert at DB1 DB1 DB2 Before Synchronization Step1: Two record with ID 1 & 2 in inserted Current rows :1,2 Current rows : null After Synchronization Current rows :1,2 Two record with ID 1 & 2 in inserted Current rows :1,2 Case 2: insert at DB2 DB1 DB2 Before Synchronization Current rows :1,2 Step1: Two record with ID 3 & 4 in inserted Current rows :1,2,3,4 After Synchronization Two record with ID 3 & 4 in inserted Current rows :1,2,3,4 Current rows :1,2,3,4 Case 3: Insert at Both DB1&DB2 DB1 DB2 Before Synchronization Current rows :1,2,3,4 Current rows :1,2,3,4 Step 1: one new record inserted with id 5 Current rows :1,2,3,4,5(of DB1) Current rows :1,2,3,4 Current rows :1,2,3,4,5(of DB1) Step 2: one new record inserted with id 5 Current rows :1,2,3,4,5(of DB2) After Synchronization What should happen in this case? If we want to sync this we need some differentiate to identify both DB. In my past project I provided Device ID. Means PRIMARY KEY and DEVICE ID both will make Composite Key which make it unique to identify. What is your preferred solution? *Update**: in this case we required updated row timestamp, I am assuming there is update_timestamp column in each table* Case 1: update at DB1 DB1 DB2 Before Synchronization Step1: updating row with id 1 Current rows :1(updated),2,3,4 Current rows :1(old),2,3,4 After Synchronization Current rows :1(updated),2,3,4 update row with id 1 Current rows :1(updated),2,3,4 Case 2: update at DB2 DB1 DB2 Before Synchronization Current rows :1(updated),2(old),3,4 Step1: updating row with id 2 Current rows :1(updated),2(updated),3,4 After Synchronization update row with id 2 Current rows :1(updated),2(updated),3,4 Current rows :1(updated),2(updated),3,4 Case 3: update at both side but different timestamp DB1 DB2 Before Synchronization Step1: updating row with id 2 Current rows :1,2(updated),3,4 Current rows :1,2(old),3,4 Current rows :1,2(updated),3,4 Step1: updating row with id 2 Current rows :1,2(updated),3,4 After Synchronization (both update is different and timestamp is also different) In this case both side update is different, what should be final record. I think I should be last one updated. Right? What is preferred solution? Case 4: update at both side but same timestamp DB1 DB2 Before Synchronization Step1: updating row with id 2 Current rows :1,2(updated),3,4 Step1: updating row with id 2 Current rows :1,2(updated),3,4 After Synchronization (both update is different but time stamp is same) In this case both side update is different and time stamp is same!! So here again we need DEVICE ID by which we can identify that both update is different. And what should I store finally, because which one we have to finally store is depends on timestamp, which is SAME for BOTH DB!!! What is preferred solution? *Delete**:* Case 1: deleted at DB1 DB1 DB2 Before Synchronization Step1: row with id 3 is deleted. Current rows :1,2,4 Current rows :1,2,3,4 After Synchronization In this case row with id 3 will be added at DB1 because for SYSTEM it’s newly added row at DB2. To handle this problem in my past project I maintained Activity logs. Which stores that row with id 3 is deleted, so when synchronization take place, I fetch logs from activity log and first delete row with ID 3 in DB2. What is your preferred Solution? Current rows :1,2,3,4 Current rows :1,2,3,4 Regards, Jay Jayswal

2 1

[Phpmyadmin-devel] Regarding first patch after application deadline and making proposal
by Tapan Halani 16 Mar '15

16 Mar '15

According to phpmyadmin applicant guide for GSOC 2015, all applicants must submit at least one working patch by 3 April 2015. Is this patch meant to contain any implementation of our proposed ideas in our project proposals? If so, is it necessary to at-least have some implementation of all the ideas that have been submitted in proposal? Also, I am trying to create a new account in phpmyadmin.net to add my proposal on site. But I cannot create a new account, as everytime I do so , I get redirected to error page containing *Fatal error*: Call to a member function xpath() on a non-object in */usr/share/mediawiki/extensions-core/ConfirmEdit/Asirra.class.php* on line *44* Please guide me through this. Thank you.

2 1

[Phpmyadmin-devel] Bug Fix
by Vaishak Prashanth 16 Mar '15

16 Mar '15

Hello Marc >Vaishak Prashanth a écrit : >> Hello Mark. >> >>>> Vaishak Prashanth a écrit : >>>> Hello everyone ! >>>> >>>> I'm Vaishak, and I've recently started off in the open source community. >>>> You can check out a couple of my projects at github/vaishakp9 >>>> They're not much, but they're open source nevertheless. >>>v >>>> I've been an avid user of phpmyadmin for over a year now. I want to start >>>> helping the community buy fixing bugs. >>>> >>>> I've got a working knowledge of PHP, HTML, C, C++ and some JavaScript. >>>> >>>> Could you please recommend a fairly easy bug for me to work on ? >> >>> Hi Vaishak, >> Is this intended to show us your skills for Google Summer of >Code? > >>>> And where do I start looking to fix said bug on the admittedly huge >>>> codebase ? >>>> >>>> Thanks a lot ! >>>> >>>> Cheers >>>> Vaishak P >> >> >> >>> -- >> Marc Delisle (phpMyAdmin) >> >> >> Yes. This is intended to show my skills for Google Summer Of Code. But not >> only for that. I wasn't very aware of open source projects ... I kept using >> phpmyadmin ... >> >> And then I heard about GSoC and attended a seminar, which is where I >> realized I could actually contribute. >> >> So. Yes. This would be for Google Summer of Code, but irrespective of >> whether I get it or not... I want to contribute to phpmyadmin in a major >> way. >> >> Regards, >> Vaishak >Hi, >well, fixing "a fairly easy bug" is probably not the best way to show >your skills to the mentoring team. Please have a look at the bug tracker >and/or the feature requests tracker, pick something that is unassigned >and mention in the ticket that you are working on it. >I suggest to pick some recent bug tickets or feature requests, as older >ones may be out of date or more tricky to solve. >-- >Marc Delisle (phpMyAdmin) I've decided to work on this : http://sourceforge.net/p/phpmyadmin/feature-requests/1619/ I'll start immediately. Any ideas as to where I can start looking in the codebase ? Regards, Vaishak

1 0

[Phpmyadmin-devel] phpMyAdmin 4.3.12 is released
by Marc Delisle 16 Mar '15

16 Mar '15

Welcome to phpMyAdmin 4.3.12, a bugfix release. Details will appear on http://phpmyadmin.net. You can also visit https://sourceforge.net/projects/phpmyadmin/files to download. The phpMyAdmin team

2 6

[Phpmyadmin-devel] Bug Fix
by Vaishak Prashanth 16 Mar '15

16 Mar '15

Hello Mark. >>Vaishak Prashanth a écrit : >> Hello everyone ! >> >> I'm Vaishak, and I've recently started off in the open source community. >> You can check out a couple of my projects at github/vaishakp9 >> They're not much, but they're open source nevertheless. >> >> I've been an avid user of phpmyadmin for over a year now. I want to start >> helping the community buy fixing bugs. >> >> I've got a working knowledge of PHP, HTML, C, C++ and some JavaScript. >> >> Could you please recommend a fairly easy bug for me to work on ? >Hi Vaishak, >Is this intended to show us your skills for Google Summer of >Code? >> >> And where do I start looking to fix said bug on the admittedly huge >> codebase ? >> >> Thanks a lot ! >> >> Cheers >> Vaishak P >-- >Marc Delisle (phpMyAdmin) Yes. This is intended to show my skills for Google Summer Of Code. But not only for that. I wasn't very aware of open source projects ... I kept using phpmyadmin ... And then I heard about GSoC and attended a seminar, which is where I realized I could actually contribute. So. Yes. This would be for Google Summer of Code, but irrespective of whether I get it or not... I want to contribute to phpmyadmin in a major way. Regards, Vaishak

2 1

[Phpmyadmin-devel] Automated testing for PMA
by Joe Yin 16 Mar '15

16 Mar '15

Hi, I am Joe from Beihang University, Beijing, China. I am major in Computer Sciences. Durning my university, PMA is very popular and a lot of my classmates are using PMA for database management. I am quite interested in the project Automated testing for PMA. I have some php unit test project experience and selenium project experience. when I try to add some unit test case, I found that the Jenkins build is failed, not very stable and without code coverage report. so I can't take a look at the code coverage report. http://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ http://ci.phpmyadmin.net/job/phpMyAdmin/cloverphp/ Is there other place that I can see the code coverage report? thanks, Joe Yin

3 3

[Phpmyadmin-devel] Bug Fix
by Vaishak Prashanth 16 Mar '15

16 Mar '15

Hello everyone ! I'm Vaishak, and I've recently started off in the open source community. You can check out a couple of my projects at github/vaishakp9 They're not much, but they're open source nevertheless. I've been an avid user of phpmyadmin for over a year now. I want to start helping the community buy fixing bugs. I've got a working knowledge of PHP, HTML, C, C++ and some JavaScript. Could you please recommend a fairly easy bug for me to work on ? And where do I start looking to fix said bug on the admittedly huge codebase ? Thanks a lot ! Cheers Vaishak P

2 1

[Phpmyadmin-devel] Gsoc-2015 aspirant
by avinash aman 16 Mar '15

16 Mar '15

Hi, I am Avinash Kumar Aman,4rd year CS student from BITS PILANI. I am interested in participating in this years GSOC with your organization.I am interested in applying for parser/analyzer rewrite.can anyone please guide me where to start from? looking forward for your guidance Regards Avinash Aman

7 11

[Phpmyadmin-devel] Regarding project proposal for GSOC 2015
by Tapan Halani 15 Mar '15

15 Mar '15

Many features on GSOC 2015 ideas page are assigned to different mentors. If I have some ideas about its implementation, should I include its implementation details in my project proposal or not? If not, then how should I reflect in proposal that I am interesting in implementing the feature? And since the applicant do not propose the implementation , then how will he/she be evaluated on his/her abilities to implement the feature?

2 1

[Phpmyadmin-devel] About Project Synchronization
by Jay Jayswal 15 Mar '15

15 Mar '15

Hello, i am interested in GSoC project Synchronization and i have stared making proposal. I know PHP, HTML, AJAX, CSS, JavaScript, JQuery. is there any thing else this project will require? any Library, tool or language? please reply so that i can add those things to my Project Schedule. Regards, Jay Jayswal

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