Forem: Ujjwal Tyagi

Ship Fast, Fix Smart: Vibe Coding

Ujjwal Tyagi — Wed, 30 Jul 2025 06:32:23 +0000

If you're a developer in 2025 and you're not using AI to code, you're basically choosing to suffer.

I'm not even exaggerating.

As a Senior Software Engineer, I’ve seen a shift in how we build software and one of the biggest mindset changes is what people are now calling “vibe coding”. Not in the lofi music late night hackathon sense but in the AI assisted, intuition driven, let the tool complete your thoughts way.

Let’s talk about what vibe coding means in this new AI era, how it helps, what to watch out for, and how to make the most of it.

🎧 So, What Is Vibe Coding in 2025?

Vibe coding today is when you:

Start typing out a function, and AI completes the rest

Paste an error message into ChatGPT and get an explanation + fix in seconds.

Explore a problem by bouncing ideas with your AI assistant

Let AI "co-pilot" your flow while you focus on structure and direction

It’s not about avoiding hard thinking it’s about offloading the mechanical part of coding so you can focus on design, decision making, and creativity.

You’re still in charg but you’ve got a very fast, sometimes surprisingly smart, assistant riding shotgun.

⚡ How It's Actually Helpful

Here’s why vibe coding with AI has become a superpower:

You Get Unstuck, Fast
That one weird syntax issue? AI solves it in seconds. StackOverflow used to be the go to, now it's autocomplete.
Faster Prototyping
Need to scaffold a new service, write boilerplate, or generate a stub implementation? AI nails it. You save hours.
Mental Bandwidth Saved
You can stay in problem solving mode instead of context switching to Google or docs every 5 minutes.
It’s Like Pair Programming, But Silent
You can throw vague thoughts at AI and get reasonable starting points. It's collaborative, but with no judgment.

☠️ The Dangers You Should Not Ignore

This isn’t a “just vibe it bro” situation. AI can speed you up in the wrong direction if you’re not careful.

Over Reliance = Shallow Understanding
If you're not actively reviewing what AI writes, you risk learning nothing. Worse, you start trusting flawed suggestions blindly.
It Might Look Right, But It’s Wrong
Some of the most dangerous bugs I’ve seen recently? Quietly introduced by confident AI code that looked clean but was logically flawed. Review thoroughly with eyes wide open.
Security & Performance Risks
AI often suggests code that is naive in terms of optimization, and sometimes even exposes subtle vulnerabilities (e.g., improper input sanitization, misuse of concurrency).
Context Limitations
Unless you’re working with tools that deeply understand your full codebase (like Sourcegraph Cody), AI completions can be based on very limited context.

🧠 What Devs & Tech Leaders Are Saying

“The way we write code is fundamentally changing. Vibe coding with AI isn't cheating it's evolution.”
— Amjad Masad, CEO of Replit

“If you’re not 10x faster with AI in your editor, you’re using it wrong.”
— Swyx (Shawn Wang), ex-AWS, Latent Space Podcast

“AI code completion is the new default. It’s up to you to steer it wisely.”
— Guillermo Rauch, Vercel

Even Mark Zuckerberg mentioned vibe coding usage in interviews.
Among my own peers, I’ve seen the shift juniors asking better questions because they have AI to help refine their ideas; seniors shipping more because they delegate grunt work to AI.

✅ TL;DR — Vibe Responsibly

AI-assisted vibe coding is here to stay. It’s fun, it’s fast, and when used well, it’s a force multiplier.

But don’t forget:

You’re the driver, AI is just the copilot

Don’t let autocomplete replace your brain

Read, verify, and own the code you ship

If you’re coding with AI but not learning from it you’re doing it wrong.

Would love to hear how you’re using AI in your workflow. Is it changing how you think about software architecture, design, or debugging?

Let’s talk — DM me on Ujjwal Tyagi, or drop a comment.

Indexing Deep Dive: Composite Indexes & Real Query Experiments

Ujjwal Tyagi — Thu, 08 May 2025 05:27:15 +0000

We pushed MySQL indexing further with composite indexes and pagination queries. Here’s what we discovered.
tags: [MySQL, Indexing, Database Performance, Experiments, Composite Index]

🧠 Quick Recap (for New Readers)

In our last blog, we showed how adding a simple index on a single column sped up a basic query on 80,000 rows from 420ms to 8ms.

This time, we’re experimenting with composite indexes and pagination queries to simulate more real-world scenarios.

🧪 Experiment Setup

We kept the same dataset of 80,000 records, but added queries that reflect actual use-cases: filtering by multiple columns, sorting, and paginating.

🔧 Table Structure (Same as Before):

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255),
  email VARCHAR(255),
  age INT,
  city VARCHAR(255),
  created_at DATETIME
);

🧪 Experiments & Results

🧪 Experiment 1: Composite Index on (`city`, `age`)

Query:

SELECT * FROM users WHERE city = 'Mumbai' AND age = 30;

Without Index:

Execution Time: ~430ms
Rows Examined: ~80,000 (Full Table Scan)

With Index:

CREATE INDEX idx_city_age ON users(city, age);

Execution Time: ~10ms
Rows Examined: ~400

✅ Result: Drastic improvement when filtering by both fields in the same order as the index.

🧪 Experiment 2: Reversed Order in Query (Still using same index)

Query:

SELECT * FROM users WHERE age = 30 AND city = 'Mumbai';

Execution Time: ~200ms
MySQL did not fully utilize the composite index
Rows Examined: ~14,000

⚠️ Insight: Composite indexes only work efficiently left to right.

🧪 Experiment 3: Sorting with Index

Query:

SELECT * FROM users WHERE city = 'Mumbai' ORDER BY age;

Without Index: ~350ms, full table scan then sort
With Composite Index (city, age): ~9ms

✅ Index helps with both filtering and ordering if the sort column is included in index order.

🧪 Experiment 4: Pagination Query

Query:

SELECT * FROM users WHERE city = 'Mumbai' ORDER BY created_at LIMIT 50 OFFSET 10000;

