How to create time-in-time architecture in MySQL

Question

I read this article on creating a temporary architecture for your database. It looks like an elegant solution, but the article has long appeared (2007). I thought: 1. Are there any other ways to solve this problem? 2. What are these pros and cons of this and other methods? 3. Is the mysql implementation available for these methods that I can reuse?

Answer 1

I just looked through the article, but it seems the author is inventing a two-time database wheel. I'm not sure that he did this well, but I did not read it carefully.

Before delving into this, you need to spend some time filming Richard Snodgrass's book, "Developing Temporary Database Applications in SQL". It is available as a PDF from its web page .

I think that MySQL lacks support for CHECK restrictions and the unique implementation of GROUP BY will greatly complicate its approach. If you have the freedom to choose, PostgreSQL may be the best platform for this.