Re: diff-/patch-functionality for text-type data insidePostgreSQL - Mailing list pgsql-general

From Markus Wollny
Subject Re: diff-/patch-functionality for text-type data insidePostgreSQL
Date
Msg-id 28011CD60FB1724DBA4442E38277F6260C9CA242@hermes.computec.de
Whole thread Raw
In response to Re: diff-/patch-functionality for text-type data inside PostgreSQL  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Hi!

> -----Ursprüngliche Nachricht-----
> Von: Martijn van Oosterhout [mailto:kleptog@svana.org]
> Gesendet: Montag, 4. Mai 2009 15:30

> I've used the Algorithm::Diff module in the past with
> success. It works on sequences of objects rather than just
> text but it works well. That means you can diff on word or
> character level at your choice, and even control what
> sequences you consider "equal". That said, it doesn't have a
> patch function but that should be fairly easy to make. You'll
> need to define your own storage format for the diff though.
>
> http://search.cpan.org/~nedkonz/Algorithm-Diff-1.15/lib/Algori
> thm/Diff.pm

Thank you - I have considered using Algorithm::Diff before, as Text::Diff seems to be based on that and one could, as
youdescribe, create even more granular deltas than just line by line comparisons. The latter would however be fully
sufficientfor my needs, but I think I'll give Algorithm::Diff a closer look now :) 

Kind regards

   Markus


Computec Media AG
Sitz der Gesellschaft und Registergericht: Fürth (HRB 8818)
Vorstandsmitglieder: Albrecht Hengstenberg (Vorsitzender) und Rainer Rosenbusch
Vorsitzender des Aufsichtsrates: Jürg Marquard
Umsatzsteuer-Identifikationsnummer: DE 812 575 276



pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: diff-/patch-functionality for text-type data inside PostgreSQL
Next
From: Dan Armbrust
Date:
Subject: Re: recover corrupt DB?