Recent posts in Tutorials

A Date table is needed for analysis in Power BI because it helps organize and analyze data by date. As the name implies, it enables you to create a calendar date information that works for the analysis you want to carry out. i.e weekday, month & year...

In our previous exploration, we dove deep into AsyncIO by writing a task schedulerhttps://dev.to/jeffrey04/asyncio-task-management-a-hands-on-scheduler-project-2e54. We discovered how IO-bound operations were scheduled to the event loop concurrently ...

PostgreSQL Change data capture CDC + golang sample code. !PostgreSQL Change data capture CDChttps://dbconvert.com/blog/content/images/2022/03/PostgresWAL.drawio-1.png The architecture of modern web applications consists of several software compo...

Getting Started LocalStack is a cloud service emulator that runs in a single container on your laptop or in your CI environment. With LocalStack, you can run your AWS applications or Lambdas entirely on your local machine without connecting to a re...

Introduction As developers, we often find ourselves writing repetitive code, whether it's boilerplate classes, data access layers, or UI components. Wouldn't it be great if there was a way to automate these repetitive tasks while maintaining consist...

We discussed Awaitables last weekhttps://dev.to/jeffrey04/understanding-awaitables-coroutines-tasks-and-futures-in-python-gk7. The article covered coroutines, tasks and futures as well as a quick introduction to the event loop. Let’s build an example...

This article covers Pandas, an essential Python data analysis and manipulation library. Data handling is made easier using Pandas, from pre-processing to more complex tasks like time series analysis. It addresses the generation of pivot tables, metho...

Have you ever wondered how to make one of those neat little progress barshttps://dribbble.com/shots/3198381-Progress?utmsource=ClipboardShot&utmcampaign=Volorf&utmcontent=Progress&utmmedium=SocialShare&utmsource=ClipboardShot&utmcampaign=Volorf&utmco...

The rise of video streaming platforms like YouTube, Netflix, and Twitch has transformed how we consume media. But what if you could build your own? In this comprehensive guide, we’ll walk you through creating a full-stack video streaming application ...

In this article, we will look into Pandas, a core Python package for data analysis and manipulation. Now, we'll explore more complex topics to improve your data handling skills, building on the fundamental concepts we covered in earlier sections. Thi...

Have you ever heard of GeoJSON? If not, let me explain it to you. GeoJSON is a format for encoding a variety of geographic data structures created and published in 2008. Since 2015, it has an official specificationhttps://tools.ietf.org/html/rfc7946...

You might have heard the word pythonic when people talk or write about Python code and idiomatic Python expressions. The phrase pythonic essentially means the same thing, that you are writing Python code in the way, that the language was intended to ...

Previously, we explored chatbot building with AsyncIOhttps://dev.to/jeffrey04/how-to-write-an-asyncio-telegram-bot-in-python-4hig. As I am committing to publish one article a week, I am constantly on the lookout for new ideas. Then I figured it may b...

Backing up MySQL databases is essential for data security and disaster recovery. In this article, we continue from our previous post and provide a script to automate MySQL database backups from a VPS to a local machine. This script ensures your backu...

A Deep Dive into ES6 Modules In 2025, as a web developer, knowledge of ES6+ syntax is no longer optional. In this article, we'll take a closer look at ES6 Modules. What is a Module? A module in JavaScript is simply a file containing code that you ...

!Convert to Docx R package1 In this post, I will show you how you can very easily convert your PDF files into Word documents in the R programming language using the Convert2Docx2 R package. Convert2Docx is a lightweight R package that R developer...

The article covers POSTGRESQL, MySQL, and SQLITE3—three major database management systems. They provide unique features and benefits and are essential to software development. Let's explore their features so that you can make better selections that w...

!A robot assistant sitting at a desk1 In this post, I will show you how to build a real-time voice assistant with Mistral AI and FastRTC. Mistral AI2 is one of the leading LLM providers out there, and they have made their LLM API easily accessible ...

What is Modularization in Android? Modularization in Android means breaking an app into smaller, independent modules instead of keeping all code in a single project. Each module has its own responsibility and can be developed, tested, and maintained...

Managing a VPS Virtual Private Server with a MySQL database? Then you know how important regular backups are! A single accidental command, server crash, or unexpected failure can wipe out critical data in seconds. That’s why automating backu...