Navicat Blog

Aug 10, 2018 by Robert Gravelle

The term "NoSQL" actually encompasses a wide variety of different database technologies that were developed in response to the demands dictated by modern applications and Internet of Things (IoT) devices. The massive volumes of new, rapidly changing data types created by the linking of numerous systems and devices have presented challenges for traditional DBMSes:

Jul 31, 2018 by Robert Gravelle

MongoDB is a different kind of database. Unlike traditional relational databases like SQL Server and MySQL, it stores data as JSON-like documents. While MongoDB's NoSQL approach does yield some advantages over its RDBMS competitors, it also makes it harder for makers of third-party database management tools to integrate support for MongoDB within their products, leaving users few options besides MongoDB's own Compass UI tool.

Jul 24, 2018 by Robert Gravelle

A database event is a task that runs according to a schedule. Also known as "scheduled events", an event is similar to a cron job in UNIX or a task scheduler task in Windows, except that scheduled events are configured using a database's syntax and/or command-line-interface (CLI). Database events have many uses, such as optimizing database tables, cleaning up logs, archiving data, or generating complex reports during off-peak time.

Jul 17, 2018 by Robert Gravelle

Since version 5.1.6, MySQL has supported events. They employ a natural language scheduling syntax, so that you can say: "I want the MySQL server to execute this SQL statement every day at 11:30am, until the end of the year". To help you write your event statements, MySQL provides excellent documentation on CREATE EVENT syntax. Despite all of this, getting a firm grasp of event scheduling can still take some trial and error.

Jul 10, 2018 by Robert Gravelle

Welcome to the third installment in our series on Database Events! Part 1 outlined the difference between Database Events and Scheduled Tasks, as well as how to configure the Event Scheduler Thread in MySQL. In Part 2, we explored how to create MySQL events using the CREATE EVENT statement. Today's blog will delve deeper into how to schedule MySQL 8 Events - an essential topic that only received a cursory mention last time.

Navicat Blogs
Feed Entries
Blog Archives