MySQL Workbench Download For Mac
MySQL Workbench Download For Mac

Most DBA’s do not mind working on the command line or shell. But there are database architects, developers and DBA’s who prefer a visual tool. If you are one of them, you will want to use a MySQL workbench download. This unified visual tool allows you to model data, develop SQL and features comprehensive administration... » read more

A Guide To MySQL Date Data Type
A Guide To MySQL Date Data Type

In this guide, we will look at MySQL Date data type and other related MySQL date statements like MySQL curdate. But before we do that, we need to first understand why data types like MySQL date and MySQL curdate statements are important.  Without a proper database management system, handling all the data available in the... » read more

MySQL 8.0 – All The Server Features And Improvements You Need To Know
MySQL 8.0 – All The Server Features And Improvements You Need To Know

The world’s most popular open-source database got an improvement with the announcement of the improved MySQL 8.0 back in late 2016. Any database-driven web applications rely on MySQL to function properly and perform. Some popular applications include WordPress, Joomla, Drupal and our very own, Ottomatik. Also, popular websites including YouTube, Twitter, Facebook, and Flickr are... » read more

Using MySQL On Mac – Install MySQL Mac
Using MySQL On Mac – Install MySQL Mac

The install MySQL Mac process should be a straightforward one but it does not have to have a step-by-step guide. In this post, we will look at the install MySQL mac process and also look at the uninstall MySQL Mac process. Installing MySQL On A Mac Before you do anything else, identify the version of MacOS... » read more

Learn MySQL And MySQL JSON – Step by Step
Learn MySQL And MySQL JSON – Step by Step

What Is MySQL? MySQL is an Oracle-sponsored open-source social database whose execution framework (RDBMS) is built upon Structured Query Language (SQL). MySQL will run on essentially all OS platforms, including Linux, UNIX, macOS, and Windows. Although it tends to be utilized in a wide scope of uses, MySQL is regularly connected with web applications and internet distribution.... » read more

PostgreSQL Backup: Everything You Need to Know

The powerful features associated with PostgreSQL are well-documented. Its extensibility and ability to handle large workloads make it a popular choice as an enterprise-level database platform. However, as you already know, working in a production environment comes with quite a few pitfalls. You need to make sure that your data is safe, and that if... » read more

MongoDB Backup: Everything You Need to Know

Working with non-relational databases like MongoDB feels, in many ways, different from working with traditional structured ones. Instead of a series of interrelated tables, your data is stored in documents. Because of this, instead of the limitations of relational databases, which require building a structure before entering data, with NoSQL databases like MongoDB you gain... » read more

MySQL Binary Logs Backup

Okay, so you’ve gotten used to using mysqldump files for your MySQL databases, but have been concerned about how often you need to run these. Maybe this was fine when you only had a few changes a day, or the work you were doing on your database was not mission-critical. However, now your work has... » read more