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. Dennis2 February 2020 at 14:36

    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. Anonymous4 February 2020 at 08:08

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

      Delete
  2. Zhixiang2 February 2020 at 14:39

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

    ReplyDelete