Without Index: ~500ms
With Index on (city, created_at): ~20ms

✅ Pagination becomes significantly faster when an index is used for both filter and sort.

📊 Summary Table

Query	Index Used	Time (ms)	Rows Examined	Note
`city = 'Mumbai' AND age = 30`	city, age	~10	~400	Perfect match
`age = 30 AND city = 'Mumbai'`	city, age	~200	~14,000	Wrong order
`city = 'Mumbai' ORDER BY age`	city, age	~9	~450	Filtering + sorting
`city = 'Mumbai' ORDER BY created_at LIMIT 50 OFFSET 10000`	city, created_at	~20	~10,050	Efficient pagination

💡 Learnings

Composite indexes must follow the left-to-right rule. You can’t skip columns in the order.
Use EXPLAIN to check which indexes are used.
Composite indexes work beautifully when your query filters and sorts in the indexed order.
For large OFFSETs, indexes reduce the load drastically.

🔮 Coming Up Next

In the next post, we’ll explore:

Covering indexes
Multi-index selection
Index merge strategies

If you’ve ever wondered how multiple indexes interact or why MySQL sometimes ignores your index, don’t miss it.

💬 Got any indexing questions or edge cases you want tested? Drop a comment!

Cracking MySQL Performance: What is Indexing and Why It Matters

Ujjwal Tyagi — Wed, 30 Apr 2025 23:58:59 +0000

🚀 Introduction

Have you ever run a SQL query that just took forever and wondered, "Why is this so slow?" You're not alone. Databases are fast until they're not. And one of the simplest, yet most powerful performance tricks in SQL is indexing.
We ran a real-world experiment on 80,000+ records to see how MySQL indexing affects performance. Here's what happened.
In this post, we'll explore:

What indexing really means in MySQL
Why indexes are performance game changers
The exact results of an experiment we ran on 80,000+ records in
MySQL 5.7 on a local setup (8GB RAM, SSD)
When indexing helps and when it doesn't

Let's dive in.

🔍 What is an Index in MySQL?

Think of an index like a book's table of contents. If you need Chapter 8, you don't flip through every single page you jump straight to it. That's what MySQL does with an index.
Under the hood, indexes in MySQL are usually implemented using a B-tree, which allows the database to quickly search for a value, similar to how a binary search works.
There are different types of indexes:

Primary Index(based on the primary key)
Unique Index (for ensuring uniqueness)
Composite Index (on multiple columns)
Fulltext Index (for searching large text fields)

But theory is one thing. Let's get into what actually happened when we ran an experiment.

🧪 Experiment Setup

We wanted to test just how much indexing can impact performance. So we created a MySQL table with 80,000 rows of dummy data using Python.
🔧 Table Structure:

CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), email VARCHAR(255), age INT, city VARCHAR(255), created_at DATETIME );

No indexes were added except the default PRIMARY KEY on id.
🧑‍💻 Query Used:
`SELECT * FROM users WHERE city = 'Mumbai';

`We ran this query under two scenarios:

Without indexing on city
With indexing on city

To simulate real-world conditions, we repeated each query 10 times and calculated the average execution time using Python's time module and MySQL's EXPLAIN ANALYZE.

📈 Results

Here's what we found:
🔹 Without Index:

Average execution time: ~420ms
EXPLAIN showed a full table scan (rows examined: ~80,000)

**🔹 With Index on city:
**CREATE INDEX city_index ON users(city);

Average execution time: ~8ms
EXPLAIN showed an index lookup (rows examined: ~300)

That's 50x faster, just by adding a single index!

💡 Key Takeaways

Indexes drastically reduce query execution time when filtering large datasets.
EXPLAIN is your best friend for debugging SQL performance.
Indexes come with write overhead - they slow down INSERT, UPDATE, and DELETE slightly. So, use them strategically.
Always benchmark with your real query pattern and data volume.

🔮 What's Next?

In our next blog, we'll take this one step further:

Adding composite indexes
Trying indexes on multiple fields
Testing against pagination queries like LIMIT OFFSET
Comparing performance gains with even larger datasets

Stay tuned for Part 2 of our indexing deep-dive!
Have you ever optimized a query using indexing? What performance gain did you notice?
Share your thoughts or questions in the comments.👇

The Secret to Unstoppable Motivation: Vision vs Anti-Vision Explained

Ujjwal Tyagi — Mon, 20 Jan 2025 14:50:00 +0000

The Experiment: A Rat, Cheese, and a Cat

Imagine a rat placed in a straight tunnel. At the far end of the tunnel, there’s a piece of cheese its favourite reward. Naturally, the rat starts running toward it, driven by hunger and the promise of pleasure.

Now, imagine introducing a new factor. Behind the rat, at the starting point of the tunnel, you place a cat. A real predator.

What happens?

The rat doesn’t just run it sprints!

It moves faster than before, driven not just by the desire to reach the cheese but by the fear of being eaten. The presence of a positive goal (cheese) and a negative consequence (cat) creates a dual force that maximizes motivation.

The Third Experiment: The Ultimate Speed Boost

Researchers then introduced a third variation:

The rat had both the cat behind it and the cheese in front.

This time, the rat outperformed its speed in the previous two experiments. It moved faster than ever before.

This proves a powerful insight: Motivation is strongest when we have both a compelling vision (what we want to achieve) and a clear anti-vision (what we fear or want to avoid).

Vision vs. Anti-Vision: The Dual Approach to Motivation

Most people set goals based on what they want:

“I want to be fit.”

“I want to be financially free.”

“I want to have a fulfilling career.”

But what if you also define what you don’t want—the nightmare scenario?

“I don’t want to be stuck in a dead-end job, miserable every morning.”

“I don’t want to be out of shape, feeling tired and weak.”

“I don’t want to live paycheck to paycheck, constantly stressed about money.”

Just like the rat, when you recognize both the cheese (vision) and the cat (anti-vision), your motivation skyrockets.

Why This Works

