profile

The Friday Loop

DuckDB: SQL and DataFrames Just Got Married | Issue #39

Published 10 months ago • 2 min read

Hi there,

​

Ever wish you could combine the simplicity of SQL with the flexibility of DataFrames? Meet DuckDB—a tiny, analytics-focused database that works wonders for anyone wrangling data. 🦆✨

​

In this week’s video, I explore:

​

  • Why DuckDB is perfect for analytical workloads
  • How it seamlessly integrates with tools like Pandas
  • The difference between in-memory and persistent storage

​

If you’re tired of clunky workflows and want a lightweight, powerful solution, this is a tool you need to see in action. 🚀

​

Cheers,

Arjan

​

# News

Burnout: It's Not Just About Overworking! 🔥

Matheus Lima’s article, completely reshaped my understanding of burnout. It’s not just about working long hours — it’s about how we work, the systems we navigate, and the expectations we carry.

The piece dives into the real drivers of burnout, like mismatched priorities, lack of control, and the relentless pressure to “do more with less.” 🚨 It’s a wake-up call to rethink not only workplace culture but also our personal boundaries and habits.

It’s a refreshing, empowering perspective for anyone feeling overwhelmed in today’s fast-paced world. 👉 Read the full article here.

Secure Coding Practices in Agile Development

Integrating secure coding practices into agile development doesn’t have to be a headache. 🤯

​This article breaks it down with actionable advice—like kicking off security efforts early, leveraging automated tools to spot vulnerabilities fast, and turning security into a collaborative, iterative part of your workflow. ✨ Check it out here.

# Community

Gabe, a member of the ArjanCodes Discord, was struggling to debug a Flask app in VSCode. No matter what they tried, the usual step-by-step debugging wouldn’t work. Why? Flask behaves differently, and the solution wasn’t as straightforward as expected.

That’s when the community stepped in with insights that completely changed the approach. From a better way to track variables to a key tweak in the Flask setup, the discussion led to a breakthrough.

Curious how Gabe finally solved it? Join the conversation in Discord and see for yourself! 🚀! 🎉

Do you enjoy my content on YouTube and would you like to dive in deeper? Check out my online courses below. They've helped thousands of developers take the next step in their careers.

🚀 The Mindset Online Course Series

The goal of this series is to help junior developers grow their skills to become senior developers faster.

💥 Other Courses

💡 If you’re part of a development team at a company, I offer special packages for companies that give your team the tools to consistently write high-quality code and dramatically increase your team's productivity.

​Unsubscribe | Send by ArjanCodes

Wolvenplein 25, Utrecht, UT 3512 CK

The Friday Loop

by ArjanCodes

Every Friday, you'll get a recap of the most important and exciting Python and coding news. The Friday Loop also keeps everyone posted on new ArjanCodes courses and any limited offers coming up.

Read more from The Friday Loop

Have you ever written a Python script that felt slow, even though the logic was simple? Sometimes it’s not the efficiency of your code that's the problem, it’s when your code does its work. This week’s video is all about the Lazy Loading design pattern, and I think many developers underestimate how powerful (and practical) it is. I start with a real example: loading a huge CSV file that freezes your program for 10 seconds before doing anything useful. Then, step by step, we improve it using:...

4 days ago • 1 min read

If your code is hard to test, hard to reuse, and hard to change, you’re probably hardcoding your dependencies. It’s one of the most common architectural problems I see in Python code, even in production systems. In this week's video, I take a small but realistic example, a data pipeline that loads, transforms, and exports some records, and show you how Dependency Injection can turn it from a rigid mess into something clean, testable, and modular. No frameworks required. You’ll learn: Why...

11 days ago • 1 min read

Hi there, Most apps only store the final result: the current balance, the current inventory, the current status. But what if you could track every change that led to that result? That’s exactly what the event sourcing pattern allows you to do. Instead of overwriting state, you store a sequence of immutable events and derive the current state by replaying them. It’s like Git (kinda), but for your domain logic. In this week’s video, I show you how to implement event sourcing in Python from...

18 days ago • 1 min read