1 Feb 2020

How to Make MySQL Cool Again v3.0


  • In-built columnar storage engine that works next to Innodb on the same DB server.
  • Materialized views - async and semi-immediate
  • Recommended indexes based on query usage
  • Rename CREATE PROCEDURE to CREATE DATABASE API. Yes, really.. just rename it.

3 comments:

  1. I think if MySQL could develop a better geospatial extension it will be a good start. One of the way PostgreSQL is leading the field is being able to manage data as an object oriented database system.

    ReplyDelete
    Replies
    1. https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html

      Delete
  2. why rename stored proc to create database? point 1, greenplum already has it; 2 & 3: what does it mean? :-)

    ReplyDelete