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
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
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
Our guide to MySQL download outlines the downloading and installation processes for both MySQL free download and MySQL 5.7 download for windows PC’s. In this post, our focus will be on the community edition which is the free version and not the paid enterprise edition. You can find the download link here. Here is the... » read more
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
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
There are some functions, statements, and queries that you are bound to run in MySQL as long as you are managing a MySQL database. Two of these are the MySQL show users and the MySQL show all users statements, which to be fair are often common assumptions. For amateur MySQL database users, and those with... » read more
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
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
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