Fear is a Stronger Motivator than Pleasure
Studies show that people are more likely to act to avoid pain than to gain pleasure. When you create an anti-vision, you activate that fear response in a controlled way.

Clarity Through Contrast
It’s often hard to define what we truly want, but we instinctively know what we don’t want. Writing both down makes your path clearer.

Built-in Discipline
On days when motivation fades, the anti-vision serves as a wake-up call. It reminds you of the consequences of inaction.

My Experience: Writing My Vision and Anti-Vision

I recently sat down and wrote both my vision and anti-vision.

At first, I thought I knew what I wanted, but once I started writing, I realized I had only vague ideas. The process of putting it on paper forced me to be specific.

More importantly, my anti-vision was a reality check. It showed me what my life could become if I didn’t take action. And that hit harder than any motivational quote ever could.

This led me to a deeper realization writing your thoughts down is a powerful tool.

Why You Should Write Things Down

This exercise made me understand something important: writing brings clarity.

When your thoughts stay in your head, they’re scattered. But when you put them on paper, you see them for what they are. This might even be the idea for another blog—why writing your thoughts down is essential for self-awareness.

Where I Got This Idea

This concept was inspired by a video:
👉 Instantly Boost Motivation by 20x by Outperform.

For more details on the rat experiments and motivation, you can check out:
👉 Jaak Panksepp's experiments

If you’re someone who struggles with motivation or clarity, I highly recommend watching the video and reflecting on the experiment.

Final Thought: Try It Yourself

Take 10 minutes and write down:

Your Vision – The life you want to create.

Your Anti-Vision – The life you want to avoid.

It might just be the push you need.🚀

From Pixels to Predators: The Dark Side of Pornography and Sexual Violence

Ujjwal Tyagi — Sun, 12 Jan 2025 07:20:00 +0000

The increasing number of rape cases is a harsh reality that our society faces today. While multiple factors contribute to this crisis, one significant but often overlooked aspect is the role of pornography. The porn industry has grown exponentially over the years, becoming a powerful influence on societal norms and behaviors. This blog delves into how the rise of pornography, its accessibility to younger audiences, and the escalation from soft to hardcore content have played a crucial role in normalizing rape culture, with a particular focus on India.

The Porn Industry: From the Shadows to the Spotlight

The Evolution of Pornography
Once a taboo, confined to magazines and hidden VHS tapes, the porn industry has undergone a dramatic transformation. The advent of the internet in the late 20th century brought about a revolution, turning pornography into a global phenomenon. With the rise of smartphones, high-speed internet, and streaming platforms, porn is now more accessible than ever. The industry’s financial success, estimated at over $100 billion globally, is a testament to its pervasive influence .

Mainstream Normalization
Platforms like Pornhub and OnlyFans have not only normalized but also monetized explicit content, making it a regular part of daily internet consumption. This shift has brought pornography out of the shadows, embedding it firmly within mainstream culture. But at what cost?

The Danger of Easy Access: A Crisis for Our Youth

The First Exposure
In today’s digital age, pornography is alarmingly accessible to young audiences. Studies indicate that the average age of first exposure to porn is now around 11 years old . For many adolescents, pornography becomes their first and, often, only source of sexual education. Without proper guidance, this can lead to a distorted understanding of sex, relationships, and consent.

Molding Young Minds in India
In India, the situation is particularly concerning. Despite attempts to regulate access to pornography, the proliferation of cheap smartphones and data plans has made it easier than ever for young people to access explicit content. The lack of comprehensive sex education exacerbates the issue, leaving children to learn about sex from the unrealistic and often violent depictions they see online. This early exposure can have lasting impacts, shaping their attitudes towards sex and women in harmful ways. A 2019 survey by the NGO Save the Children revealed that nearly 60% of adolescents had accessed pornographic content on the internet, often without any adult supervision .

The Descent: From Soft Porn to Hardcore Extremes

The Slippery Slope
Pornography consumption often starts innocuously, with “soft” content that romanticizes sexual encounters. However, over time, many users find themselves desensitized and seeking more extreme content. This progression isn’t accidental—it’s a result of the brain’s reward system adapting, pushing individuals to seek higher levels of stimulation.

Hardcore and Its Consequences
Hardcore pornography often includes themes of extreme violence, degradation, and non-consensual acts. The repeated consumption of such content can have severe psychological effects, including increased aggression and a distorted view of sexual consent . What was once considered shocking becomes normalized, blurring the lines between fantasy and reality.

The Dark Connection: Pornography and Sexual Violence

The Research Speaks
Numerous studies have established a troubling link between porn consumption and sexual violence. Research shows that individuals who frequently consume violent porn are more likely to exhibit sexually aggressive behavior . The normalization of rape culture, fueled by the portrayal of sexual violence in porn, distorts societal views on consent and sexual behavior.

Real-Life Impacts in India
In India, there have been several disturbing cases where individuals accused of sexual crimes cited pornography as a significant influence. For example, in 2019, a man from Uttar Pradesh was arrested for raping a minor and later confessed that his addiction to violent porn had driven him to commit the crime . Another high-profile case involved a group of schoolboys in Mumbai who sexually harassed their female classmates after being exposed to explicit content online. These incidents highlight the dangerous impact that pornography can have on individual behavior and societal attitudes toward sexual violence .

Beyond the Screen: The Broader Impacts of Porn Addiction

Psychological Addiction
Pornography can be as addictive as substances like drugs or alcohol. The cycle of addiction involves a constant need for more extreme content to achieve the same level of arousal, leading to a downward spiral that is difficult to escape.

Strain on Relationships
Porn addiction can wreak havoc on personal relationships, creating unrealistic expectations and fostering emotional disconnection. The objectification of partners, a common theme in porn, often translates into real-life relationships, leading to dissatisfaction and, in some cases, abusive behavior.

A Call for Action

Recognizing the harmful effects of pornography is the first step in addressing this issue. Public health initiatives, stricter regulations, and comprehensive sex education are crucial in mitigating the impact of porn on our society. By promoting healthy, respectful relationships and challenging the normalization of sexual violence, we can begin to reverse the damage caused by the widespread consumption of porn.

