Calling Developers!
We are reenergizing our code contribution process! Learn More

What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

Quick question on the CTE topic after migration to the new Spryker tech stack (MariaDB): are there

Options
UP4C7GASJ
UP4C7GASJ Posts: 19 🧑🏻‍🚀 - Cadet

Quick question on the CTE topic after migration to the new Spryker tech stack (MariaDB):

are there any official suggestions on how to optimize the imports when we want to work with batches? In the past we took some reference from https://docs.spryker.com/docs/scos/dev/guidelines/data-processing-guidelines.html#common-table-expressions as especially the unnest feature in PgSQL was a great way to work with array structures. In MariaDB (or MySQL in general) these operations are not available anymore, CTE are still working but not in the array way.

Any suggestions here how to approach it? Are there maybe any "update guides" on the CTE topic for MariaDB? Thanks in advance!
Stay safe out there ✌🇺🇦

Comments