Imagine your coffee shop is thriving, but one location can't keep up with the growing demand. To fix this, you open more shops across the city, easing the load. Sharding works similarly for databases. When one MongoDB server can't handle the volume, data is distributed across multiple machines (shards), making your system more...
Introduction Recently, we helped a large enterprise customer set up their data warehouse on Amazon Redshift using Azure AD for corporate credentials. This allowed users to log in with their corporate credentials, improving user experience and simplifying maintenance. We achieved this by setting up Azure AD federated access to Amazon...
Introduction AWS OpsWorks is a robust configuration management service designed to simplify infrastructure and application management. It automates tasks, streamlines operations, and ensures application reliability by simplifying the provisioning and configuration of resources like Amazon EC2 instances and databases. OpsWorks offers...
Ensuring everything runs smoothly in handling databases is like an ongoing adventure for folks working with data. PostgreSQL, a widely used and powerful open-source database system, is a go-to choice for many applications. But even in the land of PostgreSQL, making it work at its best isn’t always straightforward. In this journey,...
Offline data transfer in Android is a way to transfer data among devices wirelessly without any network accessibility. There are many ways for connecting devices sans cables such as Bluetooth, NFC, Wifi Direct, SIP, etc. Despite the fact that a large audience is looking towards internet solutions, these ways have their unique use cases...
We all have search functionality in our applications. It is one of the most core features you would find ranging from searching for users, products, companies, etc. But are you sure your search functionality is doing exactly what it is supposed to do? You might have written test cases for it as well. But still, there are things...
PostgreSQL is a powerful, open source object-relational database system (ORDBMS). The version 8.0 and above also comes with the native Windows compatibility. Compared to other RDBMSs, PostgreSQL differs itself with its object-oriented and/or relational database functionality, such as the complete support for reliable transactions,...
OpenDJ is a directory server which implements a wide range of Lightweight Directory Access Protocols (LDAP). OpenDJ is written in Java language. It was an internal project started by Sun Microsystems, which is now maintained by Forgerock. Steps to set-up OpenDJ LDAP Server: Register to www.forgerock.com and download the .zip or...
We have been using Druid in our project for a while and had shared our experiences during GIDS. It has given us great results as it powers our real-time dashboards, reports on running Ad campaigns and provides real-time data to make quick decisions. But like any other databases there will be times when it needs to be optimized. This is...
SQL Joins are used to combine documents/rows from 2 or more tables based upon common field present in them. MongoDB 3.2 launched the most awaited feature "Joins" which is supported in SQL database however was not present in the earlier version of MongoDB. This feature will change the way you design your database schema and application...
In today's time of data-oriented applications, there is a constant change and challenge in requirements of data onboarding from and to varied sources. You may find yourself stuck between traditional and time-consuming methodologies of data migration. These may incur unnecessary costs and other overheads, eventually affecting the delivery....
AWS DMS is a web service that is used to migrate the databases to and from an Amazon RDS DB instance, or a database on an Amazon EC2 instance, or on-premises. We can migrate data between homogenous or heterogeneous database engines. One of the two endpoints must always be in AWS. The source and target database may be in same VPC or in...