Conclusion

The intersection of porn addiction and the normalization of rape is a complex and deeply troubling issue. As the porn industry continues to thrive, its impact on society cannot be ignored. Understanding the progression from soft to hardcore content, the desensitization to violence, and the direct links to sexual crime is essential in addressing this problem. By raising awareness and implementing effective policies, we can work towards creating a safer and more respectful society.

Sources:
The Economist – “The Pornography Industry: An Economic Perspective
Journal of Aggression, Maltreatment & Trauma – Study on Pornography and Sexual Aggression”
RAINN (Rape, Abuse & Incest National Network) – Research on Pornography and Sexual Violence
The Guardian – “UK Man Convicted of Rape Cites Violent Porn as Influence”
Save the Children India – “Survey on Adolescent Exposure to Pornography”
The Times of India – “UP Man Arrested for Rape, Confesses Porn Addiction”
India Today – “Mumbai Schoolboys Harass Girls After Watching Porn”

Fragile Strength: How Twisted Masculinity Fuels Rape in India

Ujjwal Tyagi — Fri, 10 Jan 2025 07:12:33 +0000

Rape is a heinous crime, and those who commit it must be held accountable with capital punishment. However, to effectively combat this issue, we must also examine the societal factors that contribute to such behaviour, including the erosion of true masculinity.

Understanding True Masculinity

True masculinity is defined by strength, responsibility, respect, and protection. A genuinely masculine man respects others, stands up for what is right, and uses his strength to uplift and protect. Unfortunately, this ideal has been increasingly distorted, giving rise to toxic masculinity—an interpretation that equates manhood with dominance, aggression, and entitlement.

Rape: A Crime of Choice

It is crucial to emphasize that rape is a crime—a deliberate choice made by an individual to harm and exert power over another. No societal issue can ever justify this horrific act. The responsibility lies squarely with the perpetrator, who must face the consequences of their actions. However, to prevent future crimes, we must also address the underlying factors that contribute to this behavior.

The Erosion of Masculinity

As India has modernized, societal changes have shifted the traditional roles of men. Without strong, positive male role models, young men may feel lost, leading them to adopt harmful behaviors to assert their masculinity. This behavior is not strength; it is insecurity and cowardice, leading to violence against women and perpetuating a cycle of fear and oppression.

Linking Lack of Masculinity to Rape

Rape is often a crime of power and control. Men who lack a sense of true masculinity may feel the need to exert power over others to compensate for their own insecurities. The absence of positive male role models and the harmful effects of porn addiction create a perfect storm for this dangerous behavior to emerge. Recognizing these factors is crucial for preventing future crimes.

The Path Forward: Reclaiming Masculinity

To address the rise in rape cases, we must start by reclaiming true masculinity. This begins with educating young men about what it truly means to be a man—teaching respect, responsibility, and protection. Families, especially fathers, play a critical role in shaping boys into men who embody these values.

Society must also change. We need to promote positive male role models and create environments where men can express emotions and insecurities without resorting to violence. Stricter laws and swift justice are necessary but must be accompanied by efforts to change the cultural narrative around masculinity.

Conclusion

The rise in rape cases in India is a symptom of a deeper crisis of masculinity. By reclaiming the true essence of manhood—through education, family support, and societal change—we can build a future where men protect rather than harm, creating a world where women can live without fear.

Gods and Monsters: The Dark Reality of Rape in India

Ujjwal Tyagi — Thu, 09 Jan 2025 07:38:53 +0000

India, a land revered for its rich cultural heritage and spiritual traditions, also bears the heavy burden of a grim reality: the persistent and horrifying issue of rape. Despite being a country where women are worshipped as Goddesses, sexual violence against them continues to plague society by Monsters. This blog series, titled Gods and Monsters, aims to shed light on the multifaceted issue of rape in India, offering a detailed examination of the statistics, the contributing factors, and the societal response.

Introduction

Rape is not just a crime; it is an act of extreme violence and power that devastates the lives of victims and their families. The statistics are staggering, with thousands of cases reported each year, and many more going unreported due to fear, stigma, and lack of support.

Understanding the Scope: Rape Statistics in India

The first step in addressing any issue isa understanding its scope. In 2022, over 32,000 cases of rape were reported in India, according to the National Crime Records Bureau (NCRB). These numbers are just the tip of the iceberg, as many survivors do not report the crime due to societal pressure or fear of retribution. The series will delve into these statistics, exploring trends over the years, regional disparities, and the impact of these crimes on society.

What is Rape?

Rape is a severe violation of a person’s dignity and rights. In India, it is legally defined under Section 375 of the IPC, which includes non-consensual sexual acts. Survivors have rights to privacy, free medical treatment, legal aid, and compensation. The psychological impact, including PTSD and trauma, can be profound, making support and counsseling essential for recovery.

Support Systems: Helplines, Apps, and Police Information

Survivors can access several resources for help. Key helplines include the Women’s Helpline (1091) and Sakhi One Stop Centres, offering 24/7 support. Apps like My Safetipin and Himmat Plus provide safety and emergency alerts. Police support includes filing FIRs, with options like Zero FIR, which can be filed at any station. But alas these systems are not effective against rape when seen from ground reality.

Exploring the Contributing Factors

To understand and ultimately reduce the incidence of rape, it is essential to explore the various factors that contribute to this crime. The subsequent blogs in this series will examine these factors in detail:

Fragile Strength: How Twisted Masculinity Fuels Rape in India

Explores how the erosion of true masculinity and the rise of toxic masculinity contribute to the increasing violence against women.

From Pixels to Predators: The Dark Side of Pornography and Sexual Violence

Discusses the impact of widespread pornography consumption on perceptions of sex, consent, and relationships, and how it may contribute to rape culture.

The Role of Socioeconomic Factors

Examines how poverty, lack of education, and unemployment can lead to frustration and aggression, potentially contributing to criminal behavior like rape.

Cultural Norms and Patriarchy

