OpenLampTech No. 214
BigQuery's JSON_FLATTEN() | DRY is not enough | Wicked Features | Env-Interop
Thank you for reading the OpenLampTech newsletter!
If someone awesome shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
OpenLampTech has sponsorship opportunities for your brand, product, service, or job listing in the weekly newsletter.
As an independent publication, collaboration is very affordable. (See the updated and reduced pricing.)
All commentary on the below curated content is mine unless otherwise directly quoted.
As mentioned in the source article, and at the time of this publishing, JSON_FLATTEN() is in preview and not GA yet.
However, if you are using BigQuery (I’m not at this time) and work with JSON data, JSON_FLATTEN() makes it easier to unpack nested arrays instead of relying on multiple UNNEST() calls.
[Medium]
Env-Interop Now Open For Public Review
I saw Env-Interop on Reddit and wanted to share it with OpenLampTech readers.
Described from the source article and quoted here:
“Env-Interop provides interoperable interfaces to load and parse environment files, and encapsulate environment variables, in PHP 8.4 or later”
DRY is Not Enough: When to Evolve Code from Reusable to Decoupled
I’m nowhere near a pro and am still learning the ropes daily (aren’t we all?), but I find articles like this very interesting.
I’ve always (mostly) tried to apply DRY - Don’t Repeat Yourself - principles in the code I work with.
However, that isn’t/doesn’t always work, especially over the long haul.
There is plenty of good information and pointers in this article.
[dev.to]
Interesting Articles
Stop Writing Spaghetti if-else Chains: Parsing JSON with Python’s match-case
7 things that must happen for Linux to overtake Windows in 2026
The “this” Mystery Solved: A No-Nonsense Guide to JavaScript’s Most Confusing Keyword
Your software infrastructure isn’t ready for real AI integration
WordPress/WooCommerce Updates and News
Variation prices caching improvements in WooCommerce 10.5
Thank you for reading OpenLampTech. See you next week.
Josh Otwell
OpenLampTech is a reader-supported publication. Support OpenLampTech with a virtual coffee today!
Something extra…
Did you know I can help you get started with your own Shopify store?
Through my Shopify Partners account, I can set up your store in a development environment with no time limits — so you can design, test, and refine everything before you ever start paying for a plan. Once it’s ready, ownership transfers to you, and your store goes live (at which time you will need to choose a paid Shopify plan).
👉 Note: This offer focuses on store setup and onboarding, helping you get into Shopify and start building confidently. Custom development, design, or full store builds are separate services.
If you (or someone you know) has been considering starting an online e-commerce store, this might be the easiest way to get started.
📩 Reach out to get started or learn more.