MyWebSQL is an open source web-based client used for managing databases. It is designed with simple interface and supports all major web browsers like Chrome, Firefox, Opera and Safari. It allows the users to create and edit the table structure without writing queries. Installation of MyWebSQL in CentOS is explained in this article.Installation of MyWebSQL
Before installing MyWebSQL, you need to install LAMP server with the following link.
Download the MyWebSQL installation package.[root@linuxhelp Desktop]# wget [...]
PostgreSQL is an open source relational database management system (DBMS). It can manage workloads of large internet facing applications with several concurrent users. It is mainly used for secure data storage. The postgreSQL supports transactions, subselects, triggers, views and sophisticated locking. Installation of PostgreSQL in FreeBSD is explained in this article.Installation of PostgreSQL
Before installing the PostgreSQL, run the following command to update the mirrors.root@linuxhelp:~ # freebsd-update fetch Looking up update.FreeBSD.org mirrors... 4 mirrors found. Fetching public key from update5.freebsd.org... done. Fetching [...]
LEMP is a group of software, which is used to serve dynamic web pages and web applications. The acronym of LEMP describes a Linux operating system, Nginx as web server, MySQL for backend data storage and the dynamic processing is handled by PHP. Installation of LEMP in Ubuntu is explained in this article.To install the Nginx
Run the below command to install the Nginx.root@linuxhelp1:~# apt-get install nginx -y Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: nginx-common nginx-core Suggested packages: fcgiwrap nginx-doc The [...]
PostgreSQL is a powerful high-performance, object-relational database management system (ORDBMS). It is well suited for large databases and has a quite large advanced features. It supports many OS that includes Linux, FreeBSD, Solaris and Microsoft Windows.
PhpPgAdmin is a PHP-based web application, used for managing PostgreSQL databases. It is easy to create a database, create a role and create tables in Postgres.
In this tutorial will learn how to install PostgreSQL and phpPgAdmin in Ubuntu.To install PostgreSQL, phpPgAdmin and Apache2
PostgreSQL and PhpPgAdmin are available in the Ubuntu repository, just [...]
RockMongo is a MongoDB administration tool using which you can manage your server, collections, indexes, databases, documents etc. It provides a user-friendly way for reading, writing, and creating documents. Installation of RockMongo in CentOS is explained in this manual. FeaturesOpen source under New BSD License Contains easy installation. I18N Installation of RockMongo
Verify the MongoDB service status.[root@linuxhelp ~]# systemctl status mongod.service mongod.service - SYSV: Mongo is a scalable, document-oriented database. Loaded: loaded (/etc/rc.d/init.d/mongod) Active: active (running) since Thu 2016-10-13 13:42:41 IST; [...]
Apache Cassandra is a NoSQL database designed for storing large amounts of data. In this each node acts a cluster. NoSQL refers to a database with a data model other than the tabular relations used in relational databases such as MySQL, PostgreSQL, and Microsoft SQL. The Apache Cassandra database is the right choice when you need scalability and high availability without compromising performance.Installation of Oracle JDK
Utilize the following command to install Oracle JDK.root@linuxhelp:~# add-apt-repository -y ppa:webupd8team/java gpg: keyring `/tmp/tmpyjqbv0pc/secring.gpg' created gpg: keyring `/tmp/tmpyjqbv0pc/pubring.gpg' [...]
MongoDB is an open-source, cross-platform, document-oriented database which stores data in JSON-like documents. The main features of MongoDB are Ahoc queries, indexing, load balancing and file storage. It is the fourth popular database system. Installation of MongoDb in CentOS is explained in this article.To install MongoDB
Create a repository for the mongodb[root@linuxhelp1 ~]# cd /etc/yum.repos.d/ [root@linuxhelp1 yum.repos.d]# vi mongodb.repo [mongodb] name=MongoDB 3.2 [...]
In this article we will learn the steps to be followed to configure OrientDB in Ubuntu.
Note: If the orientdb server is running stop it by pressing CTRL+C before configuring. To configure OrientDB we are going to modify two configuration file /opt/orientdb/bin/orientdb.sh and /opt/orientdb/config/orientdb-server-config.xmlTo add user for OrientDB
Let us add a user for OrientDB by running the following command.root@linuxhelp:~# useradd -r orientdb -s /bin/false
Set the user and group ownership for the OrientDB installation directory as orientdbroot@linuxhelp:~# chown -R orientdb:orientdb /opt/orientdb
Now let’s [...]
OrientDB is a multi-platform, multi-model NoSQL database for managing databases. This is completely based on java programming language. Installation of OrientDB is explained in this manual.Installation of JAVA
Start adding the repository that are required for the installation of OrientDB.root@linuxhelp:~# add-apt-repository ppa:webupd8team/java Oracle Java (JDK) Installer (automatically downloads and installs Oracle JDK7 / JDK8 / JDK9). There are no actual Java files in this PPA. More info (and Ubuntu installation instructions): - for Oracle Java 7: http://www.webupd8.org/2012/01/install-oracle-java-jdk-7-in-ubuntu-via.html - for [...]
Chive is a free, fast, user friendly applet for controlling MySQL Database. It is programmed in PHP language and has a graphical front end tool for analyzing the available database. Installation of Chive in Ubuntu is explained in this manual.To install Chive
Utilize the following command to update the system repositories.root@linuxhelp:~# apt-get update Hit http://security.ubuntu.com wily-security InRelease Hit http://security.ubuntu.com wily-security/main Sources Hit http://security.ubuntu.com wily-security/restricted Sources Hit http://security.ubuntu.com wily-security/universe Sources Hit [...]