Gaurav Neema

Software Developer | Gamer | Tech enthusiast!

Wrting about Software Development, SQL, Python etc.


Wordle - What are some good starting words?

February 08, 2022 2 min read

You might have probably heard of Wordle, which is a word guessing game. If you've played Wordle before, you'll know that the most important part of solving the puzzle is starting with a good word. In this article, we will use word analysis to determine the best first word to use when solving Wordle.

Image Processing with OpenCV-Python

June 26, 2021 5 min read

Image processing is a fascinating thing. After spending some time on this, I realized that all the image editing you do with the help of 3rd party tools can be done with OpenCV and much more. Many special effects applied by your camera app can be easily done with the help of OpenCV, in very few lines of code.

This is a small attempt made by me to describe the most common operations that are performed using OpenCV.

Some useful Postgres Functions & Clauses

May 09, 2021 4 min read

PostgreSQL (or Postgres) is one of the most advanced and powerful object-relational databases out there. Postgres can handle big tables with a large number of rows easily.

Let’s look at some of the functions and clauses of Postgres which I personally find very useful.

Indian Government vs Social Media Apps

May 24, 2021 2 min read

We have been seeing a tremendous number of news and posts related to the new IT rules imposed by the Indian Government that social media apps need to follow. These social media apps including Facebook, Twitter, Koo, and WhatsApp. In the latest development, WhatsApp has sued the Indian government over new regulations.
So what’s this is all about?

How to migrate a WordPress website without any plugin?

Jan 27, 2021 2 min read

Migrating a WordPress website sounds so easy, and really is. But there are few caveats that you need to keep in mind if you are doing it for the first time. This story will guide you on how to migrate the WordPress Website easily without the use of any plugin.

Publish Tableau Workbooks from Python

Aug 17, 2020 3 min read

Publishing the Tableau workbooks by using Tableau Desktop is pretty simple and straightforward. But when it comes to publishing them programmatically through API calls, it can be a pain in the ass.

Let's look at one of the simplest ways to do this.

OCRing & Identifying Page Structure - Tesseract + hOCR

Apr 8, 2020 5 min read

Extracting the text from the images with the help of OCR engines is more fun than it sounds. The input images can be tilted, contain broken texts, thick lines around the text making it difficult for our systems to identify the correct text. Sometimes, we also need to consider the page structure and extract only specific sections of text. So if your OCR engine just randomly extract the text from images, even if it is accurate, it will be of less use.

Let's look how we can use Tesseract and hOCR together to identify the page structure and extract relevant information.