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. …

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. …

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…

Writing SQL queries that don’t utilize database features can cost developers a lot. The cost varies from spending more time writing tedious long queries or having a tech debt later on to debug the performance issue coming from the database server. PostgreSQL has features that help you select data efficiently…

Databases can be accessed in Python through a database connector where you can write SQL queries as you do in a SQL client. …