This blog post talks about one of the important MySQL configuration, sql_generate_invisible_primary_key, available in MySQL 8.0.30. This will save you from performance bottlenecks due to tables without Primary Key. If…
The post How to get MySQL Primary Keys in one minute first appeared on Change Is Inevitable.
Freelance web developer Phil Kurth shares a fantastic developer interview with the OpenLampTech newsletter readers.
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Phil Kurth works with a wide range of clients and builds WordPress plugin extensions for the ever-popular Advanced Custom Fields plugin.
Phil has a lot of knowledge, insight, and experience in the web development industry so I’m very excited he agreed to share this information (and more) with the OpenLampTech newsletter readers.
And now without any further ado, on to the interview.
…[Read more]Last week, from November 21 to 24, the DOAG Conference took place in Nuremberg, Germany.
The MySQL Team was present at the Oracle booth. I attended the conference Thursday and Friday.
There were 20 sessions tagged “MySQL” and one full day workshop dedicated to students. I delivered the first part of the workshop dedicated to MySQL for Developers, DBAs and Ops. My colleague Carsten who attended the full week, delivered the second part of the workshop dedicated to the MySQL offer in OCI: MySQL HeatWave and LakeHouse.
The first day was a special “theme” day about Open Source Databases and other topics. Colin Charles talked about MySQL Security, Raphael Salguero presented the differences between Oracle Database, PostgreSQL and MySQL.
There were also presentations about MySQL Clustering and HA from Matthias Jung and future …
[Read more]MySQL Invisible Columns | Lightweight Linux distros | 10 PHP libraries for 2023 | New WooCommerce install default blocks. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Thank you for reading OpenLampTech. If you are not yet subscribed, be sure and grab a free subscription today.
Thank you for reading this post. Please share it with someone else who would enjoy it as well.
…
[Read more]A few days ago, Oracle released three new MySQL GA versions: 8.2.0, 8.0.35 and 5.7.44. I skimmed the release notes (8.2.0, 8.0.35 and 5.7.44), and I am not impressed. I guess that I would be even less impressed / more disappointed if I had checked in greater detail, and if I had reviewed the 8.1.0, 8.0.34 and 5.7.43 release notes. The subject of my disappointment is Oracle not fixing bugs in
PHP developer and Laravel content creator Marian Pop shares a fantastic developer interview with the OpenLampTech newsletter readers.
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Welcome to this OpenLampTech text-based developer interview.
PHP developer Marian Pop is very active in the Laravel community.
Marian writes a daily blog, and a newsletter, and has a podcast – all covering Laravel.
Subscribe to OpenLampTech to read this interview and more.
…[Read more]SQL Upserts | WordPress nonces | WordPress CLI | Microservices with PHP | Laravel vs Symfony. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.
Custom WooCommerce and Shopify Solutions
Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Thanks for your interest in the OpenLampTech newsletter. …
[Read more]We will walk you through the process of connecting to SQL Server using Devart SDAC, including installation and examples of how to interact with the components.
The post How to Connect to SQL Server in Delphi with Devart SDAC appeared first on Devart Blog.
Long-time WordPress and Vue.js software engineer Przemysław Hernik shares a fantastic developer interview with the OpenLampTech readers.
Custom WooCommerce and Shopify Solutions
Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Be sure you’re subscribed to the OpenLampTech newsletter so you …
[Read more]We’ve seen in previous articles what Transparent Read/Write Splitting is with MySQL 8.2 and how to use it with MySQL Connector/Python.
I love this new feature, but I was wondering if it was really worth it.
Will the application benefit from offloading reads to another node, and won’t using the MySQL Router and parsing the request slow down connections?
These are the kinds of questions I’d like to cover and answer in this article.
The environment
To perform the test, I use the following environment:
