Regina Obe: Substring function Regex style 🚀 Unleashing the Regex Sorcery with PostgreSQL's Substring Function! 🔍 Hey there, PostgreSQL enthusiasts! Ever dust off that old code and discover a gem ...

-- -- 1234567 -- SELECT 'ABCDEFG' AS original -- ABCDEFG -- --- rightmost 3 characters --- , SUBSTRING('ABCDEFG', 4) AS wrong_1 -- DEFG -- , SUBSTRING('ABCDEFG', 5 ...

A Rails application benchmarking substring search strategies for product inventory systems, comparing PostgreSQL with pg_trgm against MongoDB with regex. This project explores how to implement fast, ...