Learnings in IT

Executive Summary and key Constraints In enterprise, there are applications with specific high availability requirements.

Introduction Nowadays, much of the online commentary related to Generative AI is focussed on Automated code Generation and rightly so.

Introduction This article explores various ways in which Dapr helps with development and operations of distributed applications.

Introduction This article compiles my notes on an excellent architectural deep-dive by Jeffrey Richter.

Introduction Good software architecture is crucial for a business to reach its goals.

Introduction A Software Bill of Materials (SBOM) is a list of all the components, libraries, and modules that make up a software, providing transparency into its composition.

Introduction In the ever-evolving landscape of AI and machine learning, Google’s MCP Toolbox for Databases stands out.

Background There was a requirement to perform series of tasks, involving generation of output files, such that the required throughput is achieved.

Location Mumbai, Maharashtra, India Professional Title Senior Technical Architect at Worldline India What do you do ?

Introduction Artificial Intelligence, especially Large language models (LLMs) are all in high demand.

Java Language Articles, E-books Getting Started with Java in 2023 Finding Java Thread Leaks With JDK Flight Recorder and a Bit Of SQL

Background Ever encountered a scenario where REST API consumption works from tools like curl, Web Browser but not from Application.

Background A Client has E-commerce Application consisting of services aimed at specific domains of business functionality it serves.

PostgreSQL General Articles Mistakes to avoid while using PostgreSQL The Part of PostgreSQL We Hate the Most We are sticking with postgresql Free Postgres database (or SQLite) from fly.io Using generate_series feature for reporting When Postgres blocks: 7…

Introduction While embarking on building any new server application, one of the key requirement is whether it needs durable, persistent storage of data (and in most cases, it does).

Introduction We develop a piece of software with aim to fulfil specific business requirements in terms of resource usage, throughput, availability among others.

Introduction I have been reading excellent Database Reliability Engineering book and below are my notes from it.

Introduction Suppose you have a distributed application running in production and it is based on Micro services/Service Oriented Architecture and have SLA of being “always on” (be available 24*7, barring deployments of course !!).

Introduction One of the design considerations stressed upon by Jeffrey richter about APIs (Read more here) is that “API is expected to be stable over long period of time”.

Introduction In a company/enterprise, typically there are multiple sources of data.

Introduction While gathering data for Analytics, one often has to source data from multiple sources.

Background Recently, i went through excellent video series on Designing & Versioning HTTP_REST APIs presented by Jeffrey Richter.

Background In a typical workflow of software development, Developer implements a Unit/component, tests it and pushes the changes to source control repository.

Background In a typical business Application, there are often requirements for, Batch processing - Often long running Tasks like data import/export, End of day processing etc.

Background How many times have we landed up in a meeting staring at random slowness or such production issues in a distributed Application ?

Background I primarily work on Windows for development purposes.

Background I started this blog, https://sachinsu.github.io few months back .

Background I recently had opportunity to support team who has been battling with Intermittent (scary i know :)) issues with TCP connectivity in Production.

Background I recently came across bounty by Balaji Srinivasan to send Direct Message to all twitter followers.

Section covering resources for Online learning etc.

Python has become pervasive all throught Data Science be it Machine learning, Deep learning, Data Processing and general purpose tasks like Web Development.

At my current workplace, All Applications are expected to adhere to PCI DSS standards meant for Data protection, Access Regulation and so on.

Over the last many years, de-facto language of the Web (specifically front-end) has been Javascript (and variants like Typescript, ECMAScript versions and so on).

Background The source code of tracfee.com is hosted on Github Private.

Useful links related from Generative AI, ML space Collections Gen AI- Collection of Articles on AI Code Generation and its pros and cons AI Guide by Mozilla Collection of resources related to Applied ML List of for MLOps Prompt Engineering Playbook for Pr…

Useful links for deep diving in various Cloud Ecosystems Articles Cost of Cloud - Paradox Cloud vs.

User Interface / User Experience Design Approach Modern Web - Guides, tools and libraries for modern web development.

Background Recently, we had requirement wherein a process should, Periodically (Poll) or Asynchronously (Pub-sub) listen on incoming requests/messages.

Background Oftentimes, we come across situation where code does not perform as per expectation.

Background A Web Application, developed in ASP.NET Core (Runtime Version 3.1.100) using Razor Pages and Web API, is expected to be launched from within third-party Web Application in iframe, with complete HTML being rendered.

General Purpose tools Section covering useful tools for every day activities, Online learning etc.

Perspectives Section covering Business, project/programming perspectives Laws of Frugal Architecture Cognitive load is all that matters Stick to boring Architecture Your tech stack is not the product Architecture anti-patterns Don’t call yourself a progra…

Background Recently, i got involved in assignment where in an application was facing issues with throughput.

Oracle Database Performance, Best Practices Connection Strategies for Database Applications Using High-Speed Data Loading and Rolling Window Operations with Partitioning Designing Applications for Oracle Real-World Performance Best Practices for Extreme P…

NOSQL Databases MongoDB FerretDB - MongoDB Interface with underlying PostgreSQL as database engine Amazon DynamoDB Data Modelling in DynamoDB Must follow Twitter handle of Rick Houlihan Best Practices for Secondary Indexes with DynamoDB Apache Cassandra 7…

MySQL Links Query analytics for the day-to-day developer with MySQL 8.0 Schema Change Management for MySQL Temporal Data tables in MariaDB MySQL 8.0 Indexes, Histograms, and Other Ways to Speed Up Your Queries Maxwell - MySQL to Kafka change data capture…

Database Knowledge base around general database related topics.

Below are some of my project(s), Tracfee, One stop for Tutors to manage students, track fees.

I am a software architect with more than 2 decades of experience, currently working at @worldlineglobal.

Microsoft .NET Platform where i have spent most time till now.