MySQL is the most popular relational database management system. As an assumption MySQL is used by every third website running on www. MySQL installation on a Linux is very straightforward. You can simply install MySQL on Debian system from its base repositories. But The Debian team replaced MySQL with MariaDB as the default database...
The Debian 8 default repositories contain MySQL packages. You can simply install MySQL on Debian 8 Jessie machine with few simple commands. But the default repositories don’t contain the latest MySQL version. So this tutorial will help to install MySQL on Debian 8 Jessie system with the latest version. Go through the step by...
MySQL is a relational database management system. MySQL is the widely used database server in the world. This tutorial helps you to install MySQL database server on macOS Sierra 10.12 and High Sierra 10.13 and other supported versions using Homebrew. Step 1 – Prerequisites Before starting the installation of MySQL using this tutorial you...
MySQL is an opensource, Relational Database Management System. MySQL is a most popular database server for Linux systems, it also supports a large number of platforms. In MySQL, we can easily create a stored procedure and execute SQL queries. MySQL Community Edition is a freely downloadable version and uses for your applications. In this...
MongoDB is a full flexible index support and rich queries database. It is a NoSQL database. MongoDB provides large media storage with GridFS. Click here for more details about this version of MongoDB. Use this tutorial to install MongoDB server 4.0 on Debian 9 Stretch and Debian 8 Jessie systems. Step 1 – Setup...
MariaDB 10.3 stable version has been released on Oct 09, 2017. It is an enhanced, drop-in replacement for MySQL. MariaDB can be an better choice for choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB has a number of updated features over MySQL. Use below links to read features...
The PostgreSQL Development Team has announced the latest version PostgreSQL 10. PostgreSQL is an open source object-relational database system. It is one of leading database server used for production servers. PostgreSQL allows us to execute stored procedures in various programming languages, like C/C++, Python, Java, Perl, Ruby and its own PL/pgSQL, which is similar...
MySQL is an open-source relational database management system. This tutorial will help you to install MySQL server on your Ubuntu and Debian systems. This version has various security improvements than the previous versions. Step 1 – Configure Apt Repository Download the MySQL apt configuration Debian package officially provided by MySQL team and install it...
MySQL is an Relational Database Management System, widely used as database system for Linux systems. This article will help you to calculate size of tables and database in MySQL or MariaDB servers though sql queries. MySQL stored all the information related to tables in database in information_schema database. We will use information_schema table to...
Rake provides an efficient way for managing database changes. We can easily migrate database changes to servers using command line utility. In this article you will find some quickly uses of rake commands for database migrations. rake db:create This command will take all database configuration from config/database.yml file and create appropriate database of current...