Tag: database

Database System: PostgreSQL Replication on Ubuntu 16.04

  PostgreSQL Database System PostgreSQL is an advanced open source Object-Relational Database Management System (or ORDBMS). It is an extensible and highly-scalable database system, meaning that it can handle loads ranging from single machine applications to enterprise web services with many concurrent users. PostgreSQL is transactional …

How to Install Invoice Ninja on Ubuntu 16.04

How to Install Invoice Ninja on Ubuntu 16.04 Invoice Ninja is a web-based open source software for invoicing, payments, time tracking and much more. You can create Invoices online in seconds, interact with payments gateways like Stripe, PayPal, WePay, and others. Invoice Ninja can show you …

How to Install MySQL 5.7 on Linux CentOS and Ubuntu

How to Install MySQL 5.7 on Linux CentOS and Ubuntu MySQL is an open source relational database management system developed by Oracle corporation. The source code is released under GNU General Public License, and for proprietary, there is a paid edition that offers additional functions. MySQL …

NoSQL Databases May Be Your Next Competitive Advantage

NoSQL databases offer improved performance, spur ecommerce innovation, may be less expensive than other options, and could improve management of big data. In short, your ecommerce business’s next competitive advantage could be your database. Competitive advantages are slippery things. For example, a few years ago you …

Install phpMyAdmin on Ubuntu 16.04

  phpMyAdmin is one of the most popular and widely used web-based database management tools. It a free and open source PHP application that allows the users to manage single or multiple SQL database servers locally or on a remote server using a web browser (GUI). …

How to Delete Revisions in WordPress

I regularly copy my live WordPress sites back to my local server. Not only is it an extra backup, but it allows me to develop locally with up to date content. Lately I’ve been getting annoyed at how bloated the WordPress databases seem to get. A …

Install Keepass Password Manager On Ubuntu Linux

Install KeePass password manager on Ubuntu Linux Systems. KeePass is a free open source password manager, which helps you to manage your passwords in a secure way. You can put all your passwords in one database, which is locked with one master key or a key …

How to Install and Configure MongoDB on Ubuntu 16.04

How to Install and Configure MongoDB on Ubuntu 16.04 MongoDB is a NoSQL database that offers a high performance, high availability, and automatic scaling enterprise database. MongoDB is a NoSQL database, so you can’t use SQL (Structured Query Language) to insert and retrieve data, and it …

How to Monitor Docker Containers using Grafana on Ubuntu

Grafana is an open source feature rich metrics dashboard. It is very useful for visualizing large-scale measurement data. It provides a powerful and elegant way to create, share, and explore data and dashboards from your disparate metric databases. It supports a wide variety of graphing options …

How to install X2CRM on an Ubuntu 16.04 VPS

  Today we will show you how to install X2CRM on an Ubuntu 16.04 VPS using Apache web-server and MySQL database. X2CRM is an open source marketing, sales, and customer service CRM application powered by an easy to use workflow engine and process management framework. Manage …

Create a MySQL Database and User through cPanel

  There are different ways to create a MySQL database and user. In one of our previous blog articles about MySQL database administration, we described how to create a new MySQL database and user through the command line which is pretty easy. If you have a …

XWiki Installation in Linux

XWiki Xwiki is an open-source enterprise-ready wiki written in Java, runs on a servlet container like Tomcat, Jboss etc. which uses the relational database to store the information. In this article we will know about how to install Xwiki in Linux using .war file usable for …

Install Open Web Analytics (OWA) on CentOS 7

In today’s article we will install Open Web Analytics (OWA) on a CentOS 7 VPS. Open Web Analytics (OWA) is an open source web analytics software that you can use to track and analyze how people use your websites and applications. It is written in PHP …