Tag - Virtual columns

Using ProxySQL and VIRTUAL Columns to Solve ORM Issues

implement ProxySQL with AWS Aurora

In this blog post, we’ll look at using ProxySQL and VIRTUAL columns to solve object-relational mapping (ORM) issues.
There are a lot of web frameworks all around. Programmers and web designers are using them to develop and deploy any website and web application. Just to cite some of the most famous names: Drupal, Ruby on […]

Read more

Using MySQL 5.7 Generated Columns to Increase Query Performance

MySQL Generated Columns

In this blog post, we’ll look at ways you can use MySQL 5.7 generated columns (or virtual columns) to improve query performance.
Introduction
About two years ago I published a blog post about Generated (Virtual) Columns in MySQL 5.7. Since then, it’s been one of my favorite features in the MySQL 5.7 release. The reason is simple: […]

Read more

Webinar Thursday, December 8: Virtual Columns in MySQL and MariaDB

Virtual Columns

Please join Federico Razzoli, Consultant at Percona, on Thursday, December 8, 2016, at 8 AM PT / 11 AM ET (UTC – 8) as he presents Virtual Columns in MySQL and MariaDB.
MariaDB 5.2 and MySQL 5.7 introduced virtual columns, with different implementations.Their features and limitations are similar, but not identical. The main difference is […]

Read more

Generated (Virtual) Columns in MySQL 5.7 (labs)

About 2 weeks ago Oracle published the MySQL 5.7.7-labs-json version which includes a very interesting feature called “Generated columns” (also know as Virtual or Computed columns). MariaDB has a similar feature as well: Virtual (Computed) Columns.
The idea is very simple: if we store a column

MySQL

`FlightDate` date

1

`FlightDate` date

in our table we may want to filter or group […]

Read more