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 6Jan 6
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, 2024Dec 13, 2024
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, 20241Oct 27, 20241
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, 2024Oct 2, 2024
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, 2024Aug 22, 2024
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, 2024Jun 24, 2024