Regular Expressions 101

Pro

Group dialect(?P<dialect>[^+:]+)

Negated Character Class[^+:]+

+matches at least one character outside the set below:

+the literal + (43₁₀ / 53₈ / 2B₁₆)

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Non-Capturing Group(?: \+ (?P<driver>[^:]+) )?

?repeats the group contents below at most once:

\+the literal + (43₁₀ / 53₈ / 2B₁₆)

Group driver(?P<driver>[^:]+)

Negated Character Class[^:]+

+matches at least one character outside the set below:

:the literal : (58₁₀ / 72₈ / 3A₁₆)

:// the literal text ://

Group username(?P<username>[^:@]+)

Negated Character Class[^:@]+

+matches at least one character outside the set below:

:the literal : (58₁₀ / 72₈ / 3A₁₆)

@the literal @ (64₁₀ / 100₈ / 40₁₆)

Non-Capturing Group(?: : (?P<password>[^@]+) )?

?repeats the group contents below at most once:

: the literal text :

Group password(?P<password>[^@]+)

Negated Character Class[^@]+

+matches at least one character outside the set below:

@the literal @ (64₁₀ / 100₈ / 40₁₆)

@ the literal text @

Group host(?P<host>[^:/]+)

Negated Character Class[^:/]+

+matches at least one character outside the set below:

:the literal : (58₁₀ / 72₈ / 3A₁₆)

/the literal / (47₁₀ / 57₈ / 2F₁₆)

Non-Capturing Group(?: : (?P<port>\S+) )?

?repeats the group contents below at most once:

: the literal text :

Group port(?P<port>\S+)

\S+any character that is not Unicode whitespace, repeated at least once

/ the literal text /

Group database(?P<database>.*)

.*any Unicode character (except for line terminators), repeated any number of times

Global pattern flags

x modifier: extended. Ignores unescaped whitespace and comments outside character classes

Ready to run

25 tokens

Regular Expression

    (?P<dialect>[^+:]+)
    (?:
      \+
      (?P<driver>[^:]+)
    )?
    ://
    (?P<username>[^:@]+)
    (?:
      :
      (?P<password>[^@]+)
    )?
    @
    (?P<host>[^:/]+)
    (?:
      :
      (?P<port>\S+)
    )?
    /
    (?P<database>.*)

Regular Expression

Unit Tests