Liam Pietralla's Blog
  • Home

Latest

Working with Recursive SQL Statements

Working with Recursive SQL Statements

Using recursive CTEs (common table expressions) can be useful when working with recursive or hierarchical data. Using a recursive CTE will allow us to fetch data using a single query, rather than needing to loop over and use several queries to build up the data as it comes in. Example

By Liam Pietralla 11 Nov 2025
Dockerising a Next.JS website with Payload CMS

Dockerising a Next.JS website with Payload CMS

Next.JS and Payload CMS can be a powerful combination to build a site driven by a free and opensource CMS. Payload can now run directly inside your Next.JS app (since version 3) making it even easier to work with and deploy. Setup First we need to setup Payload

By Liam Pietralla 11 Nov 2025
Liam Pietralla's Blog
Powered by Ghost