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 to Oracle’s PL/SQL This article will help you for installing PostgreSQL...
We are thankful of Mr Ondřej Surý which is maintains PPAs of MySQL servers for Ubuntu systems. This article will help you for installing MySQL 5.7 or 5.6 or 5.5 on Ubuntu 16.04 and 14.04 systems. Ubuntu 16.04 have latest 5.7 in its default repositories. Read this => How to Install PHP 7 on...
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...
PostgreSQL database server provides pg_dump and psql utilities for backup and restore databases. This article will describe various ways to use of pg_dump command to backup database. Also you will learn how to restore datbase backup. Backup and Restore Database in PostgreSQL Below is some connections options which you can use for connecting remote...
ElasticSearch is flexible and powerful open source, distributed real-time search and analytic engine. Using a simple set of APIs, it provides the ability for full-text search. Elastic search is freely available under the Apache 2 license, which provides most flexibility. This article will help you for configuring ElasticSearch Multi Node Cluster on CentOS, RHEL,...
Elasticsearch is flexible and powerful open source, distributed real-time search and analytic engine. Using a simple set of APIs, it provides the ability for full-text search. Elastic search is freely available under the Apache 2 license, which provides most flexibility. This tutorial will help you to setup Elasticsearch single node cluster on CentOS, Red...
Command Syntax: aspnet_regsql.exe -ssadd -sstype p -S {SQL Instance} -U {Username} -P {Password} After installing .Net Framework on your system, open windows command prompt and navigate to framework installation directory as per your installed version of .net framework and system architecture. c:> cd "%windir%Microsoft.NETFramework64v4.0.30319" Directory path may be change as per your installation like...
MariaDB ia an enhanced, drop-in replacement for MySQL. MariaDB can be a 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 comparison between MariaDB and MySQL This article will help you to...
MySQL is the most popular Open Source SQL database management system. It is developed and supported by Oracle Corporation. MySQL is widely use for Linux platform. Now MySQL providers also providing there own apt repository for installing MySQL on Ubuntu and Debian based systems. This article will help you to install MySQL database server...
