Inbuilt VCS

[zaverichintan]

Hey,
Can we have a inbuilt VCS for user generated data?
With Function like connecting local pma to that on server, so that export import thing can be reduced.

Share your thoughts on it.

[nijel]

We have tracking feature already there...

[ghost]

@nijel In the current tracking feature of phpmyadmin, is it possible to make different branches for databases/tables to work on?... Let me give a situation. If a user wants to test a two tables which differ in a minor way. There ae two options:

User tests table 1, then change table 1 to table 2 and then test table 2

He stores table 1 and table 2 in th database and test them.
Is there any other option?.. like creating two branches of same table and then editting them to fit user's needs.

[nijel]

No, there is no branching.

[ghost]

Is it feasible idea to implement it.. Share your opinions please @nijel

[zaverichintan]

@nijel tracking seems to be working on local or server,
It doesn't connect local db to server with version control.
Correct me if wrong

[lem9]

@zaverichintan Please explain the use case for a tracking system that would be connected to an external version control system.

[zaverichintan]

I meant that by connecting to VCS,
Backup and restore with proper version.
I lost my important data due to error in cpanel full restore error, so thought of providing some kind of backup system.

[Achilles-96]

How about we put an automatic backup system with regular intervals. Interval will be decided by the user. Requirement may be that machine must be up at the scheduled time or else data will be backed up whenever machine is up after the scheduled backup.

[lem9]

@Achilles-96 I don't see how this can be done in a web interface such as phpMyAdmin.

[Achilles-96]

@lem9 I am thinking something on the lines of using crontab.

[lem9]

@Achilles-96 If crontab calls phpMyAdmin, there would be a potential security risk because crontab would need the MySQL credentials. Also, phpMyAdmin is not always running in a Unix/Linux environment where crontab is available.

[zaverichintan]

Something similar to git?
Some part of it can be implemented

[lem9]

The team decided this is out of scope for phpMyAdmin.

[zaverichintan]

@lem9
I can understand, Thanks for giving it a thought ,
can we have some sync button to sync databases on local and on server ?

[lem9]

@zaverichintan Database synchronization was implemented in a previous GSoC project but we had to remove the code due to scaling problems.

[zaverichintan]

@lem9 okay, Thank you for your response.

[zaverichintan]

@lem9, can you please elaborate on the scaling problems . I would be interested to resolve the scaling problem.

[nijel]

Synchronization of big databases is always problem - you can not load them into memory to do the comparison. Probably many problems could be avoided with doing more things on the client side, but I still think that synchronizing 1GB database will be challenging.