mysql::diff(3pm) [debian man page]

MySQL::Diff(3pm)					User Contributed Perl Documentation					  MySQL::Diff(3pm)

NAME

       MySQL::Diff - Generates a database upgrade instruction set

SYNOPSIS

	 use MySQL::Diff;

	 my $md = MySQL::Diff->new( %options );
	 my $db1 = $md->register_db($ARGV[0], 1);
	 my $db2 = $md->register_db($ARGV[1], 2);
	 my $diffs = $md->diff();

DESCRIPTION

       Generates the SQL instructions required to upgrade the first database to match the second.

METHODS

   Constructor
       new( %options )
	   Instantiate the objects, providing the command line options for database access and process requirements.

   Public Methods
       Fuller documentation will appear here in time :)

       o   register_db($name,$inx)

	   Reference the database, and setup a connection. The name can be an already existing 'MySQL::Diff::Database' database object. The index
	   can be '1' or '2', and refers both to the order of the diff, and to the host, port, username and password arguments that have been
	   supplied.

       o   db1()

       o   db2()

	   Return the first and second databases registered via "register_db()".

       o   diff()

	   Performs the diff, returning a string containing the commands needed to change the schema of the first database into that of the
	   second.

COPYRIGHT AND LICENSE

       Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

SEE ALSO

       mysqldiff, MySQL::Diff::Database, MySQL::Diff::Table, MySQL::Diff::Utils

AUTHOR

       Adam Spiers <mysqldiff@adamspiers.org>

perl v5.14.2							    2012-04-06							  MySQL::Diff(3pm)

Algorithm::Diff::XS(3pm)				User Contributed Perl Documentation				  Algorithm::Diff::XS(3pm)

NAME

       Algorithm::Diff::XS - Algorithm::Diff with XS core loop

SYNOPSIS

	   # Drop-in replacement to Algorithm::Diff, but "compact_diff"
	   # and C<LCSidx> will run much faster for large data sets.
	   use Algorithm::Diff::XS qw( compact_diff LCSidx );

DESCRIPTION

       This module is a simple re-packaging of Joe Schaefer's excellent but not very well-known Algorithm::LCS with a drop-in interface that
       simply re-uses the installed version of the Algorithm::Diff module.

       Note that only the "LCSidx" function is optimized in XS at the moment, which means only "compact_diff" will get significantly faster for
       large data sets, while "diff" and "sdiff" will run in identical speed as "Algorithm::Diff".

BENCHMARK

			     Rate     Algorithm::Diff Algorithm::Diff::XS
       Algorithm::Diff	   14.7/s		   --		     -98%
       Algorithm::Diff::XS  806/s		5402%		       --

       The benchmarking script is as below:

	   my @data = ([qw/a b d/ x 50], [qw/b a d c/ x 50]);
	   cmpthese( 500, {
	       'Algorithm::Diff' => sub {
		   Algorithm::Diff::compact_diff(@data)
	       },
	       'Algorithm::Diff::XS' => sub {
		   Algorithm::Diff::XS::compact_diff(@data)
	       },
	   });

SEE ALSO

       Algorithm::Diff, Algorithm::LCS.

AUTHORS

       Audrey Tang <cpan@audreyt.org>

COPYRIGHT

       Copyright 2008 by Audrey Tang <cpan@audreyt.org>.

       Contains derived code copyrighted 2003 by Joe Schaefer, <joe+cpan@sunstarsys.com>.

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.12.3							    2008-10-24						  Algorithm::Diff::XS(3pm)