#regular-expressions

• Add Regular Expression Operator to SQLite

  https://justatheory.com/2006/01/add-sqlite-regexen

  Indexed 4/15/2026

• pg_clickhouse 0.2.0

  https://justatheory.com/2026/04/pg_clickhouse-0.2.0

  I guess this is a pg_clickhouse announcement blog, now.

  Indexed 4/15/2026

• Splitting Words in Perl

  https://justatheory.com/2005/09/perl-split-words

  I’ve created a new module, Text::WordDiff, now on its way to CPAN, to show the differences between two documents using words as tokens, rather than lines as Text::Diff does. I plan to use it in Bricolage to give people a change tracking-type view (as seen in word processors) comparing two versions of a document. Fortunately, Algorithm::Diff makes this extremely easy to do. My only real problem was figuring out how to tokenize a string into words

  Indexed 8/26/2025

• How to Use Regex Named Captures in Perl 5

  https://justatheory.com/2006/10/perl-regex-named-captures

  Indexed 4/13/2026

• Regular Expressions are Faster than Unpacking

  https://justatheory.com/2005/03/perl-pack-vs-regex

  Indexed 3/12/2026