Learn how to configure the inline size of BLOB columns of NDB tables through SQL and see how can it improve the application.

There is so much content online these days about any niche. But, if you want to know what’s happening in the PHP, MySQL, and LAMP stack landscapes, then OpenLampTech has you covered. Thanks for reading!

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

[#Affiliate]

LoopGenius helps you find customers, spread the word about your side hustle, and turn your idea into a website. Use Coupon Code: KZGZ3WSP when you sign-up today and get 10% off!

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL …

My students wanted an illustration of where MySQL Workbench fits within the MySQL database. So, I overlaid it in this drawing from my old book on comparative SQL syntax for Oracle and MySQL. Anybody else have a cool alternative illustration?

The idea is the lightening bolt transmits an interactive call and reading a script file submits a call paradigm.

As always, I hope this helps those looking to understand things.

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.42 (release notes, download) and MySQL-wsrep 8.0.33 (release notes, download), with Galera replication library 4.15 (release notes, download) implementing wsrep API version …

Yesterday, I published an article explaining how to easily deploy Apache Superset on OCI using MySQL HeatWave Database Service.

There are some people not using the automation or not using MySQL HeatWave Database Service on OCI but want to still use Superset with MySQL 8.0.

In this blog, we will see how to fix eventual errors when performing the installation manually.

SQL Alchemy Dialect Configuration

When using MySQL 8.0, in Superset’s config file, you need to specify the SQLAlchemy URI like this:

SQLALCHEMY_DATABASE_URI = 'mysql+mysqlconnector://<user>:<password>@<host>:<port>/<superset_schema>'

It is important to specify the database backend and dialect: mysql+mysqlconnector.

Of course you need to install the MySQL …

Here’s a quick catalog for my students of PowerShell, JavaScript, and Python examples connecting to MySQL:

• MySQL Powershell Connection with .Net Library Example
• MySQL Powershell Connection with ODBC DSN Example
• MySQL Powershell with CSV File Write Example
• MySQL Powershell with Dialog for Dynamic Connection Inputs
• MySQL Node.js Introduction without Bind …

Apache Superset is an open source BI, Reporting, Charting tool that competes with Tableau, Looker, etc.  For a list of companies that have deployed Superset, see:  https://github.com/apache/superset/blob/master/RESOURCES/INTHEWILD.md. Superset is loaded with options that make it easy for users of all skill sets to explore and visualize their data, from simple line charts to highly detailed geospatial […]

We already saw how to deploy Apache Superset with MySQL HeatWave.

I just released a new version of the Terraform modules including some configuration parameters for a future development related to High Availability.

So let’s see the easiest way to deploy Superset on OCI using MySQL HeatWave.

Quick Deployment

The default deployment is the following:

The fastest and easiest way to deploy such architecture is to click on the button below:

When you click on the button, you will reach the following screen if you are …

How to deploy Apache Superset with MySQL HeatWave and how to benefit from HeatWave's query accelerator.

Overview Modern cloud applications (like microservice or serverless apps) are distributed systems composed of many interconnected services and service instances. Without observability in place, it is often difficult to troubleshoot issues within such complex systems. The OCI Application Performance Monitoring (APM) service provides observability for end-to-end visibility and diagnosis across the entire IT environment. Using distributed transaction […]