Looks at how deeply ingrained patriarchal values and cultural norms perpetuate the objectification and subjugation of women, leading to higher rates of sexual violence.

The Impact of Media

Analyzes how the portrayal of women in movies, television, and advertising may influence attitudes towards women and contribute to the normalization of sexual violence.

The Role of Substance Abuse

Discusses how alcohol and drug abuse are often linked to aggressive behavior, including sexual violence.

Judicial and Law Enforcement Failures

Critiques how the failures of the judicial system and law enforcement agencies in India can discourage survivors from seeking justice and embolden perpetrators.

Conclusion: Moving Forward

The Gods and Monsters: The Dark Reality of Rape in India series aims to be more than just a collection of discussions; it is a call to action. By understanding the factors that contribute to sexual violence and by providing resources for prevention and support, we can work towards a future where women in India can live without fear. Each blog in this series will contribute to a deeper understanding of the problem and offer solutions to combat this grave injustice.

Crafting Efficiency: The Symphony of Protocol Buffers and gRPC

Ujjwal Tyagi — Fri, 08 Dec 2023 09:29:47 +0000

In the dynamic universe of software architecture, where precision reigns supreme and communication is an art form, two virtuosos—Protocol Buffers (protobuf) and gRPC—collaborate to compose a harmonious symphony of efficiency, interoperability, and futuristic data exchange.

I've crafted a sample project demonstrating protobuf, and it now stands proudly on my Git repository, ready for your exploration and reference :

The Costume Crafting by Protocol Buffers:
Imagine a superhero suit design—a .proto blueprint where you, the costume designer, outline the unique attire for your data. Using special codes like int32, string, and others, you create a costume that perfectly fits the personality of your data.

Crafting the Super Suit:
protobuf file : Message.proto

syntax = "proto3";

message MyMessage {
    int32 id = 1;
    string name = 2;
}

As the superhero suit takes shape, the compiler becomes your trusty sidekick, transforming your costume design into different superhero suits that superhero buddies all over can understand—a universal language only for data superheroes.

Transforming into Binary Heroes:
With a touch of serialization magic, your data transforms into a binary superhero—a sleek and efficient costume ready for a speedy adventure through data highways.

gRPC: Where Superheroes Unite for Precision:

Step into the Superhero Headquarters of gRPC, where Protocol Buffers takes the lead in an epic team-up. Together, this powerful duo orchestrates a symphony of serialized communication with superhero-level precision.

Lightning-Fast Superpowers:
In a world where speed is crucial, Protocol Buffers' compact binary format dashes across networks, ensuring superhero-level communication and leaving a minimal footprint.

Multilingual Team-Up:
The excitement intensifies as superhero buddies communicate effortlessly in different languages. Thanks to Protocol Buffers' universal powers, gRPC becomes a language maestro, coordinating superhero missions in the grand universe of microservices.

Code Crafting Mastery:
With a burst of coding brilliance, gRPC generates superhero suits for your data buddies from the .proto blueprint. Maintenance becomes a heroic feat, and errors disappear into the shadows as your serialized superheroes swoop in for the rescue.

Ever-Evolving Adventures:
In the superhero universe of distributed systems, change is constant. Protocol Buffers, with its adaptability, allows superhero services to evolve seamlessly, ensuring superhero adventures continue without a hitch.

The Grand Superhero Alliance:

As you embark on your superhero mission with gRPC and Protocol Buffers, remember you're not just coding; you're orchestrating a superhero alliance of serialized communication. You're the superhero commander, and your serialized heroes transcend language barriers, creating a legendary saga across the digital landscape.

May your code be superheroic, your communication super efficient, and your journey through the serialized realms of gRPC be nothing short of a legendary superhero adventure. Happy coding! 🦸‍♂️💻🚀

p.s. A massive shoutout and thanks to Anubhav Srivastava's YouTube tutorial for guiding me! 🙌

Spring JDBC: Where Java Meets the Database, with a Dash of Humor!

Ujjwal Tyagi — Mon, 13 Nov 2023 05:45:01 +0000

Welcome back to our Spring adventure! 🌼 Today, we're diving into the fascinating world of Spring JDBC. But hold on to your wizard hats, because Spring JDBC is not just about databases—it's about making database operations as easy as pulling a rabbit out of a hat! 🎩✨

Unveiling the Magic of Spring JDBC

Before we get into the fun stuff, let's address the big question: "Why Spring JDBC when JDBC is already around?" Well, think of Spring JDBC as your trusty magician's assistant, here to make your life easier with these nifty tricks:

Magic-Wand Simplicity: Say goodbye to the endless, verbose, and repetitive JDBC spells. Spring JDBC waves a magic wand and makes the boilerplate code disappear.
Hocus-Pocus Exception Handling: JDBC sometimes throws checked exceptions that can be trickier than an escape act. Spring JDBC catches them and lets you manage them gracefully.
Abracadabra Resource Management: Dealing with opening and closing resources in JDBC is like managing disappearing rabbits. Spring JDBC, your diligent assistant, takes care of it automatically.
Testimonial: Guaranteed Applause: Testing JDBC code can be a magic show on its own. Spring JDBC is like a spotlight, making your data access logic shine in unit tests.

Let's Play with Code

Now, let's bring some magic into our code with a simple example. We'll use Spring JDBC to retrieve data, just like pulling a rabbit out of a hat.

import org.springframework.jdbc.core.JdbcTemplate;

public class DataAccessor {
    private JdbcTemplate jdbcTemplate;

    // Constructor and setter for JdbcTemplate

    public String retrieveData(int id) {
        return jdbcTemplate.queryForObject("SELECT data FROM your_table WHERE id = ?", String.class, id);
    }
}

Voilà! We're using Spring's JdbcTemplate to execute the SQL query and retrieve data. Notice how the code is as enchanting as a magician's performance compared to the verbose JDBC equivalent.

The Trickery Continues

With Spring JDBC, you can perform various magical operations:

Certainly, here are concise code examples for common JDBC operations using Spring JDBC:

