<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Ashmita Dutta  on Medium]]></title>
        <description><![CDATA[Stories by Ashmita Dutta  on Medium]]></description>
        <link>https://medium.com/@Ashmitawrites?source=rss-3855dab741b4------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*IsGgd4hSwn-dSQqeX-kcJQ.jpeg</url>
            <title>Stories by Ashmita Dutta  on Medium</title>
            <link>https://medium.com/@Ashmitawrites?source=rss-3855dab741b4------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 00:47:21 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@Ashmitawrites/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Ready to Move JSON Data In and Out of Your Relational Databases? Call Gilhari!]]></title>
            <link>https://medium.com/@Ashmitawrites/ready-to-move-json-data-in-and-out-of-your-relational-databases-call-gilhari-0510f294c523?source=rss-3855dab741b4------2</link>
            <guid isPermaLink="false">https://medium.com/p/0510f294c523</guid>
            <category><![CDATA[api]]></category>
            <category><![CDATA[cloud-computing]]></category>
            <category><![CDATA[docker]]></category>
            <category><![CDATA[relational-databases]]></category>
            <category><![CDATA[web-development]]></category>
            <dc:creator><![CDATA[Ashmita Dutta ]]></dc:creator>
            <pubDate>Fri, 26 Jul 2024 09:48:13 GMT</pubDate>
            <atom:updated>2024-07-26T10:46:10.342Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Introduction</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/477/0*NzL4_ymAkUstw56c" /></figure><p>In the fast-paced world of software development, efficiency and productivity are paramount. Developers are constantly seeking tools that streamline their workflows and simplify complex tasks. Consider the task of backing up large databases, or seamlessly transferring data between databases of two merging companies. These tasks often involve complex challenges, such as data integrity, performance optimization, and schema compatibility. Enter Gilhari, a powerful microservice framework designed to significantly enhance developer productivity by simplifying the transfer of JSON data between an application and a relational database and even between relational databases. In this article, we’ll explore how Gilhari can transform your data integration processes, focusing on a real-world project that involves transferring data from MySQL to PostgreSQL on AWS.</p><p>The GitHub repository of the project used can be found here : <a href="https://github.com/sidmlq/LibrarySystem_Transfer_bw_RDBMS_Using_Gilhari_on_AWS"><strong>LMS on AWS (using Gilhari to transfer JSON data)</strong></a></p><blockquote><strong><em>Part 1: Boosting Productivity on Your Local Machine</em></strong></blockquote><p>This project simulates a library management system to demonstrate a practical use-case of the Gilhari microservice framework. The project aims to transfer JSON data from a MySQL database to a PostgreSQL database on cloud, using AWS.</p><p>• <strong>Setup and Configuration:</strong> Gilhari Microservice Framework is a product of Software Tree. You may get the download instructions for the Gilhari Software Development Kit (SDK) from Software Tree’s web site at <a href="https://www.softwaretree.com/"><strong>https://www.softwaretree.com</strong></a><strong>.</strong></p><p>The microservice is installed, using Docker for lightweight containerization and ease of management.</p><p>• <strong>Database Preparation:</strong> MySQL and PostgreSQL AWS RDS instances are prepared to serve as the RDBMS. The MySQL database tables are populated with data using a driver program. The microservice will then be configured to connect to these databases, for all operations.</p><p>• <strong>API Implementation: </strong>The GET API will process retrieving JSON data from the source database. The POST API will identify and remove records based on specified criteria, ensuring efficient data management.</p><p>• <strong>Deployment: </strong>The project will be deployed on AWS, utilizing AWS Elastic Container Registry for robust and scalable deployment using Docker.</p><p>This project not only showcases the capabilities of the Gilhari microservice framework but also provides a practical example of its application in real-world scenarios, demonstrating efficient data management and robust API functionality. Moreover, Gilhari is very easy to configure and use.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*8s0GKKdIqADFYHMn" /></figure><p><em>Figure: High-level architecture diagram of the project</em></p><p><strong><em>Transferring JSON Data</em></strong></p><p>With the configuration set, you can transfer JSON data seamlessly using Gilhari. The framework’s intuitive interface allows for data transfer with simple commands, minimizing the need for complex programming.</p><p><strong><em>Productivity Gains</em></strong></p><ul><li><strong>Ease of Use:</strong> Gilhari uses a developer-friendly REST (REpresentational State Transfer) interface to provide APIs (GET, POST, PUT, DELETE,…) for CRUD (Create, Retrieve, Update, and Delete) operations on JSON objects, eliminating the need for extensive coding.</li><li><strong>Flexibility:</strong> Switching between databases is as simple as changing the JDBC driver and connection information.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/905/0*kyYn6oS_Z0Kyr9yv" /></figure><p><strong>Explanation:</strong></p><ul><li>The <strong>REST Client</strong> communicates with <strong>Gilhari</strong> via standard RESTful APIs.</li><li><strong>Gilhari</strong> handles the conversion of JSON data into a format suitable for the <strong>RDBMS</strong> and vice versa.</li><li>The <strong>RDBMS</strong> stores and manages the data, ensuring persistence and integrity.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*3TUqF8EcYq26kZ-V" /></figure><p><em>Figure: Local implementation of Gilhari based application</em></p><p>Left-side terminal window refers to the first Gilhari instance connected to the source database, while the right-side terminal window refers to the second Gilhari instance that is connected to the target database. The smaller terminal window on the right-side runs cURL commands to transfer data from the source to target databases. SQL statements as translated and executed by Gilhari from the REST API calls made are visible.</p><p>As an example, refer to the following GitHub repository: <a href="https://github.com/sidmlq/LMS_Transfer_between_RDBMS_using_Gilhari"><strong>LMS using Gilhari to Transferring JSON data</strong></a></p><blockquote><strong><em>Part 2: Porting to the Cloud with AWS</em></strong></blockquote><p>Transitioning your local solution to a cloud environment like AWS is a breeze with Gilhari. This section guides you through the minimal steps required to move your data transfer solution to AWS, showcasing Gilhari’s ability to enhance developer productivity by simplifying cloud deployment.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/343/0*1v2ljmS8bMkIkzwy" /></figure><p><strong>Setting Up on AWS</strong></p><p><strong>1. Create your database instances on AWS RDS.</strong> Use the endpoint URL and the username password credentials in the JDX file. Note that you might need to add the required inbound rules for the database server in your security group associated with the VPC of your RDS instance.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/969/0*jyAfEJTgGjo5pLcT" /></figure><p>2.<strong> Launch an EC2 instance:</strong> You’ll be using this EC2 instance as your virtual machine to host your application. Connect to the instance (it is recommended to use PuTTY client for Windows). Install Docker on the virtual machine.</p><p>3.<strong> Using Docker:</strong> Build your docker image and push to a repository on ECR. .</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/956/0*OPil1r23Swe1wDXo" /></figure><p><strong>4. Run Your Task on EC2:</strong> Run the docker images on the virtual machine and you have Gilhari listening on a port of the IP of the EC2 instance.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/964/0*_p6Fb2li2HQdUjDE" /></figure><p><strong>A Flask-based web application was written in Python to integrate the running of the application as a GUI webpage, here’s a sneak peak at the website:</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*g6miHK0O3ynfD18O" /></figure><p><strong><em>Productivity Gains</em></strong></p><ul><li><strong>Cloud Portability:</strong> Easily move your solution between different cloud providers.</li><li><strong>Scalability:</strong> Utilize Docker or Kubernetes to scale your Gilhari instances dynamically.</li></ul><p>Gilhari leverages OOP principles to create modular, reusable code. Each database interaction is encapsulated within objects, allowing for cleaner, more maintainable code. This encapsulation also makes it easier to extend Gilhari to support additional RDBMSs.</p><p><strong><em>Switching Between Databases with Ease</em></strong></p><p>Gilhari’s design enables seamless switching between different relational databases. Simply update the JDBC driver and connection details, and you’re good to go. This flexibility allows developers to work with multiple database types without extensive reconfiguration.</p><p><strong><em>Minimal Programming Effort</em></strong></p><p>Gilhari stands out by requiring minimal coding. There’s no need to write complex REST interfaces or data integration logic. Gilhari handles it all, freeing developers to focus on other critical tasks.</p><h4><strong>Unlock the Dataverse: Gilhari-Powered Data Integration for Modern Apps</strong></h4><ul><li>Microservices Made Easy: Build flexible microservices for data integration without complexity.</li><li>Seamless SaaS Integration: Effortlessly create data pipelines from JSON-exporting SaaS sources to JDBC databases/warehouses.</li><li>Simplified Data Retrieval: Easily fetch JSON data from any JDBC database for further processing.</li><li>Mobile-Friendly Data Exchange: Enable seamless JSON data exchange between mobile clients and remote relational databases.</li><li>Leverage Existing Schemas: Utilize existing database schema and data, eliminating reliance on non-standard JSON data types..</li><li>Faster Cloud Service Rollout: Accelerate the launch of new cloud services with streamlined data integration.</li></ul><h4><strong><em>Conclusion</em></strong></h4><p>Gilhari simplifies the process of moving JSON data in and out of relational databases, offering a developer-friendly solution with minimal configuration and coding requirements. Its flexibility and scalability make it an ideal choice for both local and cloud-based environments. Start using Gilhari today and experience the ease of seamless data integration!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*41kIXvQrym5T5LqmOOK5Hg.png" /><figcaption>Courtesy: Visual Electric</figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0510f294c523" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>