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. I will show you a case study to know how…

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 this tutorial, you’ll know how to get countries that have trends on Twitter and also get insights about what topics are trending the…

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. Writing these queries can be complex and error-prone–especially when you are using a language like Python where all data you deal with are objects or relations between…

A window function is a feature developed in PostgreSQL — available since version 8.4 — to analyze data beyond the current row (hence the term “window”). These windows can aggregate information to each row of your output. Apart from aggregate functions and groupings, window functions provide another way to perform…

Monitoring PostgreSQL performance is essential if you want to have a highly-performant app. To do so, there are tools to leverage to be able to detect slow-running queries and take action. In this tutorial, we will dig deep into the pg_stat_statements extension. You will not only detect slow-running queries, but…

Practical tips to follow when you design your database for boosting performance — PostgreSQL performance starts right away at the data modeling phase. When you start designing your tables, PostgreSQL optimizer adapts to your changes and hence boost your database performance or hurt it. In this PostgreSQL tutorial, you will learn how database design matters in PostgreSQL performance tuning. You'll gain insights about…

Replacing characters in strings using Python can be done with multiple ways. In this quick tutorial, you'll learn how to use the replace method to manipulate strings. You'll learn through examples how to replace a character in a string, how to replace multiple characters in a string, and how to…