- Data Retrieval: Retrieve data like a pro, as shown in our example.

   String query = "SELECT name FROM employees WHERE id = ?";
   String name = jdbcTemplate.queryForObject(query, String.class, employeeId);

- Data Insertion: Insert new records or update existing ones with just a flick of your wand.

   String insertQuery = "INSERT INTO employees (id, name, salary) VALUES (?, ?, ?)";
   jdbcTemplate.update(insertQuery, newEmployee.getId(), newEmployee.getName(), newEmployee.getSalary());

- Data Updates:Updating data made easy

   String updateQuery = "UPDATE employees SET salary = ? WHERE id = ?";
   jdbcTemplate.update(updateQuery, newSalary, employeeId);

- Batch Processing:Simplify batch processing, ideal for tasks like loading large amounts of data.

   String insertQuery = "INSERT INTO products (id, name) VALUES (?, ?)";
   List<Object[]> batchArgs = new ArrayList<>();
   batchArgs.add(new Object[]{1, "Product A"});
   batchArgs.add(new Object[]{2, "Product B"});
   jdbcTemplate.batchUpdate(insertQuery, batchArgs);

- StoredProcedure Calls:Execute stored procedures effortlessly.

   SimpleJdbcCall jdbcCall = new SimpleJdbcCall(dataSource)
      .withProcedureName("sp_update_employee_name");
   SqlParameterSource in = new MapSqlParameterSource()
      .addValue("employee_id", employeeId)
      .addValue("new_name", newName);
   jdbcCall.execute(in);

- Graceful Exception Handling: Handle database exceptions with finesse.

- NamedParameterJdbcTemplate: Enjoy named parameters for your SQL
queries, making your code as clear as a crystal ball.

The Fun Side of SQL

Now, let's get back to the fun part! Dealing with databases can sometimes be like navigating a maze, with SQL queries that speak a foreign language. SQL can be as tricky as trying to order from a mysterious menu at a foreign restaurant. You end up with something unexpected, leaving you wondering if you've ordered a magic potion! 🍽️✨

Spring JDBC is like having a translator by your side, ensuring you get precisely what you asked for. And who doesn't want a trusty translator when dealing with data? It turns your SQL queries from riddles into clear instructions!

Conclusion

Spring JDBC is your ticket to making database operations more magical and less like a high-stakes magic show. It simplifies your Java development toolkit, bringing joy to your coding journey.

In our next installment, we'll continue to explore more Spring magic. Until then, keep coding, and may your database queries always be as spellbinding as a magic show!

SpringJDBC #JavaDevelopment #TechMagic #DatabaseSorcery

Spring Framework: Your Foundation for Building Java Marvels"

Ujjwal Tyagi — Sat, 28 Oct 2023 17:25:26 +0000

In the ever-evolving world of software development, mastering the right tools and frameworks can make all the difference. One such indispensable tool in the Java ecosystem is the Spring Framework. Whether you're a seasoned developer or a beginner taking your first steps into the realm of Java development, Spring is a name that deserves your attention. In this blog, we'll take you on a captivating journey into the world of Spring, providing an engaging introduction to the framework and why it's a critical prerequisite for understanding the magic of Spring Boot.

The Beauty of Spring: A Prelude

Imagine you are an architect designing a magnificent skyscraper. What do you need? A solid foundation! The Spring Framework is the rock-solid foundation for building enterprise-level Java applications. It's your trusty toolkit for constructing robust, maintainable, and scalable software.

So, what makes Spring so captivating? Let's dive in.

Springing into Action: What Is the Spring Framework?

At its core, the Spring Framework is an open-source, lightweight, and comprehensive platform that simplifies Java application development. Developed by Rod Johnson and his team, this framework has evolved over the years, revolutionizing the way we create Java applications.

The Pillars of Spring:

Inversion of Control (IoC): Spring is all about flipping the traditional flow of control on its head. Instead of your code controlling the application, the Spring container manages the object lifecycle. This design principle, known as IoC, allows you to focus on what your code should do, not how to manage its components.

Imagine a marionette show where the puppeteer controls the movements of the marionette. In Spring, you're the puppeteer, and the Spring container controls the objects, ensuring they dance to your tune.

Dependency Injection (DI): Building on IoC, DI ensures that objects in your application are loosely coupled. Spring makes it easy to inject dependencies, facilitating the creation and management of components while making your code highly testable.

Think of DI like assembling a LEGO masterpiece. Each LEGO brick (dependency) fits perfectly into place, and you can swap pieces easily if needed without affecting the whole structure.

Aspect-Oriented Programming (AOP): Spring embraces AOP to separate cross-cutting concerns, like logging and security, from your core business logic. This results in cleaner and more maintainable code.

AOP is like having a personal assistant who handles all the paperwork, scheduling, and other mundane tasks while you focus on your core responsibilities.

Spring Modules: Spring's extensive ecosystem includes modules for a variety of tasks, from data access (Spring Data) to messaging (Spring Integration) and more. This modular approach allows you to pick and choose the components that fit your project's needs.

Consider Spring modules as a buffet where you choose only the dishes that suit your palate. No need to order a five-course meal when you're craving a single appetizer.

Why Is Spring So Captivating?

Simplicity: Spring's elegant and straightforward design promotes best practices in Java development. It encourages modularity, testability, and maintainability.

Think of Spring as a GPS that guides you through complex city streets. It simplifies the journey, helping you avoid traffic jams and detours.

Versatility: From building web applications with Spring MVC to creating RESTful services with Spring Web, the framework is a versatile toolbox for a wide range of applications.

Spring is like a Swiss Army knife for developers, with specialized tools for various tasks, all neatly organized in a single package.

Community and Documentation: The Spring community is one of the most vibrant and supportive in the world of software development. A wealth of documentation, forums, and tutorials make learning Spring enjoyable.

The Spring community is like a global coffee shop, where you can always find someone willing to share their knowledge and experiences over a cup of Java.

Industry Adoption: Spring has been the backbone of countless enterprise applications and is widely adopted by organizations across the globe. Learning Spring opens doors to exciting career opportunities.

