Tailwind Classes In The Database

You will need at some point to add the tailwind classes that are in the html content within the database.

Example

Below is an example sql query to list all css classes found in the page_html table:

WITH extracted AS (
    SELECT unnest(regexp_matches(html, 'class="([^"]*)"', 'g')) AS classes
    FROM page_html
)
SELECT DISTINCT unnest(string_to_array(classes, ' ')) AS class
FROM extracted
ORDER BY class;