Query Any Data, Anywhere-Simplify Workflows with DuckDBEngineering is all about simplicity. We often use lightweight technologies to solve problems instead of overly complex ones, wherever we…Jan 6481Jan 6481
Published inPython in Plain EnglishWhy WordLlama -Tiny Model(16MB) is Better Than SQL LIKE for FAQ SearchIn many applications, we often store FAQs (Frequently Asked Questions) in a database and use SQL queries to search through them. Most of…Dec 13, 20243Dec 13, 20243
How I Used AI to Scrape 500 Pages in Just 5 Minutes!Today I want to share something super cool that happened during my recent project. You know how web scraping usually takes forever to code…Oct 27, 2024781Oct 27, 2024781
Extracting Tables with Titles from PDFs and Converting Them into Structured FormatsHello, fellow data enthusiasts! Today, I want to share my experience with a task many of us encounter: extracting tables from PDFs. If…Oct 2, 20241Oct 2, 20241
Setting Up and Implementing Partitioning for Optimized Database Performance-PoPartitioning is crucial when dealing with transaction data (such as credit, debit, audits, etc.), especially when you’re handling millions…Sep 2, 2024Sep 2, 2024
Implement Replication in Postgresql Using Docker ContainersImplementing replication during database design is always a best practice. It will protect our data if the master system fails, you won’t…Aug 22, 20243Aug 22, 20243
My Data Engineering CareerI started my journey as a data engineer in a Micro Fintech company. There, we used the Mifos (Apache Fineract)Jul 6, 2024Jul 6, 2024
SQL Guidance #First Stage-1if you want to work or learn SQL, start by generating reports where you can discuss with BA people and understand the outcome of what you…Jul 1, 2024Jul 1, 2024
SQL vs PandasMany new data engineers and ML engineers, after completing Python/ML courses, often believe that SQL might not be necessary because Python…Jun 28, 2024Jun 28, 2024
SQLite is a superbossSQLite is the handiest database I’ve ever used. There’s no need to waste time setting up a database server or waiting for permission from…Jun 24, 20242Jun 24, 20242
Streamlining Feature Selection: Statistical Approach with ML in Python using Optimal Binning and…IntroductionApr 29, 2024Apr 29, 2024
Published inPython in Plain EnglishStrategic ML Analytics in Finance: Steps on Manual Approach to NPA PredictionsHey there, we’re on a mission to predict Non-Performing Assets (Bad Loans) the old-school way, steering clear of all those complicated…Nov 27, 2023Nov 27, 2023
Django ORM vs. Serializers: Optimal Data Retrieval for Complex QueriesPerformance: Django ORM Query > Django SerializersSep 20, 2023Sep 20, 2023
Best Practices for Working in Production DatabasesWorking in a production database is a critical aspect of maintaining the integrity, security, and performance of your application. Here are…Aug 30, 2023Aug 30, 2023
Bye Bye SQL: Revolutionizing Base CRUD Operations with Django REST FrameworkIn this blog, we will explore the capabilities of Django REST Framework that allow us to interact with the database and perform CRUD…Jun 13, 20231Jun 13, 20231
Secure Your Website in Minutes: A Beginner’s Guide to Let’s EncryptImagine you have a Django web application(or any application) that is running on an EC2 instance with Ubuntu as the operating system. You…May 12, 2023May 12, 2023
Power Up Your Data Insights with These Top 3 Open-Source BI ToolsBuild a great visualization dashboard by writing SQL and a few button clicks!Apr 12, 20231Apr 12, 20231
Install podman in ubuntu 20.04Podman is a container engine for Linux-based operating systems that provides a way to manage containers without the need for a separate…Mar 31, 2023Mar 31, 2023
From Beginner to Pro: Essential SQL Query ExamplesManaging data is a crucial aspect of running any website or application, including blogs. And when it comes to managing data, SQL…Mar 10, 20233Mar 10, 20233