Have you ever wondered why database cursors even exist? I bet there will be instances where a developer wants to load massive SQL query response data in their application. Ex: Fetch data of a million records for processing into your application.

What if the application’s memory (ECS task, EC2 instance or a VM) cannot hold that million records SQL response and crashes the entire application? To your surprise, at the end of this article, you’ll know the solution. As a developer, you should know cursors well to optimize your application.

Why need cursors?

There are generally two ways an application can handle vast…

while adding a plan to write this article in my bullet journal…

Initial words

Hi, I am Naren Yellavula, a 27-year-old software professional. If aliens dramatically steal me from this earth tonight, I don’t have to regret it because I already left my legacy in history. How? I authored two technical books on web development with the Go programming language. Am I feeling proud? Yes, but only humbly.

In this article, I want to share what it takes to write a book, my mental journey throughout the development, and how it can inspire you to become a future author. First of all, I am one of the firm believers of marathons over sprints. Every…

Photo by Tomas Sobek on Unsplash

As part of daily job, sometimes you have to work with zip archives/files. Even though it looks straight-forward, sometimes few custom requirements can force you to the bang-head situation while searching a clean way to manage zip files.

Recently, at my work, I implemented a feature where I have to download a zip file from S3, update its content, and upload it back to S3. The content can be dynamic, and I have to update only the specific part(a file) and retain all others. On the process, I researched a bit about the topic, tried to explore the Python 3…

In our daily life, we come across many ideas, make many decisions. Decision making is a tough job and can sometimes feel like science. Judging a situation is productively applying our intuition. Every human makes thousands of choices on a given day(even more). How to make a judgment that offers maximum returns? Is there any process that can explain the art of analysis. Judgment is a complex skill to master, but one can simplify it by knowing what the factors that affect our judgment are.

I am not a personality coach, neither a subject matter expert nor a Judge in…

Photo by Scott Webb on Unsplash

True! the title compares apples & airplanes. Technically, software tests and education system are entirely two different things. But like computer algorithms, the standard patterns can be applied to solve problems in various domains. We talk about one such pattern called ‘Revision.’

According to the Collins dictionary, Revision is:

Variable Noun:

To make a revision of something that is written or something that has been decided means to make changes to it in order to improve it, make it more modern, or make it more suitable for a particular purpose.

Uncountable Noun

When people who are studying do revision, they read things again and…

This article is a reflection of my recent journey to Berlin, Germany’s capital to attend a party given by my company. I felt Berlin is warm to newcomers, and it has tons of history from world wars and, homes, people from different backgrounds and nationalities. In a few phrases, what I feel about Berlin:

Berlin is a human rights capital of Germany. It embraces a new inhabitant with both hands and Berlin always has room for someone: a tourist, an expat or a refugee. …

Photo by Element5 Digital on Unsplash

I have a schedule of things which I try to follow every day, week and month. It consists of habits and diet plan. The beauty of it is, it has very minimal elements which you can easily procure or prepare. All the points may not be valid to you but can inherit some of these ideas into your checklist.

Overall habits:

  1. Drink water. Keep hydrated throughout the day
  2. Sleep well (Min 7 hours a day)
  3. Eat fish twice a week (Rotate types of fish every week)
  4. Drink coffee once a day with less sugar
  5. Eat Dark Chocolate every alternative day
  6. Have two…

Market Square, Rothenburg

This article is a short extract from my diary about my recent trip to `Rothenburg ob der Tauber`. Rothenburg is a German city that lies in the heart of the Middle Franconian region in Bavaria state. It is famous for its city wall and trading history. It is also one of the cities on the famous Romantic Road, Germany. One can reach Rothenburg easily from Nürnberg, the second biggest city in Bavaria after Munich(München). Frequent trains from Nürnberg to Würzburg will take you to Steinach(b Rothenburg ob der Tauber). Don’t confuse it with Steinach in Thuringia, another German state. …

Photo by Aaron Burden on Unsplash

ముందుగా నా గురించి ఒక రెండు మాటలు. నా పేరు నరేన్. నేను వ్రుత్తి రీత్యా ఒక సాఫ్ట్ వేర్ ఇంజినీర్ను. ప్రస్తుతం దక్షిణ జర్మనీలోని బవేరియాలో నివాసముంటున్నాను. ఏంతో మంది తెలుగు విధ్యార్థులు, ఈ రెండు మూడు సంవత్సరాలనుండి మార్కుల కారణంగా రాలిపోవడం నన్ను ఎంతగానో కలిచివేసింది. ఆత్మహత్య చేసుకోవాలి అన్న ఆలోచనలు ఉన్న విధ్యార్థులకి నా ఈ లేఖ ఒక విరుగుడులా పనిచేస్తుందని నమ్ముతున్నాను.

తెలుగు రాష్ట్రాలల్లో విద్యా ప్రమణాలు నానాటికి దిగజారుతున్నాయి అని నేను సహా ఎవరైనా అంటే మేధావులు, సిల్లబస్ తయారు చేసే పెద్దలు కొట్టిపారెయ్యవచ్చు. కాని విద్య మాటున మన విధ్యార్థులకి, భావి సమాజానికి మనం చేస్తున్న చేటుని గుర్తించకపొతే జరిగే అపారమైన నష్టానికి మనమే బాధ్యులమవుతాం అని చెప్పడనికే ఈ వ్యాసం.

విద్య అనేది సమాజాన్ని నిర్నించడానికి ఉపయోగపడాలి అని ఎందరో మహానుభావులు ఉద్ఘాటించిన మాట మనందరికి తెలిసిందే. అయితే విద్య అనేది…

Photo by John Schnobrich on Unsplash

Hello fellow developers and engineers. Many of you do software development as part of your daily job. You work on tickets/issues/tasks, create branches, merge requests, and patches. How many of you do code reviews or give your code for others to review as a religious practice? Do every single line of code developed is reviewed by your team? If your company/team do not have the culture of code reviews, this is the right time for you to start it. If you have a casual code review process, then you should turn it into a serious one. In this article, I…

Naren Yellavula

Software Engineer | (( Python | Node.js | Go) & React.js) Author of Hands-on RESTful web services with Go | Lives in Bayern, Germany

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store