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

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

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

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

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…