OpenLampTech No. 182
MySQL at Uber | LIMIT and OFFSET pagination performance | PHP operators resource | MySQL is 30! | Postgres isn't for everything | Expensive BigQuery pricing
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.
All commentary on the below curated content is mine unless otherwise directly quoted.
Why and how I'm simplifying my dev life by moving Symfony Station to Grav CMS
In this article, Reuben Walker shares details, thoughts, pointers, and how-to on migrating the Symfony Station site to Grav CMS.
Here are a couple of highlights (but you should dig in and read them all):
Grav CMS is PHP-based
No database
Less complex than Drupal
Content creation with Markdown
[Symfony Station]
BigQuery’s Ridiculous Pricing Model Cost Us $10,000 in Just 22 Seconds!!!
I have some (limited) experience with BigQuery, but nothing of any magnitude. I mostly push a small amount of data from some internal LAMP stack dashboards for further processing and analysis.
But this is nuts!
[Medium]
This article details how MySQL is utilized at Uber.
As you can imagine, the setup is quite complex with a service like Uber.
And it extends beyond my current skill set at this point in my developer journey and career.
[Uber Blog]
30 years of MySQL, the database that changed the world
It's mind-boggling that MySQL has been around this long.
The database is everywhere.
Used for hobby projects and enterprise solutions alike, MySQL has become a staple in application and web development
[The A Register]
[Sponsored Ad]
My name is Fred Moskowitz, and I’ve earned the reputation as The Alternative Investment Expert. My journey began in the tech industry, where I spent years unknowingly exposing myself to a massive financial risk—relying solely on a paycheck from my job. Like so many high-level professionals, I was trapped in a single-source income model that left me vulnerable.
That realization set me on a relentless quest to discover, master, and refine the most powerful wealth-building strategies available—ones that generate consistent passive income and cash flow without the headaches of managing rental properties or dealing with repairs.
These strategies are game-changers. They offer a way to create true financial freedom and security—allowing you to build wealth intelligently and strategically. I’d love to share them with you. Click this link to receive my exclusive special report on building sustainable passive income and taking control of your financial future.
Very neat tool, and I'd imagine if you're anything like me, you can never remember these without revisiting them from time to time.
Beginners and seasoned PHP developers alike will appreciate this page and the individualized categories.
[PHP Operators]
4 Database Scaling Strategies You Should Know (Recap)
In my current role, I'm not necessarily working with the magnitude of data that would require database sharding (yet).
Indexing is one (common) practice that I use for less performant queries.
[Level Up Coding]
Stop Cramming Everything into Postgres
This content piece is a commentary on why PostgreSQL isn't always the best choice for everything.
I know that Postgres isn't a one-size-fits-all solution, but a couple of things mentioned here surprised me.
Extensions provide additional functionality but may not support all Postgres features either.
[Hacker News]
Why OFFSET and LIMIT Pagination Breaks at Scale and What to Use Instead
This article shares information on why OFFSET and LIMIT clauses are often less performant as the data grows.
Inspecting and discarding rows to return the next page of data in the pagination can be slow.
Find tips for better pagination here.
[Readyset Weekly]
WooCommerce and WordPress news and updates
Developer advisory: Deprecation of wc_current_theme_is_fse_theme() (May 12th, 2025)
WooCommerce 9.8.5: Dot Release (May 12th, 2025)
WooCommerce 9.9: Pre-release updates (May 12th, 2025)
Developer Advisory: Update locale with checkout field changes (May 13th, 2025)
WooCommerce 9.9 will deliver massive admin performance gains (May 13th, 2025)
Thank you for reading OpenLampTech. I hope you have a great rest of your week.
Take care.
Josh Otwell
Some links may be affiliate links from which I earn a small commission at no additional cost.