In the world of programming, Spring is like the language everyone understands. Speaking it fluently gives you access to a wider audience and more opportunities.

Conclusion

The Spring Framework is more than just a tool; it's a philosophy. It's about writing clean, efficient, and maintainable code that scales with your ambitions. Spring paves the way for building enterprise-level applications and empowers developers to create software that's both robust and elegant.

In our journey to explore the Spring Framework, we'll delve deeper into its various modules, showcase practical examples, and highlight how Spring simplifies the development of complex Java applications. So, fasten your seatbelts, as we embark on a fascinating adventure into the heart of the Spring Framework.

Stay tuned for the next installment of our Spring exploration, where we'll discuss the Spring container, IoC, and DI in greater detail. Until then, happy coding!

Unleashing the Magic of Job Schedulers: How to Tame Your Code and Save Your Sanity

Ujjwal Tyagi — Thu, 13 Apr 2023 06:00:05 +0000

Once upon a time, in a land far, far away, software engineers were manually running their code on their machines like it was the Wild West🐎. But then, a hero emerged - the job scheduler!🔫 A tool that revolutionized the way developers manage their tasks, making their lives easier and their code more organized. So, let's dive into the magical world of job schedulers and discover how they can save you from the chaos of manual task management.

From Granny-tech to Anime-inspired😎

IBM TWS was one of the earliest job schedulers used in enterprise IT environments to manage batch jobs and automate workflows. TWS used a central server to manage and schedule jobs across multiple platforms and operating systems. It was a powerful tool that allowed users to create and schedule jobs across different platforms and applications.

While TWS was a powerful and widely used job scheduler in its time, it was also complex and difficult to configure and maintain. Developers wanted a more flexible and scalable solution that could handle complex dependencies and workflows. This led to the development of more modern schedulers.

Airflow uses a directed acyclic graph (DAG) to define workflows, allowing users to define complex dependencies and schedule tasks based on their relationships.

Mage is a proprietary job scheduler developed by Shopify. It was designed to handle the high volume of tasks and dependencies in their e-commerce platform. Mage is known for its scalability and ability to handle complex workflows across different data centres.

Another popular scheduler is HashiCorp Nomad, which takes a more modern, cloud-native approach to job scheduling. Nomad is designed to be highly scalable and flexible, allowing users to run jobs on any infrastructure, from bare metal to virtual machines to containers.

While modern schedulers have become increasingly popular, the use of Cron Jobs still remains relevant. Cron Jobs is a simple and widely used scheduling tool in Unix-based systems. They allow users to schedule repetitive tasks at specific intervals using a standard syntax.

Since I plunged from TWS to Airflow, let's dive into their comparison!

Ready to Migrate? Your Smooth Transition Checklist!📝

Identify the existing job workflows running on TWS
Define the job workflows in Airflow using Directed Acyclic Graphs (DAGs)
Configure connections for any external systems used in the job workflows
Migrate job scripts from TWS to Airflow, with support for various languages such as Python, Bash, and SQL
Set up scheduling rules in Airflow that match those in TWS
Test and validate the workflows for functionality and performance
Switch over from TWS to Airflow, with close monitoring during the transition period
Monitor and maintain the workflows, with necessary adjustments made as needed.

Pennywise or Penny Foolish??💸

Reduced licensing costs: Airflow is free and open-source, while TWS requires users to pay licensing fees.
Lower hardware costs: Airflow can run on a cluster of servers or on cloud platforms, which can reduce hardware costs compared to TWS's centralized server requirement.
Easier maintenance: Airflow has a simple web-based interface and a user-friendly workflow definition language, which can reduce labour costs compared to TWS's complex configuration and maintenance requirements.
Better resource utilization: Airflow can dynamically allocate resources based on job requirements, which can improve resource utilization and reduce costs compared to TWS's potential for uneven resource utilization.

Overall, migrating to Airflow can help organizations save money by reducing licensing and hardware costs, improving productivity, and optimizing resource utilization, all while providing greater flexibility and agility.

Limitations of Airflow🚫

Resource Intensive
Steep Learning Curve
Limited Native Support for Real-time Workflows
Limited Monitoring Capabilities
Lack of Native Support for Kubernetes

Conclusion🌐

In summary, the modernization of job schedulers in software engineering has improved scalability, flexibility, and cost-effectiveness. New job schedulers allow for greater automation, better visualization, and more efficient management of tasks. Migrating to modern schedulers can optimize processes, reduce costs, and improve overall performance, making it crucial to stay up-to-date with the latest tools and technologies.
But they will keep on coming my friend so hold you're horses!🏇

Keep Learning, Keep Growing!🙌🌻

Cheers,
Ujjwal🤙

Document or Die: The Importance of Writing Things Down in Tech

Ujjwal Tyagi — Mon, 10 Apr 2023 16:19:08 +0000

I used to think documentation was just an optional ''docu-maybe-tion'', but boy was I wrong!😆 It turns out that skipping documentation can really come back to byte you in the code🐍. I learned this the hard way at work, when the previous team left us without a single document, and we had to spend so much time deciphering their code that we could have written a whole new feature in the time it took us!🥲

So, if you want to avoid getting caught in a 'docu-mess', make sure to prioritize documentation in your projects.

What the heck is technical documentation?🤓

Process of creating detailed, accurate, and comprehensive records of a software system's design, functionality, and code. It serves as a valuable reference for developers, stakeholders, and clients, aiding in the development, maintenance, and understanding of the software system.

But seriously why is it required?🧐

Technical documentation is critical in software engineering as it helps developers and other stakeholders understand the system's functionality, design, and code. It acts as a reference for future developers and helps ensure that the knowledge and expertise gained during the development process are not lost. Additionally, documentation can aid in identifying and resolving issues, reducing development time and costs. It also helps maintain consistency in code and design, reducing errors and improving maintainability.

Is there more than 1 type of document?

