Comparing the performance of pypolars and pandas — pandas was initially released in 2008 written in Python, Cython, and C. Today, we’re comparing the performance of this well-known library with pypolars, a rising DataFrame library written in Rust. We compare the two while sorting and concatenating a 25Mil-record data and also when joining two CSVs. Downloading Reddit Usernames data Let’s first download…

Want to write a technical book or document your project? Here I’ll walk you through how you can do that with python and sphinx. You can build content of tables that can contain sections to the chapters of your book. …

Trends in your hand — Social Analytics companies have been massively using twitter to get insights about whatever data they are interested in for brands, celebrities, etc. and also trending topics. …

In today’s data-driven world, effective database performance monitoring is crucial for maintaining the smooth operation of critical systems. Datasentinel is a PostgreSQL performance monitoring tool that helps you identify and fix performance problems. …

SQL is a powerful tool that can help us to extract valuable insights from large datasets. However, writing SQL queries that run efficiently can be a challenging task, even for experienced developers. When debugging slow running queries, you might be tempted to follow the first route that comes on your…

As a DevOps engineer or a sys admin, it's essential to master Linux. While the command-line interface (CLI) is a powerful tool, navigating it can be daunting, especially for new users. That's why getting help in Linux is essential to efficiently and effectively using the CLI. In this tutorial, we'll…

Tracking PostgreSQL execution plans is an important metric for enhancing PostgreSQL performance. In an earlier tutorial discussing pg_stat_statements extension, we learned how to track PostgreSQL queries. In this tutorial, we will discuss how to track PostgreSQL execution plans run by the server optimizer with the pg_store_plans module, an extension created…

Python is a versatile and powerful programming language that is loved by developers worldwide. It’s easy to learn and use, and has a vast range of libraries and tools to help you get your job done quickly and efficiently. One of the language’s most useful and underused features is the…

Use this Python Boilerplate in your modern web app — FastAPI has been adapted for building modern Python applications. Today, you’re going to pair this lightweight performant framework with Jinja2 template engine and a modern CSS framework, Tailwind CSS. You will then use SQLAlchemy ORM for the database. Tailwind CSS is a utility-first CSS framework which means it has a…