Often for analytical or archival purposes, one would need to move data from PostgreSQL to Amazon Redshift. This post covers the steps you can follow to migrate data from Postgres to Redshift for building a data warehousing solution. Overview of…
Posts published in “Tutorial”
INTRODUCTION TO PostgreSQL PostgreSQL relational database system is a powerful, scalable, and standards-compliant open-source database platform. It offers the standard SQL features as well as some modern ones like triggers, transaction integrity. This tutorial will help you install PostgreSQL on…
Introduction The two major stacks revolving around Javascript are MEAN (MongoDB, Express, Angular & Node) and MERN (MongoDB, Express, React & Node). Both the stacks are well suited for dynamic, extensive applications such as LinkedIn, Netflix, PayPal, etc. Before we…
There are many use cases when you need to migrate data between two MySQL servers, like cloning a database for testing, a separate database for running reports or completely migrating database system to a new server. This tutorial explains steps…
Introduction MongoDB is a free, distributed, and an open-source document database at its core that powers high availability, horizontal scaling, and geographic distribution. It stores data in JSON-like documents and supports Ad hoc queries, indexing, and real-time aggregation. Install MongoDB Step…
You believe your MySQL server is too slow for analytical queries now? or you want to join data from another database while running queries? You have decided to move the data from MySQL to Redshift. The task seems easy enough,…