14.3. Regular Expressions and SQL
Database-driven applications have to process huge amounts of data. If pattern matching with the help of regular expressions is performed by PHP, the entire data has to be transferred to the Web server where the PHP interpreter is running. With huge amounts of data, this is not a good solution because a large amount of memory and network bandwidth is wasted. Therefore, it can be useful to utilize regular expressions on the database level. PostgreSQL is capable of working with regular expressions. In some cases this is the more efficient way because of less overhead.
In this section you will learn about regular expressions and SQL.
14.3.1. Getting Started with SQL Regular Expressions
Working with SQL-style regular ...
Get PHP and PostgreSQL: Advanced Web Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
