Geek Logbook

Tech sea log book

Recent Posts

Categories

#50projectsIn50days Airflow Amazon Web Services Apache Iceberg AWS Azure bash Batch CAP Coders At Work Data data lakes Data Pipelines Data Warehouse Docker Edsger W. Dijkstra Excel Git Hadoop HDFS Hellerstein Hive Javascript Networking NoSql PostHog Postman Power Bi Powershell Pyspark Python Redash S3 Social Skills Software Developer Spark Spark: The Definitive Guide SQL SSH terraform Testing The Elements of Programming Style Understanding Distributed Systems whale-alert Yaml

Archives

Category: Programming

Different posts about programming in general

Understanding Idempotency in Python with Simple Examples

Idempotency is a fundamental concept in computing that describes operations which produce the same result no matter how many times they are performed. In this blog post, we’ll explore idempotency through the lens of Python, diving into its significance and providing examples that highlight the difference between idempotent and non-idempotent operations. What is Idempotency? In
Read More

Best Practices: Using Direct SQL Queries in CodeIgniter

In this blog post, we’ll discuss the pros and cons of using direct SQL queries in CodeIgniter and explore alternatives that enhance security, readability, and maintainability. What is Direct SQL? Direct SQL means writing raw SQL queries directly in your code. It provides full control over the SQL, which can be appealing for quick queries
Read More

Renaming Modules in Python for Clarity and Accuracy

Renaming modules in Python is an essential practice to improve code clarity and maintainability, especially as projects grow in complexity. Using intuitive and descriptive names helps in quickly understanding the purpose of each module, reducing confusion and potential errors during development. In this post, we’ll explore the process of renaming a module in Python and
Read More

Counting Covered Points on a Number Line

Introduction Algorithmic challenges often involve intervals and can initially seem complex. One such problem is determining how many unique points are covered by a set of intervals on a number line. In this post, we’ll examine a solution to this problem and explore potential improvements. Problem Statement Given a number line with several intervals representing
Read More

Implementing Retries in Python

In many real-world applications, simply handling an error isn’t always enough. Sometimes, the failure is temporary, and retrying the operation can help resolve the issue. In this post, we’ll explore how to implement retries in Python, improving the robustness of our programs. Why Implement Retries? Let’s imagine you’re making a request to an external API
Read More

Customizing Legends in Seaborn Boxplots: A Guide

Creating clear and informative visualizations is key to effectively communicating data insights. In this post, we will explore how to customize legends in Seaborn boxplots, ensuring that the labels and colors are both informative and accurate. Specifically, we’ll look at how to manually set the legend labels while maintaining the correct color associations in a
Read More

Comparing Window Functions with Aggregate Functions in SQL

Introduction SQL is a powerful language for querying and manipulating data, and both window functions and aggregate functions are central to its capabilities. While they serve related purposes, they are used in different contexts and have distinct features. Understanding how window functions and aggregate functions differ is crucial for writing effective SQL queries and performing
Read More

Defining Custom Window Frames in SQL Server

Introduction Window functions in SQL Server are powerful tools that allow for advanced data analysis within queries. One of the key features of window functions is the ability to define custom window frames using the OVER() clause. This customization allows you to specify exactly which rows are included in the calculation, offering flexibility for various
Read More