An Overview of the JOIN Methods in PostgreSQL
In my previous blog, we discussed various ways to select, or scan, data from a single table. But in practical, fetching data from a single table is not enough. It requires selecting data from multiple...
Database Failover for WordPress Websites
Every profitable enterprise requires high availability. Websites & Blogs are no different as even smaller companies and individuals require their sites to stay live to keep their reputation. WordPress is, by far, the most popular...
An Overview of the Various Scan Methods in PostgreSQL
In any of the relational databases engines, it is required to generate a best possible plan which corresponds to the execution of the query with least time and resources. Generally, all databases generate plans in...
Validating Your PostgreSQL Backups on Docker
Backups are the vital and important part of any disaster recovery plan, taking backups of the production database is also a basic and an important part of PostgreSQL administration. However, DBA’s don’t often validate that...
Autonomous by Oracle: The Database That’s Cheaper Than Free
It is a known fact that over 80% of businesses fail within their first five years. Studies have shown that the number one reason for this failure is poor cash flow management. New business owners...
Running a Data Warehouse on PostgreSQL
When you need to implement an analytics system for a company there is often the question of where the data should be stored. There is not always a perfect option for all the requirements and...
Running Big Data Analytics Queries Using SQL and Presto
Presto is an open-source, parallel distributed, SQL engine for big data processing. It was developed from the ground-up by Facebook. The first internal release took place in 2013 and was quite a revolutionary solution for...
Big Data with PostgreSQL and Apache Spark
PostgreSQL is well known as the most advanced opensource database, and it helps you to manage your data no matter how big, small or different the dataset is, so you can use it to manage...
How to Run PHP 5 Applications with MySQL 8.0 on CentOS 7
Despite the fact that PHP 5 has reached end-of-life, there are still legacy applications built on top of it that need to run in production or test environments. If you are installing PHP packages via operating...
Oracle’s Ironclad Autonomous Database
NEWS ALERT: “The Marriott just revealing a massive data breach involving guest reservation database at its Starwood brand. Marriott says it was unauthorized access since 2014. This includes up to 500 million guests... For approximately...
An Introduction to Data Lakes
The increase of unstructured data is a severe challenge to enterprises. Over the past decade, we could observe the rapid growth of data being produced and innovative changes to the way information is processed. With...
Database User Management: Managing Roles for MariaDB
It’s always a headache... you need to add a new user role or change some privileges, and you need to assign it one... by... one. This is a regular duty, especially in large organizations, or...