Database – Page 3 – POFTUT

Category: Database

1

How To Install PostgreSQL Server Into Linux, Debian, Ubuntu, CentOS, Mint, Fedora, Redhat?

PostgreSQL is very popular open source database. It is used by big companies like Google, Facebook etc. PostgreSQL can be used without a cost. In this tutorial we will look how to install PostgreSQL into Linux distributions like Debian, Ubuntu, Mint, Fedora, CentOS, RedHat by using different ways like package management or downloading setup file. Show PostgreSQL Package Version For Ubuntu, Debian, Mint, Kali with Apt In apt-get  or apt based...

0

How To Connect MySQL Database From Python Application and Execute Sql Query with Examples

MySQL is very popular and open source database server. Python is old but lately discovered language. In this tutorial we will look how to use this popular techs in our applications in order to run sql queries. Install Python MySQL Connector In order to connect MySQL database from Python application we need some libraries. There are different libraries those supports running sql queries on MySQL but we will stick with...

1

How To Dump Mongodb By Using Mongodump Tool with Examples

Mongodb provides a lot of flexibilities to the application developers and system administrators. As we know mongodb is an nosql database server. Standard Sql database servers provides different tools to dump and backup given database. Mongodb provides mongodump tool for dump and backup operations. Check MongoDB Service Status First we should check the status of the mongodb. We can use systemctl command which is provided by popular Linux distributions.

Dump MongoDb...

0

Redis Cli Tool

Redis have two main usage types. One is using API provided by redis these API’s can be used by different programming languages like Python, Php C#, Java etc. Other way to interact with redis is using cli tool named redis cli. Redis cli provides simple command line interface to test, use, troubleshot redis service. Specify IP Address redis-cli will connect localhost or 127.0.0.1 IP address by default. We can also...

0

Install Redis To Linux, Ubuntu, Debian ,Fedora, CentOS, RedHat

Redis supports different operating system and Linux distributions. We will look how to install and start redis in Linux distributions Ubuntu, Debian, Fedora, CentOS and RedHat in this tutorial. Install Fedora, CentOS, RedHat We can install redis server on Fedora, CentOS and RedHat with the following yum command.

Install Ubuntu, Debian We can install redis server on Fedora, CentOS and RedHat with the following apt command.

Redis Service Status We...

0

Redis Tutorial

Redis is open source BSD licensed database or key-value store. Redis provides fast and simple data store features mainly used for caching purposes in web applications. Redis is written in C programming language. Supported Data Structures Redis supports following data structures to store and retrieve data. string hash list set sorted set queries bitmap hyperloglog geospatial index Supported Operating Systems Current version of redis is 3.2.9 . Redis supports following...

0

Mysql Database Import Tutorial with Examples

Backup and Restore operations are important part of the database administration. mysqlimport command is used to load data in file into Mysql or Mariadb servers. Mysql import is generally used by providing SQLfile. Syntax Syntax of mysqlimport is like below. mysqlimport OPTIONS DBNAME FILE OPTION is used provide detailed configuration DBNAME is the name of the database we want to import FILE is the file which contains the data and schema Import SQL File...

0

Things To Do With Computer When Bored

We work for earn money. We consume our time for money but sometimes we may be bored. Changing current work will made us more happy and will refresh our mind. Here we will provide some useful things to do when we are bored. Consuming time with useful work is important for us. Read Technical Tutorials I think the best way to improve our career is learning new things and implementing...

0

How To Install and Configure MongoDB NoSQL Database To Linux, Ubuntu, Debian, CentOS, Fedora

Sql is very powerful language to query, insert, delete, modify data. Recents years the IT industry have developed some alternative ways to store and retrieve data. NoSQL type database servers become very popular. MongoDb is an NoSQL database server to store and retrieve data. In this tutorial we will look how to install MongoDB on Linux and distributions like Ubuntu, Debian, CentOS, Fedora, RedHat. Fedora, CentOS, RedHat We will use...

0

How To Create Database and Table In MySQL and MariaDB?

MySQL database is very popular database server used by a lot of small and big companies. In this tutorial we will look the basics of MySQL server like creating database and tables, populating data into tables. MySQL installation can be done with the following tutorial for Linux operating systems. How to Install Mariadb/Mysql Server in Linux Fedora? Following operations can be done in MariaDB without any problem. MariaDB is the...

Enjoy this blog? Please spread the word :)