clickhouse.com/blog/introducing-pg_re2-regex-in-postgres

because sometimes you need it in the db

why not just use python for regex

postgres regex extension

wait what's pg_re2 again

nope too busy crying over regex

anyone tried the new json path stuff

idk but it feels faster

wait is that true

pg_re2 is like 100x faster

because it's slow as hell

why not use ~* operator

i just want to find all emails in a column

like for real though

when you need regex in a query

for what though

pg_re2 is still better

ugh fine

but then you have to export the data...

yes

anyone else just use like grep in a shell script

makes sense

for the error messages

wait why 20 tabs

idk but now i have 20 tabs open

how?

it broke my db

i did...

anyone tried installing it

nevermind

wait what