SQL to get Products and related data from PostgreSQL
3 years ago, October 19, 2021
The objective of this exercise for me was to dump all the product data as CSV / JSON so I could index them into Algolia. The exercise consisted of multiple steps to get to the required form of data. I will run through all those steps and explain what is happening.