Java/JVM

Sharding: Distributing Data Across Multiple Machines with Spring Boot and MongoDB

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...

by Vikash Rai
Tag: Database
25-Sep-2024

Database Administration

Redshift IdP Authentication Setup using Azure Active Directory

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...

by Patel Akshaykumar
Tag: Database
23-Aug-2024

AWS, DevOps

Cassandra Migration from Opsworks to AWS SSM Application Manager

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...

by Akhilesh Rana
Tag: Database
22-Mar-2024

Big Data, Data & Analytics

Getting the Best Out of PostgreSQL

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,...

by Prashant Singhal
Tag: Database
07-Mar-2024

Android, Mobility

Offline Data Transfer in Android

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...

by Shalini Prajesh
Tag: Database
23-Aug-2017

Grails, Java/JVM

SQL Wildcards..is Your Application Safe?

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...

by Sachin Gulati
Tag: Database
18-May-2017

DevOps, Technology

How to Set up PhpPgAdmin for PostgreSQL?

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,...

by Anup Yadav
Tag: Database
23-Feb-2017

DevOps, Technology

Introduction to LDAP Server – OpenDJ 3.0

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...

by Mayank Negi
Tag: Database
23-Feb-2017

Technology

How to Reduce the Number of Druid Segments?

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...

by Aseem Bansal
Tag: Database
15-Dec-2016

Technology

The Most Awaited Feature “SQL Joins” is Now Available in MongoDB 3.2

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...

by Pawan Kumar Goyal
Tag: Database
17-Nov-2016

AWS, DevOps

Leveraging AWS Data Pipeline To Easily Move Relational Data Between AWS, On-Premise Or Other Services

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....

by Aakash Agarwal
Tag: Database
30-Sep-2016

AWS, DevOps

Database Migration using AWS Database Migration Service (DMS)

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...

by Shivam Agrawal
Tag: Database
29-Aug-2016