Requirements documentation: This includes documentation of the requirements for the software system, such as the functional and non-functional requirements.
Design documentation: This includes documentation of the system's architecture, design decisions, and technical specifications.
User documentation: This includes documentation that is intended for end-users, such as user manuals, tutorials, and help documents.
Technical documentation: This includes documentation that is intended for developers, such as code comments, API documentation, and technical specifications.
Test documentation: This includes documentation related to testing, such as test plans, test cases, and test results.
Maintenance documentation: This includes documentation related to maintaining and updating the software system, such as bug reports, change logs, and release notes.

Watch for poor documentation red flags🚩

The documentation is not properly structured or easily accessible to all team members.
There is no established task in the project management system with defined responsibilities and regular deadlines.
Clear standards for documentation, quality assessment, and updates are not in place.
Only a few team members are responsible for maintaining the documentation instead of the entire team.
Without the help of a technical writer, the documentation can be challenging for anyone who needs to access it."

A joint operation🤝

Creating proper documentation is not the responsibility of a single person, but a collective effort of all members involved in the software development process. Documentation is not just limited to developers, but includes the work of different departments, such as designers, analysts, and marketers.

By involving everyone in the documentation process, the resulting documentation will cover all aspects of the software development process and provide complete and accurate information. This collaborative approach also helps to ensure that documentation is not overlooked or neglected in the rush to meet project deadlines. Additionally, having a technical writer with strong technical knowledge and writing skills can help to ensure that the final documentation is not only comprehensive but also easy to understand and use.

Maintaining Up-to-Date Documentation👷‍♂️

It is crucial to ensure that documentation accurately represents the current state of processes or products.
If neglected, it becomes useless and hinders the development process. To maintain up-to-date documentation, updating should be treated as a parallel task to product development and follow a set schedule.
Employing version control for documentation management can simplify the process and ensure accuracy.

Some of the best tools in market⚙️

Atlassian Confluence: A widely used documentation tool for teams that offers a variety of features such as team collaboration, project management, and content creation.
Git README: A simple and effective tool for creating documentation in code repositories using Markdown syntax.
ReadTheDocs: An open-source platform for creating and hosting documentation, with support for multiple programming languages and integration with version control systems.
Sphinx: A documentation generator tool that supports a wide range of markup languages, including reStructuredText and Markdown.
Doxygen: A tool for generating documentation from source code, with support for multiple programming languages and output formats.
Docusaurus: A Facebook-initiated open-source tool that helps create and publish documentation websites.

These are just a few examples of the many tools available for technical documentation in software development.

Bottom Line🧐

Documentation isn't just for reports, my friend. We document like it's going out of style at every stage of development. It keeps our code clean, our quality high, and our process understandable.

Keep Learning, Keep Growing!🙌🌻

Cheers,
Ujjwal
Connect with me!🤙

Forem: Ujjwal Tyagi

Ship Fast, Fix Smart: Vibe Coding

🎧 So, What Is Vibe Coding in 2025?

⚡ How It's Actually Helpful

☠️ The Dangers You Should Not Ignore

🧠 What Devs & Tech Leaders Are Saying

✅ TL;DR — Vibe Responsibly

Indexing Deep Dive: Composite Indexes & Real Query Experiments

🧠 Quick Recap (for New Readers)

🧪 Experiment Setup

🔧 Table Structure (Same as Before):

🧪 Experiments & Results

🧪 Experiment 1: Composite Index on (city, age)

Query:

Without Index:

With Index:

🧪 Experiment 2: Reversed Order in Query (Still using same index)

Query:

🧪 Experiment 3: Sorting with Index

Query:

🧪 Experiment 4: Pagination Query

Query:

📊 Summary Table

💡 Learnings

🔮 Coming Up Next

Cracking MySQL Performance: What is Indexing and Why It Matters

🚀 Introduction

🔍 What is an Index in MySQL?

🧪 Experiment Setup

📈 Results

💡 Key Takeaways

🔮 What's Next?

The Secret to Unstoppable Motivation: Vision vs Anti-Vision Explained

The Experiment: A Rat, Cheese, and a Cat

The Third Experiment: The Ultimate Speed Boost

Vision vs. Anti-Vision: The Dual Approach to Motivation

Why This Works

My Experience: Writing My Vision and Anti-Vision

Why You Should Write Things Down

Where I Got This Idea

Final Thought: Try It Yourself

From Pixels to Predators: The Dark Side of Pornography and Sexual Violence

The Porn Industry: From the Shadows to the Spotlight

The Danger of Easy Access: A Crisis for Our Youth

The Descent: From Soft Porn to Hardcore Extremes

The Dark Connection: Pornography and Sexual Violence

Beyond the Screen: The Broader Impacts of Porn Addiction

Conclusion

Fragile Strength: How Twisted Masculinity Fuels Rape in India

Understanding True Masculinity

Rape: A Crime of Choice

The Erosion of Masculinity

Linking Lack of Masculinity to Rape

The Path Forward: Reclaiming Masculinity

Conclusion

Gods and Monsters: The Dark Reality of Rape in India

Introduction

Understanding the Scope: Rape Statistics in India

What is Rape?

Support Systems: Helplines, Apps, and Police Information

Exploring the Contributing Factors

Conclusion: Moving Forward

Crafting Efficiency: The Symphony of Protocol Buffers and gRPC

gRPC: Where Superheroes Unite for Precision:

The Grand Superhero Alliance:

Spring JDBC: Where Java Meets the Database, with a Dash of Humor!

Unveiling the Magic of Spring JDBC

Let's Play with Code

The Trickery Continues

The Fun Side of SQL

Conclusion

SpringJDBC #JavaDevelopment #TechMagic #DatabaseSorcery

Spring Framework: Your Foundation for Building Java Marvels"

The Beauty of Spring: A Prelude

Springing into Action: What Is the Spring Framework?

The Pillars of Spring:

Why Is Spring So Captivating?

Conclusion

Unleashing the Magic of Job Schedulers: How to Tame Your Code and Save Your Sanity

From Granny-tech to Anime-inspired😎

🧪 Experiment 1: Composite Index on (`city`, `age`)